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.
- Personal Access Token
-
- Personal Access Token
-
Specify your Databricks 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.
- OAuth with Service Principal
-
- Service Principal UUID
-
Specify the Service Principal UUID.
- Service Principal OAuth Secret
-
Specify the Service Principal OAuth Secret.
- 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.
- 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
- 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
- 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.
