# Databricks (JDBC)
URL: https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html

> How to connect to Databricks using JDBC.

# Databricks (JDBC)

Connecting to Databricks using JDBC is currently certified through Azure.

> [!NOTE] Note
> This page describes how to connect to the Databricks JDBC driver, not the [native Databricks connector](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/wb-databricks.html).

## Supported authentication

- Access token

## Prerequisites

The following is required before connecting to Databricks in DataRobot:

- A Databricks workspace in the Azure Portal app
- Data stored in an Azure Databricks database

## Retrieve JDBC URL

In Microsoft Azure:

1. Log into your Azure Databricks workspace.
2. On the cluster's Configuration tab, expand Advanced options , click the JDBC/ODBC tab, and copy the JDBC URL .

See the [Azure Databricks documentation](https://learn.microsoft.com/en-us/azure/databricks/integrations/jdbc/compute).

## Generate personal access token

In Microsoft Azure, generate a personal access token for your Databricks workspace. This token will be used to authenticate your connection to Databricks in DataRobot.

See the [Azure Databricks documentation](https://learn.microsoft.com/en-us/azure/databricks/integrations/jdbc/authentication?source=recommendations#--azure-databricks-personal-access-token).

## Set up a connection in DataRobot

To connect to Databricks in DataRobot:

1. Follow the instructions forcreating a data connectionusing the appropriate Databricks driver andJDBC URL.
2. ClickTest Connection, to open theCredentialswindow. Enter youraccess tokenand a display name to save your credentials in DataRobot.

## Required parameters

The table below lists the minimum required fields to establish a connection with Databricks:

| Required field | Description | Documentation |
| --- | --- | --- |
| Connection configuration |  |  |
| JDBC URL | Combination of authentication settings, any driver capability settings, and compute resource settings. | Azure Databricks documentation |
| Credentials |  |  |
| Access token | Token used to authenticate your connection to Databricks in DataRobot. | Azure Databricks documentation |

## Troubleshooting

| Problem | Solution | Instructions |
| --- | --- | --- |
| When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. | Add all allowed IPs for DataRobot. | See Allowed source IP addresses. If you've already added the allowed IPs, check the existing IPs for completeness. |
| When using the Databricks driver for prediction writebacks, you receive the following error: java.sql.SQLException: [Databricks][JDBC](10040) Cannot use commit while Connection is in auto-commit mode. | Modify the JDBC URL. | Add ignoreTransactions=1 to the JDBC URL. |

---
