Setting up a new Data Source
Holistics data sources are mapped to a Honeydew workspace and branch- 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.cloudand Port to443 - Set Database Name to
<workspace>__<branch>value, based on the Honeydewworkspaceandbranchyou 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.