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.
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.
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 SQL warehouse.
A Databricks personal access token.
As a security best practice, when authenticating with automated tools, systems, scripts, and apps, Databricks recommends you use access tokens belonging to service principals instead of workspace users. To create access tokens for service principals, see Manage access 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.
Explore one or more of the following resources on the Hex website: