Skip to main content
Amazon QuickSight connects to Honeydew via JDBC connection, using the Trino protocol.

​
Creating a new dataset

Amazon QuickSight database connections are mapped to a Honeydew workspace and branch
It is recommended to use an API Key for setting up the connection.
  1. Create a new dataset
  2. Choose Trino from the list of supported connections
  3. Set a unique Name for the connection (e.g. “Honeydew”)
  4. Set the Database Server to jdbc.honeydew.cloud
    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.
  5. Set Port to 443
  6. 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.
  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. Click Validate to verify the connection
  9. Create the database connection
  10. Choose schema (domains to choose a domain) and table (the domain)
  11. Choose to use a direct connection (recommended) or import
When using import mode, metrics defined in Honeydew can’t be computed after loading.Use a domain with attributes only.