- Via a JDBC connection, using the Presto protocol
- Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application
Setting up a new Data Connection
Qlik data connections 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 Create and then click Data connections
- Choose a Space from the list of spaces
- Choose Presto from the list of Data connectors
- Set Host name to
jdbc.honeydew.cloud
and Port to443
- Set Catalog 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
. - Choose LDAP Authentication as the Authentication Type
- Check the User defined credentials checkbox if you would like to use per-user credentials or keep unchecked if you would like to share the credentials with anyone who has access to this data connection.
- Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
- Make sure the Enable SSL toggle is On (it should be enabled by default)
- Provide a unique Name for the data connection (e.g. “Honeydew”)
- Click Test Connection
- Once the connection is successful, click Create
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.
Qlik does not support Direct Query for Presto data connection. Only data import is supported.
Connecting via Snowflake Connection using the Snowflake Native Application
- Create a Snowflake database connection in the account where you have the Honeydew Snowflake Native Application installed
- In query editor for a new query/report, use the Honeydew Snowflake Native Application
query interfaces (
SELECT_FROM_FIELDS
orSELECT_FROM_QUERY
) to query the data.