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

​
Creating a new dataset

Amazon Quick database connections are mapped to a Honeydew workspace and branch
It is recommended to use an API Key for setting up the connection.
  1. On the Data page, click Create dataset
  2. Click Create data source and choose Trino from the list of data sources
  3. Click Next
  4. Set a unique Data source name for the connection (e.g. “Honeydew”)
  5. Keep Connection type as Public network
  6. 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.
  7. Set Port to 443
  8. 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.
  9. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  10. Click Validate connection to verify the connection
  11. Click Create data source
  12. Choose schema (domains to choose a domain) and table (the domain)
  13. 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.

​
API Integration

To sync datasets from Honeydew to Amazon Quick, Honeydew connects to the Amazon Quick API. The API uses AWS credentials (an access key ID and secret access key) for authentication. This builds on the JDBC connection described above: the JDBC connection lets Amazon Quick read data from Honeydew, while the API connection lets Honeydew publish domains to Amazon Quick as datasets.

​
API Access Setup

1

Create AWS credentials

Create an IAM identity with programmatic access whose credentials Honeydew will use.
  1. In the AWS console, create (or select) an IAM user for Honeydew.
  2. Grant it permission to manage Amazon Quick resources — validation lists data sources, and publishing creates and updates datasets, so the identity needs Amazon Quick access such as listing data sources and folders and creating, updating, and deleting datasets.
  3. Create an access key for the user and copy the access key ID and secret access key. The secret is shown only once.
  4. Note your AWS account ID and the region where your Amazon Quick account is provisioned (for example us-east-1).
2

Configure Honeydew with the credentials

  1. Sign in to Honeydew with a user that has administrator privileges.
  2. Open the user settings menu.
  3. Navigate to Amazon Quick → Settings.
  4. Enter the following information:
    • AWS account ID — the 12-digit ID of the account hosting Amazon Quick
    • Region — the AWS region where your Amazon Quick account is provisioned
    • AWS access key ID — the access key ID generated in the previous step
    • AWS secret access key — the secret access key generated in the previous step
  5. Save the connection. Honeydew validates the credentials against the Amazon Quick API before storing them.