Honeydew can integrate with any Database Management tool & IDE, that support a JDBC connection using the Trino protocol. This includes tools such as Datagrip, DBeaver, Visual Studio Code and more.

Here are some general guidelines for connecting such a tool to Honeydew JDBC interface. The exact details might vary between the tools.

​
Setting up a New Trino Data Connection

It is recommended to use an API Key for setting up the connection.

  1. Create a new database connection
  2. Choose Trino from the list of supported databases (install the Trino driver, if missing).
  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.

Was this page helpful?

Redashdbt