# Connect your Databricks

In order to connect your Databricks instance, Whaly needs some credentials. This guide will details the necessary steps:

1. Getting your SQL Warehouse JDBC URL
2. Creation of a Personal Token

### Prerequisites <a href="#prerequisites" id="prerequisites"></a>

To connect Databricks to Whaly, you need the following:

* A Databricks Workspace with SQL support (premium and enterprise plans)
* A SQL Warehouse
* Admin rights on the Databricks Workspace

## Getting your SQL Warehouse JDBC URL

In order to connect to your Databricks Workspace, Whaly will need a SQL Warehouse and its JDBC URL:

* Go your Workspace home page
* In the left panel, select "SQL" to enter the SQL space of your Workspace

<figure><img src="https://34758050-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MC1g4I2_CgXd0qAq1P7%2Fuploads%2FH2R4OuvzueAGb7PlQMvG%2Fimage.png?alt=media&#x26;token=4f60e64f-dd55-45a0-b233-905beaeb9d5b" alt=""><figcaption></figcaption></figure>

* Once in the SQL space, click on "SQL Warehouses" in the left panel

<figure><img src="https://34758050-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MC1g4I2_CgXd0qAq1P7%2Fuploads%2Ff4b3jEekmUsAuG3sRNzQ%2Fimage.png?alt=media&#x26;token=2279ec94-e5db-489d-a115-aa7548831b57" alt=""><figcaption></figcaption></figure>

* In the SQL Warehouses screen, either create a dedicated Warehouse or select an existing one

<figure><img src="https://34758050-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MC1g4I2_CgXd0qAq1P7%2Fuploads%2Flyagd2LGaox0DzvfM7rY%2Fimage.png?alt=media&#x26;token=46e5c06c-6f9b-49fd-8a7b-f80edc08218f" alt=""><figcaption></figcaption></figure>

* Once in a Warehouse, click on "Connection details" tab and copy the JDBC URL

<figure><img src="https://34758050-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MC1g4I2_CgXd0qAq1P7%2Fuploads%2FrJ4OmjBSRV4o262GRlyM%2Fimage.png?alt=media&#x26;token=bc13add6-3982-4e40-ac49-2c8e30261365" alt=""><figcaption></figcaption></figure>

## Creation of a Personal Token

In order to authenticate on your Databricks Workspace, Whaly needs to have a "Personal Token". In order to create one, please [follow this guide.](https://docs.databricks.com/dev-tools/auth.html#pat)

You can either create a Personal Token on an existing user (simpler way) or create a Service principals and create the Personal Token on it (more secure way but requires doing manual API calls for setup).