Setting up a new Data Source
Holistics data sources are mapped to a Honeydew workspace and branchIt is recommended to use an API Key for setting up the connection.
- In the main menu, go to Data Sources and then click New Data Source
- Choose PrestoDB as the Database type
- Set a unique Display Name for the database (e.g. “Honeydew”)
- Set the Connection mode to Direct Connection
- Set Host to
jdbc.honeydew.cloud
and Port to443
- Set Database Name to
<workspace>__<branch>
value, based on the Honeydewworkspace
andbranch
you would like to connect to. Omit the branch value if connecting toprod
. For example, for workspacetpch
, branchprod
, the value would be:tpch
. And for workspacetpch
, branchdev
, it would betpch__dev
. - Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
- Switch the Require SSL toggle to On
- Click Test Connection
- Once the connection is successful, 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.