Set up Honeycomb Maps in Snowflake ​

This guide provides step-by-step instructions to install Honeycomb Maps into your Snowflake account. Watch the video or follow along with the detailed steps below.

Prerequisites ​

• A Snowflake account
• Necessary permissions to install applications (typically an ACCOUNTADMIN role)
• If the Honeycomb Maps app has been shared with you privately, ensure you have access to it.

Step-by-Step Installation ​

1. Access the Snowflake Marketplace

   • Log in to your Snowflake account.
   • Navigate to the Data menu and select Marketplace.

2. Locate the Honeycomb Maps app

   • Search for "Honeycomb Maps" in the marketplace.
   • If the app has been shared privately, go to Apps and find it under Recently Shared with You.

3. Install the Application

   • Click on the Get button for Honeycomb Maps.
   • In the modal window, select the warehouse for installation (use the default warehouse if unsure).

4. Leave the application name as is and click Get.

5. Wait a few seconds for the installation to complete.

6. Grant Application Privileges

   • After installation, click on the "Honeycomb Maps" app.
   • Follow the activation flow by granting the necessary account privileges:
     • Create Compute Pool
     • Bind Service Endpoint
     • Create Warehouse
   • Click Grant to grant these privileges.
   • Click Activate to complete the activation process (this may take 10-20 minutes).

7. Grant Honeycomb Access to Data Tables

   By default, Honeycomb does not have access to any tables within your Snowflake account. You must grant it access, similarly to how you can grant access to a user. Below are some sample queries that show how to add SELECT permissions to a table called FACT_ORDERS within the DELIVERY_DATA database.

GRANT USAGE ON DATABASE delivery_data TO APPLICATION honeycomb_maps;
GRANT SELECT ON TABLE delivery_data.public.fact_orders TO APPLICATION honeycomb_maps;

GRANT USAGE ON DATABASE delivery_data TO APPLICATION honeycomb_maps;
GRANT SELECT ON TABLE delivery_data.public.fact_orders TO APPLICATION honeycomb_maps;

8. Enable Connections for Map Tiles

   • Go to the Connections tab.
   • Enable the connection to allow Honeycomb to load map tiles from the Mapbox service.
   • Click Connect to grant this permission.

9. Launch Honeycomb Maps

   • Click Launch App to open Honeycomb Maps in a new tab.
   • Sign in using Single Sign-On (SSO) through Snowflake.
   • After logging in, you will see the Honeycomb welcome page where you can select a Snowflake table or load a demo map.

You have now successfully installed and configured Honeycomb Maps in your Snowflake account. In the next guide, we will explore viewing a demo map within Honeycomb.