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 Azure Databricks clusters.
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 Azure Databricks workspace.
The JDBC URL value for your SQL warehouse. To get this value, see Get connection details for an Azure Databricks compute resource.
An Azure Databricks personal access token or Microsoft Entra ID 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 Azure Databricks personal access token or Microsoft Entra ID token.
- Click Create connection.
Next steps
Explore one or more of the following resources on the Hex website: