Databricks Connection Guide

You need 4 pieces of information to connect Databricks with SimplyPut. We’ll walk you through how to get each credential below.

1. Host

We need to know the host of where you Databricks instance is located. This is the URL you use to access your Databricks workspace. For example, if you access your Databricks workspace at:

https://my-databricks-instance.cloud.databricks.com, then your host is my-databricks-instance.cloud.databricks.com.

2. Access Token

To authenticate with Databricks, you need to generate a personal access token. To generate a token, follow the steps below:

  1. Click on the user icon in the top right corner of your Databricks workspace.
  2. Click on Settings.
  3. Click on Developer in the left sidebar.
  4. Click on Generate New Token.
  5. Enter a comment to help you remember what this token is for.
  6. Click on Generate.
  7. Copy the token and save it in a secure place.

3. HTTP Path

This represents the API path of the cluster that can run the sql requests using SimplyPut. To get this path, follow the steps below:

  1. Click on Compute in the left bar on the main page.
  2. Choose the cluster that has access to the DB you want to query with.
  3. Scroll down to the Advanced Options on the bottom of that page.
  4. Click the JDBC/ODBCtab
  5. Copy the value from the HTTP Pathfield, and store it somewhere safe.

4. Database

Choose the database name from the Catalot that you want to query with SimplyPut.

With these pieces of information, you can now connect your Databricks instance with SimplyPut.

SimplyPut