Snowflake Data Export

Overview

This topic explains how to create a Snowflake destination for Data Export.

Prerequisites

To configure the Snowflake integration, you must have the following prerequisites:

• You must have the SECURITYADMIN and SYSADMIN roles in Snowflake
• You need to allow LaunchDarkly's data transfer service’s static IP address: 35.192.85.117
• You must know your Snowflake account URL. You can retrieve your Snowflake account URL by navigating to the user menu in Snowflake, hovering on Account, hovering on the LaunchDarkly account name, then clicking the "Copy account URL" icon:

Prepare your Snowflake instance

You must prepare a separate Snowflake user and schema for each Launchdarkly project/environment you want to set up for export. The database, warehouse, and role are shared among environments.

First, in Snowflake create a warehouse and database. You can skip this step if you have already created the warehouse and database below, and are only setting up an additional project/environment.

Next, create a role with the required privileges on the database and warehouse. You will create a single role for all environments:

Connect your LaunchDarkly environment to Snowflake

In this section, you are working in LaunchDarkly and Snowflake simultaneously. We recommend having two browser windows or tabs open to easily switch back and forth between the two applications.

Begin by configuring the Snowflake Data Export integration in LaunchDarkly:

1. In LaunchDarkly, navigate to the Integrations page and find "Snowflake Data Export."
2. Click Add integration. The "Create a destination" panel appears.
3. (Optional) Give your integration a human-readable Name.
4. Choose a Project and environment to export data from.
5. Copy the Project/environment key to enter into the Snowflake script, below.
6. Copy the below script and, in Snowflake, paste it into a worksheet to create a Snowflake schema and user. Replace YOUR_LD_PROJ_ENV_KEY with the project/environment key you copied from the previous step:

7. In Snowflake, run the worksheet. Snowflake creates a new schema and user in your database.
8. In Snowflake, copy your account URL to use in the next step.
9. In LaunchDarkly, enter your Snowflake account URL.
10. Copy the Public key that appears.

11. In Snowflake, return to the worksheet you created in step 6. At the end of the worksheet, paste the following, replacing INSERT PUBLIC KEY HERE with the key you copied in step 10:

12. Run the above lines in the worksheet.
13. In LaunchDarkly, test the integration by clicking Test connection.
14. After reading the Integration Terms and Conditions, check the I have read and agree to the Integration Terms and Conditions checkbox.
15. Click Save destination. The new Snowflake destination appears in the list of destinations.

Your Snowflake Data Export integration is now complete. To view the different event kinds for Snowflake Data Export destinations, read Snowflake Data Export schema reference.