Databricks
Connect DataDrop to your Databricks workspace.
Prerequisites
- A Databricks workspace (AWS or Azure)
- A SQL warehouse or all-purpose cluster
- A personal access token (PAT) with SQL query permissions
- Network access from DataDrop to the Databricks workspace
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| server_hostname | Required | Databricks workspace hostname.e.g. adb-123456789.1.azuredatabricks.net |
| http_path | Required | HTTP path to the SQL warehouse or cluster.e.g. /sql/1.0/warehouses/abc123 |
| access_token | Optional | Personal access token. Either this or a Secret ARN is required.e.g. dapi... |
| token_secret | Optional | AWS Secrets Manager ARN storing the access token. |
| catalog | Optional | Unity Catalog name.e.g. main |
| schema | Optional | Default schema for queries.e.g. default |
Finding Your HTTP Path
To find the HTTP path for your SQL warehouse:
- Go to your Databricks workspace
- Navigate to SQL Warehouses
- Click on your warehouse
- Open the Connection Details tab
- Copy the HTTP Path value
It will look like /sql/1.0/warehouses/abc123
Unity Catalog
If your workspace uses Unity Catalog, specify the catalog and schema to set the default context for queries. DataDrop will use USE CATALOG and USE SCHEMA before running your query.