Databricks

The Databricks connector allows connection to Databricks clusters and querying data stored in the Delta Lake format. This connector makes it possible to connect Studio to Databricks, enabling efficient data retrieval and querying.

For more information, refer to the data connector user guide.

Configuring Databricks Connector

When adding a Databricks Data Connector, use the form below to configure your connector.

To create Databricks Connector, the following fields are required

1. Name - Enter a name for your connector.
2. Description (Optional) - Enter a description for your connector.
3. Host Server - Server hostname for your Databricks cluster (can be found in Advanced Options).
4. Path - HTTP path for your Databricks cluster (can be found in Advanced Options).
5. Default Catalog - Default catalog for your Databricks cluster.
6. Default Schema - Default schema for your Databricks catalog.
7. Token - Token generated in Databricks User Settings.

With the exception of the option Description, all other fields are required.
Use the Test Connection button to test the connection after all required fields have been filled.
Click on the Confirm button to create a new Databricks connector.

Finding Host server and Path

To find your Server Hostname and HTTP Path:

1. Login to your Databricks Management Console.
2. In left sidebar click on Compute and select cluster you want to connect to.
3. Scroll down to Advanced options and expand it.

4. Select JDBC/ODBC tab and copy values for Server Hostname and HTTP Path to required connector fields.

Generating Databricks token

To generate Token:

1. Login to your Databricks Management Console.
2. In top right corner click on username and choose User Settings.
3. In left sidebar choose Developer option.

4. In Access tokens field click on Mange.

5. Click on Generate new token and copy created Token to required connector field.