Connection reference for Databricks

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

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

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.
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. For more information, see Get connection details for a Databricks compute resource.

Example

example.cloud.databricks.com

HTTP Path

Enter the Databricks HTTP path. You can find this in the connection details of your SQL warehouse. For more information, see Where is the http path for my Databricks compute resource or Get connection details for a Databricks compute resource.

Service account
User

Email address associated with your Databricks account. Username and password authentication is known as Databricks basic authentication; it is possible only when single sign-on is disabled.

When using a Personal Access Token as a password, enter the User as 'token'.

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
OAuth Client ID

Specify the OAuth client ID.

OAuth Client Secret

Specify the OAuth client secret.

Scope

Specify the scope.

Auth Url

Specify the auth url.

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
User

Enter your login email to your Azure account.

When using a Personal Access Token as a password, enter the User as 'Token'.

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
OAuth Client ID

Specify the OAuth client ID.

OAuth Client Secret

Specify the OAuth client secret.

Scope

Specify the scope.

Auth Url

Specify the auth url.

Access token Url

Specify the access token url.

Catalog

Specify the catalog. (Optional)

Example

sample_db


Was this page helpful?