Skip to content

Databricks

Databricks is generally available in the DataSquares connection wizard. Connect a SQL Warehouse with its HTTP path and an access token.

  1. In DataSquares, open Data Sources and choose Add data source.

  2. Pick Databricks in the connector picker (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

Field What to enter
Workspace host Your Databricks workspace URL (e.g. adb-1234.5.azuredatabricks.net).
HTTP path The SQL Warehouse’s HTTP path (from the warehouse’s Connection details tab).
Access token A personal access token with permission to use the warehouse.

All three fields come from Databricks:

  • Workspace host — your workspace URL without https:// (e.g. adb-1234567890123456.7.azuredatabricks.net).
  • HTTP path — SQL Warehouses → your warehouse → Connection details → HTTP path (looks like /sql/1.0/warehouses/abc123…).
  • Access token — User Settings → Developer → Access tokens → Generate new token (or a service principal’s token).

The token’s identity needs CAN USE on the SQL Warehouse and SELECT on the catalogs/schemas you’ll query.

Error Cause / fix
403 Invalid access token token expired or revoked — generate a new one and edit the source
Endpoint not found the HTTP path points at a deleted warehouse, or it’s a cluster path instead of a SQL Warehouse path
slow first query the SQL Warehouse is auto-starting from cold — subsequent queries are fast