Setting up the Snowflake integration

​

Prerequisites

​

Snowflake data requirements

​

Role permissions

• You must have the ACCOUNTADMIN role in Snowflake
• You must have a LaunchDarkly role of Owner or Admin, or a custom role that allows the following actions:
  • add and edit integrations
  • add destinations
  • add metric data sources

​

IP addresses

​

Network policy

• If you use network policies within your Snowflake account, you will need to create or update your policy to allow traffic from LaunchDarkly. To do this, you need your LaunchDarkly project key and environment key:
  1. Find, copy, and save your project key following these instructions.
  2. Find, copy, and save your environment key following these instructions.
  3. Combine the keys together, separated by two underscores. For example, if your project key is MobileApp and your environment key is production, your combined key is MobileApp__production.
  4. Replace <ProjKey__EnvKey> with your combined key in the code sample below, and add it to your Snowflake network policy:

CREATE NETWORK RULE LD_EXPERIMENTATION.RESULT_<ProjKey__EnvKey>.LD_EXPERIMENTATION_NETWORK_RULE TYPE = IPV4 MODE = INGRESS VALUE_LIST = ('52.21.152.96/32','52.200.35.24/32','52.200.50.23/32','54.144.218.89/32','54.221.221.197/32','34.236.6.43/32');

CREATE NETWORK POLICY LD_EXPERIMENTATION_NETWORK_POLICY ALLOWED_NETWORK_RULE_LIST=(LD_EXPERIMENTATION_NETWORK_RULE);

ALTER USER LD_EXPERIMENTATION_USER_<ProjKey__EnvKey> SET NETWORK_POLICY = LD_EXPERIMENTATION_NETWORK_POLICY;

​

Step 1: Gather your Snowflake account information

• The name of the Snowflake database containing your metrics data. LaunchDarkly will be granted read access to this database.
• The name of the schema within your metrics database. You don’t need this if you want to grant access to all schemas within the database.

​

Step 2: Configure the Snowflake Data Export integration

​

Step 3: Configure the Snowflake native Experimentation integration

1. Navigate to the Integrations page.
2. Search for and select Snowflake Native Experimentation.
3. Click Add integration. The configuration panel appears.
4. Enter an integration Name.
5. Select the LaunchDarkly Project and environment for this integration. You cannot change this after you save the integration.

6. Enter your Snowflake Metrics database name.
7. (Optional) Enter your Snowflake Metrics schema name.
8. LaunchDarkly generates a SQL script. Copy and save this script for use in the next step.

​

Run the SQL script in Snowflake

1. In Snowflake, navigate to Projects / Worksheets.
2. Click the + “Create SQL worksheet” button to create a new worksheet.
3. Paste the generated script to the worksheet.
4. Click the arrow to run the worksheet.

​

Save the configuration in LaunchDarkly

1. Return to the LaunchDarkly configuration screen.
2. Click Test connection and save.

​

Step 4: Create a metric data source

​

Step 5: Verify the connection

​

Next steps

• Creating experiments using warehouse native metrics
• Analyzing experiments