Connection reference for Databricks

You need specific information to establish a seamless and secure connection. The following fields are required, except where noted.

Databricks-managed passwords will reach end of life on July 10, 2024. You will no longer be able to use Databricks-managed passwords to authenticate to Databricks, known as basic authentication, after July 10, 2024. You can log in using OAuth or Service Account.

If your Databricks is hosted on Microsoft Azure, see Databricks on Microsoft Azure connection reference.

Connection name

Enter a new Databricks connection name.

Connection description

Provide a short description of the connection. (Optional)

Host

Enter the Databricks server host name without the protocol. You can find this in the connection details of your SQL warehouse.

Example

example.cloud.databricks.com

HTTP Path

Enter the Databricks HTTP path. You can find this in the connection details of your SQL warehouse.

(Service account only) User

Email address associated with your Databricks account.

(Service account only) Password

Specify the password of the Databricks account. You can also use your ‘personal access token’ generated in Databricks. For more information, see Generate a personal access token.

(OAuth and OAuth with PKCE only) OAuth Client ID

Specify the OAuth client ID.

(OAuth and OAuth with PKCE only) OAuth Client Secret

Specify the OAuth client secret.

(OAuth and OAuth with PKCE only) Scope

Specify the scope.

(OAuth and OAuth with PKCE only) Auth Url

Specify the auth url.

(OAuth and OAuth with PKCE only) Access token Url

Specify the access token url.

Catalog

Specify the catalog. (Optional)

Example

sample_db

Databricks on Microsoft Azure connection reference

Connection name

Enter a new Databricks connection name.

Connection description

Provide a short description of the connection. (Optional)

Host

Enter the Databricks server hostname. For more information, see Get server hostname, port, HTTP path, and JDBC URL.

Example

abc-1234567890123456.78.azuredatabricks.net

HTTP Path

Enter the Databricks HTTP path. For more information, see Get server hostname, port, HTTP path, and JDBC URL.

Example

sql/protocolv1/o/1234567890123456/7890-123456-abc789

(Service account only) User

Enter your login email to your Azure account. If this does not work, try “token”.

(Service account only) Password

Enter your ‘personal access token’ generated in Databricks. This is not the password for your Azure account. For more information, see Generate a personal access token.

(OAuth and OAuth with PKCE only) OAuth Client ID

Specify the OAuth client ID.

(OAuth and OAuth with PKCE only) OAuth Client Secret

Specify the OAuth client secret.

(OAuth and OAuth with PKCE only) Scope

Specify the scope.

(OAuth and OAuth with PKCE only) Auth Url

Specify the auth url.

(OAuth and OAuth with PKCE only) Access token Url

Specify the access token url.

Catalog

Specify the catalog. (Optional)

Example

sample_db



Was this page helpful?