Snowflake common questions

Overview

This topic provides answers to common questions about working with Snowflake native Experimentation.

Before you begin setting up the Snowflake integration, read the Snowflake data requirements. Then, follow the setup instructions in Snowflake integration for warehouse native experiments.

If you have further questions about the integration, read the sections below.

Roles and permissions

To set up Snowflake Data Export, you must have the following permissions in Snowflake:

  • SYSADMIN
  • SECURITYADMIN

To set up the LaunchDarkly Warehouse Native Experimentation app in Snowflake, you must have the following permissions in Snowflake:

  • ACCOUNTADMIN

IP addresses

You must add to your allow list the following outbound IP addresses:

  • 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

For a full list of LaunchDarkly’s public IP addresses, read Public IP list.

Snowflake resources and warehouses

You must name your Snowflake resources, including databases, schemas, and roles, according to LaunchDarkly’s naming conventions. The integration does not support flexible naming conventions.

You can use any of your existing Snowflake warehouses to install, initialize, and run the LaunchDarkly Warehouse Native Experimentation app in Snowflake. We suggest that you choose a small warehouse that you use for general needs so that it consumes minimal resources.

Confirm your setup

If you have configured your setup correctly, you will observe your Snowflake dynamic tables being populated with data under the LD_EXPERIMENTATION database and RESULTS_<project_env_key> schema within the next few hours.

Data transfer frequency

Snowflake Data Export runs an hourly job, on the hour, that publishes raw LaunchDarkly data in your Snowflake account. You can expect the new data to be available in your Snowflake account within 10-15 minutes after the hour.

Add new or update existing integrations

After your integration is set up, you cannot make further edits to it. If you need to update any fields as part of the integration, you must delete your existing integration and start a new one.

Before you delete an existing integrations, stop any running warehouse native experiments that are using data from the integration. If you delete an existing integration, LaunchDarkly does not delete any stored event data.

If you want to set up additional integrations for additional LaunchDarkly projects and environments, follow the same setup instructions for the additional integrations, including:

Built with