Connect to Hex

Hex is a modern data workspace. It makes it easy to connect to data, analyze it in collaborative SQL and Python-powered notebooks, and share work as interactive data apps and stories. Hex has three major elements:

Logic View, a notebook-based interface where you can develop your analysis.
App Builder, an integrated interface builder, where you can arrange elements from the Logic View into an interactive app.
Share, where you can invite stakeholders, customers, and team members to collaborate on and interact with your analysis.

You can integrate your Databricks SQL warehouses (formerly Databricks SQL endpoints) with Hex.

Note

Hex does not integrate with Databricks clusters.

Connect to Hex using Partner Connect

To connect your Databricks workspace to Hex using Partner Connect, see Connect to BI partners using Partner Connect.

Connect to Hex manually

This section describes how to connect an existing SQL warehouse to Hex manually.

Requirements

Before you integrate with Hex manually, you must have the following:

A Databricks SQL warehouse in your Databricks workspace.
The JDBC URL value for your SQL warehouse. To get this value, see Get connection details for a Databricks compute resource.
A Databricks personal access token.

Note

As a security best practice, when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.

Steps to connect

To connect to Hex manually, do the following:

Create a new Hex account, or sign in to your existing Hex account.
On the Projects page, click New project.
In the New Project dialog, enter a name for the project, and then click Create project.
In the sidebar, click the database (Data sources) icon.
Within Data Connections, click the Databricks icon.
In the Add a data connection to Databricks dialog, enter a name for the connection.
For JDBC URL, enter the JDBC URL value for your SQL warehouse.
For Access Token, enter the Databricks personal access token.
Click Create connection.

Next steps

Explore one or more of the following resources on the Hex website: