Connect to Unity Catalog

  1. Select your workspace and click the Catalog option in the sidebar to create a Unity Catalog.

  2. Click Create Catalog

  3. Provide a name to your Catalog and select metastore as Unity from the dropdown option.

  4. To establish a connection provide the required inputs:

    • DataBricks Hostname - The hostname can be obtained from the Databricks URL, which starts with "dbc" and ends with ".com".

    • DataBricks Unity Catalog Name - This is the name of the Unity Catalog registered in Databricks Unity. It can be found under the Catalog section.

    • DataBricks Access Token - To create a Databricks personal access token for your Databricks workspace user, refer to this documentation.

  5. Click on Validate after providing the inputs.

  6. Next, select the databases/schemas you want to run the queries on from your metastore. This selection can be changed later.

  7. To enable automatic catalog updates, toggle on the auto-refresh option and set the desired time interval for catalog updates. Remember, you can always adjust this selection and interval later.

  8. If you do not require auto-refresh for your catalog, you can proceed to the next step.

  9. If all the settings are correct, click on Create.

  10. You will be redirected to your catalog listing screen. Successful creation will change your catalog status from PENDING to ACTIVE.

    • In case the catalog has not been created there will be an error that you can see on hovering over the status bar. We have listed the errors that you can encounter while creating a catalog on the catalog errors.

Last updated