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.
Updates to existing integrations
After your integration is set up, you cannot make further edits to it, and you cannot create a second integration using the same project/environment key. If you need to update any fields as part of the integration, you must delete the existing integration and start a new one.
Delete existing integrations
Before you delete an existing integration, stop any running warehouse native experiments that are using data from the integration.
When you delete an existing integration the service disconnects from your Snowflake account. However, LaunchDarkly does not delete any stored event data. The LaunchDarkly user interface (UI) will still display related event data in places like the event explorer, the event selection dropdown when creating a metric, and other areas where metric events are visible.
Add new integrations
If you want to set up additional integrations for additional LaunchDarkly projects and environments, follow the same setup instructions for the additional integrations, including:
- Creating a metric events source corresponding to the new LaunchDarkly project and environment
- Setting up Snowflake Data Export for the new LaunchDarkly project and environment
- Configuring Snowflake native Experimentation for the new LaunchDarkly project and environment