--- title: "Databricks Configuration" slug: "databricks-configuration" updated: 2026-01-12T16:36:08Z published: 2026-01-12T16:36:08Z canonical: "help.gong.io/databricks-configuration" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.gong.io/llms.txt > Use this file to discover all available pages before exploring further. # Databricks Configuration > {{variable.Who can use this}} {{glossary.Tech admin}} > {{variable.Available on}} {{glossary.Data Cloud}} ## Prerequisites - [ ] By default, this Databricks integration makes use of Unity Catalog data governance features. You will need Unity Catalog enabled on your Databricks Workspace. ## Step 1: Create a SQL warehouse Create a new SQL warehouse for data writing. 1. Log in to the Databricks account. 2. In the navigation pane, click into the workspace dropdown and select **SQL**. 3. In the SQL console, in the SQL navigation pane, click **Create** and then **SQL warehouse**. 4. In the New SQL Warehouse menu, choose a **name** and **configure the options** for the new SQL warehouse. Under "Advanced options" turn "Unity Catalog" to the **On** position, select the **Preview** channel, and click **Create**. ![](https://storage.googleapis.com/prequel_docs/images/databricks-new-sql-endpoint.png "new_sql_endpoint.png") ## Step 2: Configure Access Collect connection information and create an access token for the data transfer service. 1. In the **SQL Warehouses** console, select the SQL warehouse you created in **Step 1**. ![](https://storage.googleapis.com/prequel_docs/images/databricks-endpoints-console.png "endpoints_console.png") 2. Click the **Connection Details** tab, and make a note of the **Server hostname**, **Port**, and **HTTP path**. ![](https://storage.googleapis.com/prequel_docs/images/databricks-server-port-path.png "server_port_path.png") 3. Click the link to Create a **personal access token**. ![](https://storage.googleapis.com/prequel_docs/images/databricks-create-personal-access-token.png "create_a_personal_access_token.png") 4. Click **Generate New Token**. ![](https://storage.googleapis.com/prequel_docs/images/databricks-generate-new-token.png "create_new_token.png") 5. Name the token with a descriptive comment and assign the token lifetime. A longer lifetime will ensure you do not have to update the token as often. Click **Generate**. 6. In the pop up that follows, **copy the token** and securely save the token. > 📘 **Using a Service Principal & Token instead of your Personal Access Token** > > You may prefer to create a **Service Principal** to use for authentication instead of using a Personal Access Token. To do so, use the following steps to create a Service Principal and generate an access token. > > 1. In your Databricks workspace, click your username in the top right, click **Admin Settings**, **Identity and access**, and next to the **Service Principals** options, click **Manage**. > 2. Click the **Add service principal** button, click **Add new** in the modal, enter a display name and click **Add**. > 3. Click on the newly created Service Principal, and under **Entitlements** select **Databricks SQL Access** and **Workspace Access**. Click **Update**, and make a note of the **Application ID** of your newly created Service Principal. > 4. Back in the **Admin Settings** menu, click the **Advanced** section (under the **Workspace admin** menu). In the **Access Control** section, next to the **Personal Access Tokens** row, click **Permission Settings**. Search for and select the **Service Principal** you created, select the **Can use** permission, click **Add**, and then **Save**. > 5. Navigate back to the **SQL Warehouses** section of your Workspace, click the **SQL Warehouses** tab, and select the **SQL Warehouse** you created in **Step 1**. Click **Permissions** in the top right, search for and select the **Service Principal** you created, select the **Can use** permission, and click **Add**. > 6. Use your terminal to generate a **Service Principal Access Token** using your Personal Access Token generated above. Record the **token value**. This token can now be used as the access token for the connection. > > ```curl cURL request > curl --request POST "https://.cloud.databricks.com/api/2.0/token-management/on-behalf-of/tokens" \ > --header "Authorization: Bearer " \ > --data '{ > "application_id": "", > "lifetime_seconds": , > "comment": "" > }' > ``` 7. In the Databricks UI, select the **Catalog** tab, and select the target **Catalog**. Within the catalog **Permissions** tab, click **Grant**. In the following modal, select the **principal** for which you generated the access token, select `USE CATALOG`, and click **Grant**. 8. Under the target **Catalog**, select the target **schema** (e.g., `main.default`, or create a new target schema). Within the schema **Permissions** tab, click **Grant**. In the following modal, select the **principal** for which you generated the access token, and select either `ALL PRIVILEGES` or the following 9 privileges and then click **Grant**: - `USE SCHEMA` - `APPLY TAG` - `MODIFY` - `READ VOLUME` - `SELECT` - `WRITE VOLUME` - `CREATE MATERIALIZED VIEW` - `CREATE TABLE` - `CREATE VOLUME` ## Step 3: Connect Gong to Databricks Once you have configured Databricks, use the fields to set up the connection in Gong: 1. In Gong, go to **Admin center** > **Settings** > **Data Cloud** > **Data cloud settings**. 2. Select **Databricks**. 3. Enter the following details * **Server hostname** * **Port** * **Catalog** * **Schema** * **HTTP path** * **Personal access token** 4. Click **Connect**. It may take a few minutes to complete the connection. ## Related - [Database design](/database-design.md) - [Forecast and Gong user tables](/forecast-and-gong-user-tables.md)