Databricks API Configuration

Request

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

{
  "group_id": "group_id",
  "service": "databricks",
  "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": {
    "auth_type": "PERSONAL_ACCESS_TOKEN | OAUTH2",
    "create_external_tables": true,
    "connection_type": "Directly | PrivateLink",
    "port": 443,
    "catalog": "string",
    "http_path": "sql/protocolv1/o/2873663545782684434-15262-272625-fives565",
    "cloud_provider": "AZURE | GCP | AWS",
    "oauth2_secret": "your_oauth_secret",
    "oauth2_client_id": "your_oauth_client_id",
    "server_host_name": "87a8z-3da23-3da8d-cloud.databricks.com",
    "personal_access_token": "your_databricks_personal_access_token",
    "external_location": "/some_external_location"
  }
}

Config parameters

Name	Description
`auth_type`	Authentication type
`create_external_tables`	Whether to create external tables
`connection_type`
`port`	Server port number
`catalog`	Catalog name
`http_path`	HTTP path
`cloud_provider`	Databricks deployment cloud
`oauth2_secret`	OAuth 2.0 secret
`oauth2_client_id`	OAuth 2.0 client ID
`server_host_name`	Server name
`personal_access_token`	Personal access token
`external_location`	External location to store Delta tables. Default value: `""` (null). By default, the external tables will reside in the `/{schema}/{table}` path, and if you specify an external location in the `{externalLocation}/{schema}/{table}` path.