There are two ways to connect Mode Analytics to Honeydew:

  1. Via a JDBC connection, using the Trino protocol
  2. Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application

​
Setting up a new Trino Database Connection

Mode 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 Connect a database
  2. Search Trino from the full list of supported databases
  3. Set a Display name for the connection, and optionally provide a description
  4. Set Host to jdbc.honeydew.cloud and Port to 443
  5. Set Default 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. In Preferred JDBC Driver, select the latest version of the Trino driver
  7. Check the “Use Authentication” box
  8. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  9. Click Connect

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 queries or create reports on top of 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. In query editor for a new query/report, use the Honeydew Snowflake Native Application query interfaces (SELECT_FROM_FIELDS or SELECT_FROM_QUERY) to query the data.