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.

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 endpoint. Example: example.cloud.databricks.com

HTTP Path

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

(Service account only) User

Email address associated with your Databricks account.

(Service account only) Password

Specify the password of the Databricks account.

(OAuth only) OAuth Client ID

Specify the OAuth client ID.

(OAuth only) OAuth Client Secret

Specify the OAuth client secret.

(OAuth only) Scope

Specify the scope.

(OAuth only) Auth Url

Specify the auth url.

(OAuth only) Access token Url

Specify the access token url.

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

Specify the OAuth client ID.

(OAuth only) OAuth Client Secret

Specify the OAuth client secret.

(OAuth only) Scope

Specify the scope.

(OAuth only) Auth Url

Specify the auth url.

(OAuth only) Access token Url

Specify the access token url.