Holistics connects to Honeydew via JDBC connection, using the Presto protocol.

​
Setting up a new Data Source

Holistics data sources are mapped to a Honeydew workspace and branch

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

  1. In the main menu, go to Data Sources and then click New Data Source
  2. Choose PrestoDB as the Database type
  3. Set a unique Display Name for the database (e.g. “Honeydew”)
  4. Set the Connection mode to Direct Connection
  5. Set Host to jdbc.honeydew.cloud and Port to 443
  6. Set Database Name 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.
  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. Switch the Require SSL toggle to On
  9. Click Test Connection
  10. Once the connection is successful, click Save

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 a run queries or create reports on top of the Honeydew database connection, using the Metabase user interface.

​
Metadata Sync

Honeydew support for Holistics semantic model metadata sync is in preview. For more information, please contact support@honeydew.ai.

Was this page helpful?

LightdashRedash