There are two ways to connect Redash to Honeydew:
  1. Via a JDBC connection, using the Presto protocol
  2. Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application

​
Setting up a new Presto Data Source

Redash data sources 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 Sources ** and click on New Data Source
  2. Search Presto from the full list of supported databases
  3. Set a Name for the data source
  4. Set Host to jdbc.honeydew.cloud
  5. Set Protocol to https
  6. Set Port to 443
  7. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  8. 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.
  9. Click Create
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 create queries and dashboards 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 data source 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.