- Via a JDBC connection, using the Trino protocol
- 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 branchIt is recommended to use an API Key for setting up the connection.
- Go to Connect a database
- Search Trino from the full list of supported databases
- Set a Display name for the connection, and optionally provide a description
- Set Host to
jdbc.honeydew.cloud
and Port to443
- Set Default Catalog to
<workspace>__<branch>
value, based on the Honeydewworkspace
andbranch
you would like to connect to. Omit the branch value if connecting toprod
. For example, for workspacetpch
, branchprod
, the value would be:tpch
. And for workspacetpch
, branchdev
, it would betpch__dev
. - In Preferred JDBC Driver, select the latest version of the Trino driver
- Check the “Use Authentication” box
- Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
- 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.
Connecting via Snowflake Connection using the Snowflake Native Application
- Create a Snowflake database connection in the account where you have the Honeydew Snowflake Native Application installed
- In query editor for a new query/report, use the Honeydew Snowflake Native Application
query interfaces (
SELECT_FROM_FIELDS
orSELECT_FROM_QUERY
) to query the data.