Skip to main content

databricks-configure-connection-profile-validata

  • Connection Profile Name: Enter a unique name that identifies this connection profile.

  • Endpoint Type: Select Databricks.

  • Warehouse Link (Host): Enter the URL of the Azure Databricks SQL Warehouse endpoint.

  • Authentication Type: Select the authentication method: Personal Access Token (PAT), Manual OAuth, or Entra ID.

  • Catalog Name: Enter the Databricks catalog to query for data validation.

Personal Access Token properties

  • Personal Access Token: Enter the Databricks personal access token. Tokens typically expire after 90 days. The user associated with the token must have SELECT and DESCRIBE privileges on the tables being validated.

  • Connection URL: Enter the JDBC URL from the JDBC/ODBC tab of the Databricks SQL Warehouse connection details. If the URL starts with jdbc:spark://, change it to jdbc:databricks://.

Manual OAuth properties

  • Client ID: Enter the Azure AD application (service principal) ID.

  • Client Secret: Enter the secret generated in Azure AD for the application.

  • Tenant ID: Enter the Azure AD tenant (directory) identifier.

  • Refresh Token: Enter the OAuth refresh token used to renew access without reauthentication.

  • Connection URL: Enter the JDBC URL from the JDBC/ODBC tab of the Databricks SQL Warehouse connection details.

Entra ID properties

Click Sign in using Entra ID and log in with an Entra ID account that has SELECT and DESCRIBE privileges on the tables being validated.

  • Connection URL: Enter the JDBC URL from the JDBC/ODBC tab of the Databricks SQL Warehouse connection details. If the URL starts with jdbc:spark://, change it to jdbc:databricks://.

Note

Entra ID authentication requires interactive login and is not suitable for unattended or scheduled validation jobs. For automated scenarios, use Manual OAuth instead.