There are two ways to connect Retool to Honeydew:
  1. Via a JDBC connection, using the Presto protocol
  2. Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application

​
Setting up a new Presto Data Source

Retool data sources are mapped to a Honeydew workspace and branch
It is recommended to use an API Key for setting up the connection.
  1. Go to Resources and click on Create New > Resource
  2. Search Presto from the full list of resource types, in the Database section
  3. Click on Presto
  4. Set a Name for the resource
  5. Optionally, set a Description for the resource
  6. Enter the following Connection String as the input: 
    jdbc:presto://jdbc.honeydew.cloud:443/<workspace>__<branch>?user=<api key>&password=<api secret>
    Where <api key> is the generated API key, and <api secret> is the corresponding API secret. Or alternatively: 
    jdbc:presto://jdbc.honeydew.cloud:443/<workspace>__<branch>?user=<user>&password=<password>
    Where <user> is a Honeydew username, and <password> is that user’s password.
    API key and API secret (or alternatively, user and password) must be url-encoded., i.e. user@domain.com is user%40domain.com. Encoding can be done using python (from urllib.parse import quote_plus), or via any urlencode website.
    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.
    For example, for user user@domain.com, password 123456 and workspace tpch (prod branch) the URI would be: 
    jdbc:presto://jdbc.honeydew.cloud:443/tpch?user=user%40domain.com&password=123456
    And for dev branch: 
    jdbc:presto://jdbc.honeydew.cloud:443/tpch__dev?user=user%40domain.com&password=123456
  7. Click Test Connection to verify the connection settings
  8. Click Create resource
You can now create queries and applications on top of the Honeydew database resource, just like with any other data resource. For more information on how to use the Honeydew SQL interface, refer to this section.

​
Connecting via Snowflake Connection using the Snowflake Native Application

  1. Create a Snowflake data source connection in the account where you have the Honeydew Snowflake Native Application installed
  2. In query editor for a new query, use the Honeydew Snowflake Native Application query interfaces (SELECT_FROM_FIELDS or SELECT_FROM_QUERY) to query the data.