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 a BI and visualization partner solution using Partner Connect.

Note

Partner Connect only supports Databricks SQL warehouses for Hex. To connect a cluster in your Databricks workspace to Hex, connect to Hex manually.

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 SQL warehouse.

  • A Databricks personal access token.

    Note

    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. For more information, see Service principals for Databricks automation.

Steps to connect

To connect to Hex manually, do the following:

  1. Create a new Hex account, or sign in to your existing Hex account.

  2. On the Projects page, click New project.

  3. In the New Project dialog, enter a name for the project, and then click Create project.

  4. In the sidebar, click the database (Data sources) icon.

  5. Within Data Connections, click the Databricks icon.

  6. In the Add a data connection to Databricks dialog, enter a name for the connection.

  7. For JDBC URL, enter the JDBC URL value for your SQL warehouse.

  8. For Access Token, enter the Databricks personal access token.

  9. Click Create connection.

  10. Continue with Next steps.