Snowflake API Configuration

Request

POST https://api.fivetran.com/v1/destinations

{
  "group_id": "group_id",
  "service": "snowflake",
  "region": "GCP_US_WEST1",
  "time_zone_offset": "+3",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "daylight_saving_time_enabled": true,
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "proxy_agent_id": "proxy_agent_id",
  "config": {
    "application_id": "string",
    "auth": "PASSWORD | KEY_PAIR | OAUTH",
    "aws_access_key_id": "string",
    "aws_bucket_auth_type": "IAM_ROLE | IAM_USER",
    "aws_secret_access_key": "string",
    "bucket": "string",
    "bucket_region": "string",
    "connection_type": "SshTunnel",
    "database": "fivetran",
    "default_virtual_warehouse": "VIRTUAL_WAREHOUSE",
    "directory_id": "string",
    "enable_external_storage_for_unstructured_files": true,
    "external_stage_storage_provider": "S3",
    "external_storage_cloud_provider": "AZURE | GCP | INTERNAL_STAGE | AWS",
    "external_storage_integration": "string",
    "external_storage_parent_folder_uri": "s3://fivetran-snowflake-integration/",
    "gcs_service_account_credentials": {},
    "gcs_service_account_credentials_path": "string",
    "host": "your-account.snowflakecomputing.com",
    "is_private_key_encrypted": true,
    "passphrase": "string",
    "password": "123456",
    "port": 443,
    "private_key": "string",
    "role": "string",
    "storage_account_key": "string",
    "storage_account_name": "string",
    "use_customer_staging": true,
    "user": "fivetran_user"
  }
}

Config parameters

Name	Description
`application_id`	Application ID of your app created in Azure
`auth`	Password-based or key-based authentication type
`aws_access_key_id`	The unique access key ID of the S3 bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment, want to use an S3 bucket to stage your data, and `awsBucketAuthType` is set to `IAM_USER`.
`aws_bucket_auth_type`	Type of authentication configured for the S3 bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an S3 bucket to stage your data.
`aws_secret_access_key`	The secret access key of the S3 bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment , want to use an S3 bucket to stage your data, and `awsBucketAuthType` is set to `IAM_USER`.
`bucket`	The name of the storage bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an S3 or GCS bucket to stage your data.
`bucket_region`	The AWS Region of the S3 bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an S3 bucket to stage your data.
`connection_type`	Connection method. Default value: `Directly`.
`database`	Database name
`default_virtual_warehouse`	The virtual warehouse to use for running queries.
`directory_id`	Tenant ID of your app created in Azure
`enable_external_storage_for_unstructured_files`	Set to `true` if you want to enable external storage for unstructured files.
`external_stage_storage_provider`	External stage storage provider[Internal, S3, Azure,GCS]
`external_storage_cloud_provider`	The cloud service provider you want to use for staging data. Use this parameter only if you are using Hybrid Deployment.
`external_storage_integration`	External storage integration name
`external_storage_parent_folder_uri`	External storage parent folder URL
`gcs_service_account_credentials`	The service account credentials for the Google Cloud Storage (GCS) bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use a GCS bucket to stage your data.
`gcs_service_account_credentials_path`	The path to the JSON file that contains the service account credentials for the GCS bucket you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use a GCS bucket to stage your data.
`host`	Server name
`is_private_key_encrypted`	Indicates that a private key is encrypted. The default value: `false`. The field can be specified if authentication type is `KEY_PAIR`.
`passphrase`	In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is `KEY_PAIR`.
`password`	Database user password. The field should be specified if authentication type is `PASSWORD`.
`port`	Server port number
`private_key`	Private access key. The field should be specified if authentication type is `KEY_PAIR`.
`role`	If not specified, Fivetran will use the user's default role
`storage_account_key`	The access key of the Azure storage account you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an Azure Blob storage container to stage your data.
`storage_account_name`	The name of the Azure storage account you want to use to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an Azure Blob storage container to stage your data.
`use_customer_staging`	Set to `true` if you want to use an S3 bucket to stage your data. Use this parameter only if you are using Hybrid Deployment and want to use an S3 bucket to stage your data.
`user`	Database user name