Setup in Databricks
1. Find your Databricks workspace URL
The workspace hostname is the domain you see in your browser when you are logged into your Databricks workspace, for exampledbc-a1b2c3d4-e5f6.cloud.databricks.com.
You can also find it from the Account Console:
- Go to the Databricks Account Console (on Azure, use the Azure portal).
- In the left sidebar, click Workspaces.
- Click the workspace you want to connect.
- On the Configuration tab, the workspace URL is displayed at the top of the page, next to the workspace status. It also appears under Networking > Connectivity > Per-workspace URL.
- Copy the URL without the trailing slash, for example
https://dbc-a1b2c3d4-e5f6.cloud.databricks.com.
Use the workspace URL (where you open notebooks), not the Account Console
URL (
accounts.cloud.databricks.com). If your organization has several
workspaces, pick the one containing the data you want to expose to agents.2. Create an App Connection
- Open the Databricks Account Console.
- Go to Settings > App Connections.
- Click Add connection.
-
Give the connection a descriptive name, such as
Dust MCP. -
Add the two Dust OAuth redirect URLs for your workspace region:
US workspaces:
EU workspaces:
- Keep Generate a client secret enabled. Dust uses the client ID and client secret when connecting to Databricks.
-
Add the scopes required by the tools you want to use:
- Databricks SQL:
sqlandoffline_access - Databricks Genie:
genieandoffline_access - If you use both tools, add both
sqlandgenie, together withoffline_access.
- Databricks SQL:
- Create the connection and copy its client ID and client secret. You will enter them in Dust.
3. Verify Databricks permissions
Make sure the users authenticating through Dust can access the relevant Databricks resources:- For Databricks Genie, the relevant Genie resources and underlying data.
- For Databricks SQL, the required Unity Catalog catalogs, schemas, tables, and SQL warehouses.
Setup in Dust
- In your Dust workspace, go to Spaces > Tools > Add Tools.
- Select Databricks SQL or Databricks Genie.
- Enter your Databricks workspace URL, for example:
https://your-workspace.cloud.databricks.com - Enter the client ID and client secret from the Databricks App Connection.
- Click Connect.
- SQL:
https://<workspace-hostname>/api/2.0/mcp/sql - Genie:
https://<workspace-hostname>/api/2.0/mcp/genie