To get started with Honeydew, you need to complete the following steps:

  1. Honeydew Application org and admin user provisioning
  2. Snowflake Native Application installation
  3. Snowflake access setup

Optional:

  1. Git Integration
  2. BI Integration

Honeydew Application

Org provisioning and admin user

Get your Honeydew org set up, and have an admin user provisioned. Contact Honeydew support to help with this step (support@honeydew.ai). Once provided, you will be able to access the Honeydew application. The admin user will be able to invite additional users to the org, and manage org settings.

Users Login

  1. Honeydew supports user login using username/password as well as using Google accounts. For other login methods as well as for SSO, please reach out to Honeydew support (support@honeydew.ai).
  2. 2FA is automatically enabled and enforced for all users by default.

Snowflake Native Application

Install the Honeydew Native Application for Snowflake. Follow the steps listed here.

Snowflake Access Setup

Honeydew is built on top of Snowflake and requires access to Snowflake in order to operate. You have two options to set up Snowflake access - either using a central org-level connection parameters or map your individual Snowflake user credentials to Honeydew.

If you would like to use a central org-level connection, it is advised to create a new dedicated Snowflake user for Honeydew integration. The following Snowflake connection parameters are required for Honeydew setup:

  1. Account name
  2. Username
  3. Password
  4. Role
  5. Warehouse

The following Snowflake connection parameters are required to be able to deploy dynamic datasets to Snowflake:

  1. Database - the database where Honeydew will deploy any dynamic datasets as views or tables
  2. Schema - the schema where Honeydew will deploy any dynamic datasets as views or tables
  3. Dev Schema - the schema where Honeydew will deploy any dynamic datasets as views or tables when working on a dev branch

Allowing Honeydew IPs

If you have IP-based access restrictions in Snowflake, add the following IP addresses the “Allowed IP Addresses” list:

  • 34.86.209.90
  • 34.145.147.92

Permissions

Honeydew does not process any Snowflake data, but only reads metadata and deploys views/tables. You can find more security-related information here.

If using an integration user deployment, the Honeydew integration user/role require the following permissions to operate:

  1. USAGE on any databases and schemas which will be used as part of the semantic layer
  2. SELECT on any tables/views which will be used as part of the semantic layer
  3. CREATE TABLE and CREATE VIEW on the database/schema where dynamic datasets will be deployed

Honeydew has a growing number of AI-powered features, built on top of Snowflake Cortex. To be able to use these features in Honeydew, the SNOWFLAKE.CORTEX_USER database role is required to be granted:

-- Grant the SNOWFLAKE.CORTEX_USER role to the user role created for Honeydew integration
GRANT DATABASE ROLE SNOWFLAKE.CORTEX_USER TO ROLE HONEYDEW_USER_ROLE;

For more details, see the Snowflake Cortex documentation.

Git Integration

Honeydew uses Git as the underlying storage for any created semantics as well as for version control.

GitHub

You can either onboard using a Honeydew-managed GitHub private repository, or use your own GitHub repository. If you would like to use your own repository, please complete the following steps:

  1. Create a new GitHub private repository using one of these options:
  2. The full repository name - org-name/repository-name (e.g. honeydew-ai/tpch-quickstart) will be required for Honeydew setup.
  3. Install the Honeydew GitHub application, and provide it with access to the newly created repository.
  4. The app installation id (the number at the end of the URL, like 11122333 for https://github.com/apps/honeydew-ai/installations/11122333) would be required for Honeydew setup.

GitLab

Coming soon.

If you do not have a GitHub account, you can use a Honeydew-managed repository for Honeydew setup.

Azure DevOps

Coming soon.

If you do not have a GitHub account, you can use a Honeydew-managed repository for Honeydew setup.

BI Integration

You can find more details on how to integrate Honeydew with your BI tool here.