Skip to content

Databricks authentication

Note

This feature is available in Lite, Enterprise, Ultimate and Team editions only.

DBeaver is fully compatible with the Databricks OAuth and Personal Access Token (PAT) authentication methods, offering you secure ways to access your Databricks databases.

The following methods can be configured directly in the connection settings:

OAuth authentication

  1. From the Authentication dropdown menu, select OAuth.

  2. Depending on your use case, choose one of the following modes:

  3. Enter the required connection details.

  4. Click the Test Connection button to verify your settings. If configured correctly, DBeaver will establish a connection using the Databricks OAuth authentication method.

Machine to Machine

Use this method for automated service-to-service authentication. The access token is obtained programmatically using application credentials, so no manual user login is required at connection time.

You need to provide the HTTP Path of your Databricks SQL endpoint, Client ID and Client Secret for the application.

Info

For details, see OAuth machine-to-machine

User to Machine

Use this method when authentication must happen on behalf of a specific user.

You need to provide the HTTP Path of your Databricks SQL endpoint. No client credentials are required, the connection will open a browser window for login.

Info

For details, see OAuth user-to-machine

Personal Access Token

Use this method for direct authentication with a personal token generated in the Databricks workspace.

Follow these steps to configure Databricks Personal Access Token authentication:

  1. From the Authentication dropdown menu, select Personal Access Token.

  2. Enter the HTTP Path of your Databricks SQL endpoint.

  3. Paste your Personal Access Token into the corresponding field. You can generate a token in the Databricks workspace under User Settings → Access tokens.

  4. Click the Test Connection button to verify your settings. If configured correctly, DBeaver will establish a connection using the Databricks OAuth authentication method.

Info

For details, see Databricks - Personal access tokens

Other authentication methods

Besides OAuth and Personal Access Token, you can also use: