Note

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

Table of contents

• OAuth authentication
  • Machine to Machine
  • User to Machine
• Personal Access Token
• Other authentication methods

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:

   • Machine to Machine - for service-to-service authentication
   • User to Machine - for interactive user login

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.

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.

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.

For details, see
Databricks - Personal access tokens

Other authentication methods

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

• Username/password
• DBeaver Profile authentication