Skip to main content

​
Connection Modes

There are two ways to connect Hex to Honeydew:
  1. Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application
  2. Via a Trino connection, using the SQL interface

​
Connection Setup

​
Setting up a New Trino Data Connection

Hex database connections are mapped to a Honeydew workspace and branch
It is recommended to use an API Key for setting up the connection.
  1. Go to Data browser and add a new data connection
  2. Choose Trino from the list of supported databases
  3. Set a unique Name for the connection
  4. Set Host to jdbc.honeydew.cloud and port to 443
  5. Set Catalog to <workspace>__<branch> value, based on the Honeydew workspace and branch you would like to connect to. Omit the branch value if connecting to prod. For example, for workspace tpch, branch prod, the value would be: tpch. And for workspace tpch, branch dev, it would be tpch__dev.
  6. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  7. Click Create Connection
If your organization uses a custom hostname for the JDBC connection, you can locate it in the Honeydew UI, under the JDBC section in Settings.
You can now run SQL queries in Hex using the Honeydew data connection, just like with any other data connection. For more information on how to use the Honeydew SQL interface, refer to this section.

​
Connecting via Snowflake Connection using the Snowflake Native Application

  1. Create a Snowflake database connection in the account where you have the Honeydew Snowflake Native Application installed
  2. Run SQL queries in Hex using the Honeydew Snowflake Native Application query interfaces (SELECT_FROM_FIELDS or SELECT_FROM_QUERY) to query the data.