Databricks

Prepare credentials

Generate a Personal Access Token

Visit Settings → User Settings, and then switch to Personal Access Tokens tab.

Then, click Generate new token. Save the generated token somewhere, we will need it later on.

Retrieve SQL endpoint settings

In SQL mode, navigate to SQL Endpoints.

Choose the preferred endpoint and copy the following fields values from its Connection Details tab:

• Server hostname

• HTTP path

Create a Data Source

By opening Admin → Settings at Datafold, you will automatically be directed to Data Sources tab. Click + New Data Source and choose Databricks. Connection parameters are in the lower part of the popup window.

Database parameter has the format of CATALOG_NAME.DATABASE_NAME.

In most cases, CATALOG_NAME is hive_metastore.

Click Save. Your data source is ready!

IP Whitelisting ->

After setting permissions in your data source, move on to Configuration ->