Prepare credentials

Generate a Personal Access Token

Visit SettingsUser 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 AdminSettings 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!