ThoughtSpot connects to Honeydew via JDBC connection, using the Trino protocol.

​
Setting up a new data warehouse connection

ThoughtSpot data warehouse 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 data warehouse connection
  2. Enter a name for the connection (e.g. “Honeydew”)
  3. Choose Trino from the list of supported data warehouses
  4. Click Continue to move to the connection settings
  5. Set Host to jdbc.honeydew.cloud
  6. Set Port to 443
  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. Set Database 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. Click Continue
  10. Select the domain you would like to connect to, and check the columns you would like to include in the connection.
  11. Click Create Connection to create the connection

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 data warehouse connection, using the ThoughtSpot user interface.