# Databricks (JDBC)

> Databricks (JDBC) - How to connect to Databricks using JDBC.

This Markdown file sits beside the HTML page at the same path (with a `.md` suffix). It summarizes the topic and lists links for tools and LLM context.

Companion generated at `2026-05-01T23:10:48.096589+00:00` (UTC).

## Primary page

- [Databricks (JDBC)](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html): Full documentation for this topic (HTML).

## Sections on this page

- [Supported authentication](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#supported-authentication): In-page section heading.
- [Prerequisites](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#prerequisites): In-page section heading.
- [Retrieve JDBC URL](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#retrieve-jdbc-url): In-page section heading.
- [Generate personal access token](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#generate-personal-access-token): In-page section heading.
- [Set up a connection in DataRobot](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#set-up-a-connection-in-datarobot): In-page section heading.
- [Required parameters](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#required-parameters): In-page section heading.
- [Troubleshooting](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-databricks.html#troubleshooting): In-page section heading.

## Related documentation

- [Reference documentation](https://docs.datarobot.com/en/docs/reference/index.html): Linked from this page.
- [Data reference](https://docs.datarobot.com/en/docs/reference/data-ref/index.html): Linked from this page.
- [Supported data stores](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/index.html): Linked from this page.
- [native Databricks connector](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/wb-databricks.html): Linked from this page.
- [creating a data connection](https://docs.datarobot.com/en/docs/classic-ui/data/connect-data/data-conn.html#create-a-new-connection): Linked from this page.
- [Allowed source IP addresses](https://docs.datarobot.com/en/docs/reference/data-ref/allowed-ips.html): Linked from this page.

## Documentation content

# 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. |