- Via a JDBC connection, using the Presto protocol
- 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 branchIt is recommended to use an API Key for setting up the connection.
- Go to **Data Sources ** and click on New Data Source
- Search Presto from the full list of supported databases
- Set a Name for the data source
- Set Host to
jdbc.honeydew.cloud - Set Protocol to
https - Set Port to
443 - Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
- Set Catalog to
<workspace>__<branch>value, based on the Honeydewworkspaceandbranchyou 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. - 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.
Connecting via Snowflake Connection using the Snowflake Native Application
- Create a Snowflake data source 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_FIELDSorSELECT_FROM_QUERY) to query the data.