Databricks Connection Guide

To connect Databricks with SimplyPut, you will need the following information:

  • Server Hostname and HTTP Path
  • Access Token
  • Database Name

We’ll guide you through obtaining each of these credentials below.

1. Server Hostname and HTTP Path

The Server Hostname and HTTP Path are required to connect to your Databricks compute resource. You can obtain these details from either a Databricks Cluster or a Databricks SQL Warehouse.

From a Databricks Cluster:

  1. Log in to your Databricks workspace.
  2. In the sidebar, click Compute.
  3. In the list of clusters, click the name of the cluster you want to use.
  4. On the Configuration tab, expand Advanced options.
  5. Click the JDBC/ODBC tab.
  6. Copy the Server Hostname and HTTP Path values.

Screenshot showing how to find Server Hostname and HTTP Path from a Cluster

From a Databricks SQL Warehouse:

  1. Log in to your Databricks workspace.
  2. In the sidebar, click SQL > SQL Warehouses.
  3. Click the name of the SQL Warehouse you want to use.
  4. On the Connection Details tab, copy the Server Hostname and HTTP Path values.

Screenshot showing how to find Server Hostname and HTTP Path from a SQL Warehouse

2. Access Token

To authenticate with Databricks, you need to generate a personal access token (PAT) for your workspace user. Follow these steps:

  1. In your Databricks workspace, click your Databricks username in the top bar, and then select Settings from the drop-down menu.
  2. Click Developer.
  3. Next to Access Tokens, click Manage.
  4. Click Generate New Token.
  5. (Optional) Enter a comment to help you identify this token in the future, and change the token’s default lifetime of 90 days. To create a token with no lifetime (not recommended), leave the Lifetime (days) box empty.
  6. Click Generate.
  7. Copy the displayed token to a secure location, and then click Done. You won't be able to view it again.

Screenshot showing how to generate a new Access Token

3. Database/Schema Name

The Database/Schema Name is the name of the database you wish to query within Databricks. You can find this in the Catalog section of your workspace.

  1. In the sidebar, click Catalog.
  2. Browse through the catalogs to locate the database/schema you want to use with SimplyPut.

With the Server Hostname, HTTP Path, Access Token, and Database/Schema Name, you're now ready to connect your Databricks instance with SimplyPut.