Amazon QuickSight

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

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