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.
To connect your Databricks workspace to Hex using Partner Connect, see Connect to BI partners using Partner Connect.
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 you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens or personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.
To connect to Hex manually, do the following:
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.