Skip to content

On-premise users: click in-app to access the full platform documentation for your version of DataRobot.

Data > Data connections > Supported connections > Databricks (JDBC)

Databricks (JDBC)

Note

This page describes how to connect to the Databricks JDBC driver, not the native Databricks connector.

Connecting to Databricks using JDBC is currently certified through Azure.

Supported authentication

  • Access token

Prerequisites

The following is required before connecting to Databricks in DataRobot:

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.

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.

Set up a connection in DataRobot

To connect to Databricks in DataRobot:

  1. Follow the instructions for creating a data connection using the appropriate Databricks driver and JDBC URL.

  2. Click Test Connection, to open the Credentials window. Enter your access token and 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.
Updated February 16, 2024