Prerequisites for Connecting to Databricks Unity Catalog

In order to connect to Databricks Unity Catalog, it is required to provide the following parameters:

  • Server;
  • Access Token;
  • Warehouse ID.

This article details how to locate them in the Databricks Unity Catalog.

1. Locate Server Value

Access the Databricks Unity Catalog account

Your Databricks Unity Catalog account URL is the Server value in Metric Insights. Alternatively, you can copy it from Step 3.

2. Create Access Token

  1. Access the user menu.
  2. Go to Settings.
  3. Proceed to Developer.
  4. [Manage]

2.1. Provide Details

  1. [Generate new token]
  2. Comment: provide a descriptive phrase.
  3. Lifetime: specify the required lifetime. 90 days is a default value.
  4. [Generate]
  5. Copy the value to be used as Private Access Token in MI.

3. Locate Warehouse ID

  1. Go to SQL Warehouses.
  2. Access your warehouse.
  3. On the Connection details tab, find the Warehouse ID within the HTTP path.