How to configure a Databricks destination

  • Updated on Feb 13, 2026
  • Published on Feb 13, 2026
Prev Next

This guide provides instructions on how to locate the necessary credentials and identifiers to connect your Databricks Warehouse. To set up a connection, you will need to gather specific identifiers from Databricks before configuring the connection.

Early Access

Note that this destination is in early access - please reach out to our Supermetrics support team if you would like access to this destination.

Prerequisites

Server Hostname and Warehouse ID

These two values are found in the same location withint the SQL Warehouse settings.

  1. Log in to your Databricks Workspace.

  2. In the sidebar, click SQL Warehouses.

  3. Select the specific warehouse you want to connect to.

  4. Click the Connection details tab to find:

    1. Server Hostname: This will be listed, and it usually ends in azuredatabricks.net, cloud.databricks.com, or gcp.databricks.com

    2. Warehouse ID: This is the string of alphanumeric characters following HTTP Path (the part after /sql/1.0/warehouses/). Some connectors ask for the full HTTP Path, while others only ask for the Warehouse ID.

Catalog Name and Schema Name

These refer to your data hierarchy. In Databricks (Unity Catalog), the structure is Catalog > Schema > Table.

  1. In your Databricks Workspace, click Catalog in the sidebar.

  2. Catalog name: This is the top level of your data (the storage icon).

  3. Schema name: Click into your chosen Catalog. You will see a list of Schemas (formerly called “Databases”). The default schema is default, but you should select the schema that contains the specific tables you need.

Personal Access Token (PAT)

This acts as your password for the connection.

  1. Click your username or email in the top right corner of the Databricks UI.

  2. Select Settings.

  3. Go to the Developer section in the sidebar and click Access tokens and then select Manage.

  4. Click Generate new token.

  5. Give it a comment (for example: “Connection to Supermetrics“) and set an expiration date.

    Important to note: Copy the token immediately and save it in a secure location. You will not be able to see it again once you close the window.

Databricks configuration

The configuration stage of creating a new destination in Supermetrics Hub includes the following fields.

  1. Server Hostname can be found in the Connection details section of your SQL Warehouse.

  2. Warehouse ID can be found in the Connection details section of your SQL Warehouse.

  3. Catalog is obtained from Databricks Workspace when you click Catalog in the sidebar.

  4. Schema is obtained from Databricks Workspace when you click Catalog in the sidebar. Enter the schema name that contains the specific tables you need.

  5. Personal Access Token refers to the access token that you generated in the Databricks settings.

More resources