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

Setting up a new Database

Metabase databases 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, click Add Data and then in the popup menu click Add a database
  2. Choose Presto as the Database type
  3. Set a unique Display Name for the database (e.g. “Honeydew”)
  4. Set Host to jdbc.honeydew.cloud and Port to 443
  5. 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.
  6. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  7. Switch the Use a secure connection (SSL) toggle to On
  8. 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 run queries or create reports on top of the Honeydew database connection, using the Metabase user interface.