Databases & CRM

Set up Databricks SQL

Connect a Databricks Unity Catalog schema through a SQL warehouse. Tables become findable concepts, and tables with declared keys become situated records with exact rollups — over the Statement Execution API with a personal access token, no driver and no app registration. Read-only.

In Databricks click your avatar → Settings → Developer → Access tokens and generate a token.
Open SQL Warehouses → your warehouse → Connection details and copy the warehouse ID (pasting the whole HTTP path also works).
Documents → Databricks SQL: enter the workspace URL, the warehouse ID, the catalog and schema, and paste the token.
Choose access groups, Test, then Sync.

Unity Catalog is required — the legacy hive_metastore has no information_schema and can't be introspected. A serverless warehouse answers fastest; a stopped classic one may take a couple of minutes to wake on the first sync of the day. Declared (informational) primary keys are what turn a table's rows into records.

Was this page helpful?

Was this page helpful? Sign in with Google Sign in to tell us — or leave a comment.

Last updated 29 Aug 2026