Create destination
Creates a new destination within a specified group in your Fivetran account. IMPORTANT: Groups and destinations are mapped 1:1 to each other. We do this mapping using the group's id
value that we automatically generate when you create a group, and the destination's group_id
value that you specify when you create a destination. This means that you must create a group in your Fivetran account before you can create a destination in it.
Request schema
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
Request
The unique identifier for the group within the Fivetran system.
The name for the destination type within the Fivetran system.
Data processing location. This is where Fivetran will operate and run computation on data.
Determines the time zone for the Fivetran sync schedule.
Specifies whether we should trust the certificate automatically. The default value is FALSE. If a certificate is not trusted automatically, it has to be approved with Certificates Management API Approve a destination certificate.
Specifies whether we should trust the SSH fingerprint automatically. The default value is FALSE. If a fingerprint is not trusted automatically, it has to be approved with Certificates Management API Approve a destination fingerprint.
Specifies whether setup tests should be run automatically.
Shift my UTC offset with daylight savings time (US Only)
The unique identifier for the self-served private link that is used by the connection
Tenant id of service principal
Authentication type
(Immutable) Storage account for Azure Data Lake Storage Gen2 name
Connection method. Default value: Directly.
Catalog name
Should maintain tables in Databricks
HTTP path
OAuth 2.0 secret
Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
Server Host name
Client id of service principal
(Immutable) path/to/data within the container
(Immutable) Container to store delta table files
Server port number
Databricks Connection method. Default value: Directly.
Secret value for service principal
OAuth 2.0 client ID
Personal access token
POST /v1/destinations HTTP/1.1
Accept: application/json;version=2
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 1279
{
"group_id": "group_id",
"service": "adls",
"region": "GCP_US_WEST1",
"time_zone_offset": "+3",
"trust_certificates": true,
"trust_fingerprints": true,
"run_setup_tests": true,
"daylight_saving_time_enabled": true,
"local_processing_agent_id": "string",
"hybrid_deployment_agent_id": "string",
"private_link_id": "private_link_id",
"networking_method": "Directly",
"config": {
"tenant_id": "service_principal_tenant_id",
"auth_type": "PERSONAL_ACCESS_TOKEN | OAUTH2",
"storage_account_name": "adls_storage_account_name",
"connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
"catalog": "string",
"should_maintain_tables_in_databricks": true,
"http_path": "string",
"oauth2_secret": "string",
"snapshot_retention_period": "RETAIN_ALL_SNAPSHOTS | ONE_WEEK | TWO_WEEKS | FOUR_WEEKS | SIX_WEEKS",
"server_host_name": "string",
"client_id": "service_principal_client_id",
"prefix_path": "adls_container_path_prefix",
"container_name": "adls_container_name",
"port": 0,
"databricks_connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
"secret_value": "service_principal_secret_value",
"oauth2_client_id": "string",
"personal_access_token": "string"
}
}
Responses
Successful response schema
Response status code
Response status text
The unique identifier for the destination within the Fivetran system
The name for the destination type within the Fivetran system.
Data processing location. This is where Fivetran will operate and run computation on data.
Destination setup status
Shift my UTC offset with daylight savings time (US Only)
The unique identifier for the group within the Fivetran system.
Determines the time zone for the Fivetran sync schedule.
Setup tests results for this destination
Setup test title
Setup test status
Setup test message
Setup test details.
(Deprecated) The unique identifier for the hybrid deployment agent within the Fivetran system
The unique identifier for the self-served private link that is used by the connection
The unique identifier for the hybrid deployment agent within the Fivetran system
Tenant id of service principal
Authentication type
(Immutable) Storage account for Azure Data Lake Storage Gen2 name
Connection method. Default value: Directly.
Catalog name
Should maintain tables in Databricks
HTTP path
OAuth 2.0 secret
Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
Server Host name
Client id of service principal
(Immutable) path/to/data within the container
(Immutable) Container to store delta table files
Server port number
Databricks Connection method. Default value: Directly.
Secret value for service principal
OAuth 2.0 client ID
Personal access token
{
"code": "Created",
"message": "Operation performed.",
"data": {
"id": "destination_id",
"service": "adls",
"region": "GCP_US_EAST4",
"networking_method": "Directly",
"setup_status": "CONNECTED",
"daylight_saving_time_enabled": true,
"group_id": "group_id",
"time_zone_offset": "+3",
"setup_tests": [
{
"title": "Test Title",
"status": "PASSED",
"message": "Test Passed",
"details": "Test Details"
}
],
"local_processing_agent_id": "local_processing_agent_id",
"private_link_id": "private_link_id",
"hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
"config": {
"tenant_id": "service_principal_tenant_id",
"auth_type": "PERSONAL_ACCESS_TOKEN | OAUTH2",
"storage_account_name": "adls_storage_account_name",
"connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
"catalog": "string",
"should_maintain_tables_in_databricks": true,
"http_path": "string",
"oauth2_secret": "string",
"snapshot_retention_period": "RETAIN_ALL_SNAPSHOTS | ONE_WEEK | TWO_WEEKS | FOUR_WEEKS | SIX_WEEKS",
"server_host_name": "string",
"client_id": "service_principal_client_id",
"prefix_path": "adls_container_path_prefix",
"container_name": "adls_container_name",
"port": 0,
"databricks_connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
"secret_value": "service_principal_secret_value",
"oauth2_client_id": "string",
"personal_access_token": "string"
}
}
}