databricks_db API Configuration Beta
Request
POST https://api.fivetran.com/v1/connections
{ "group_id": "group_id", "service": "databricks_db", "trust_certificates": true, "trust_fingerprints": true, "run_setup_tests": true, "paused": false, "pause_after_trial": false, "sync_frequency": 1440, "data_delay_sensitivity": "NORMAL", "data_delay_threshold": 0, "daily_sync_time": "14:00", "schedule_type": "auto", "connect_card_config": { "redirect_uri": "https://your.site/path", "hide_setup_guide": true }, "proxy_agent_id": "proxy_agent_id", "private_link_id": "private_link_id", "networking_method": "Directly", "hybrid_deployment_agent_id": "hybrid_deployment_agent_id", "destination_configuration": { "virtual_warehouse": "virtual_warehouse" }, "config": { "port": 443, "auth": "TOKEN", "catalog": "catalog_name", "host": "dbc12345.cloud.databricks.com", "http_path": "/sql/1.0/warehouses/pathofsqlwarehouse", "personal_access_token": "personalaccesstoken", "schema_prefix": "prefix" } }
Config parameters
| Name | Description |
|---|---|
port | The port of your SQL warehouse. |
auth | Token-based authentication type |
catalog | catalog to sync |
host | The host URL for your Databricks account. |
http_path | http path |
personal_access_token | Access Token |
schema_prefix (required) | Destination schema prefix. Prefix for each replicated schema. For example with prefix 'x', source schemas 'foo' and 'bar' get replicated as 'x_foo' and 'x_bar'. The prefix is permanent and cannot be changed after connection creation |
Authorization
This type of connector can only be authorized through the Connect Card or through the Fivetran dashboard.