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
Related information
