Connect Databricks to the Knowledge Base
With the Databricks connector, you can connect a Databricks SQL warehouse to the Knowledge Base.
What you need
- The workspace host of your Databricks workspace.
- A Personal Access Token.
- The HTTP Path of your SQL warehouse.
- The catalog and schema to connect to.
Only Personal Access Tokens work. OAuth is not supported for the Databricks connector.
Connecting to Databricks
Open Project Settings
In your EKB project, navigate to Settings in the sidebar.
Go to Connections
Select the Connections tab and find the Databricks tile under Databases.
Open the Databricks popup
Click the Databricks tile. A popup appears with the option to connect a Databricks SQL warehouse. Click + Add Connection.
Fill in the connection form
Enter the following details. All fields are required.
Field Required Description Connection Name Yes A display name for this connection (e.g. My Databricks Connection).Workspace Host Yes The hostname of your Databricks workspace (e.g. dbc-xxxx.cloud.databricks.com).Personal Access Token Yes A Databricks Personal Access Token. HTTP Path Yes The HTTP path of your SQL warehouse (e.g. /sql/1.0/warehouses/<warehouse-id>).Catalog Yes The catalog name. Find it in Catalog Explorer, or run SHOW CATALOGS;in a SQL warehouse.Schema Yes The schema under that catalog. Find it in Catalog Explorer, or run SHOW SCHEMAS IN <catalog>;.Save the connection
Click Save. EKB will authenticate using the details provided. If successful, the Databricks tile on the Connections page will display a green dot and a count of your active Databricks connections.