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.