IntegrationsData ExportWarehouse Data Export

Snowflake Data Export

This integration is not available in federal environments
To learn more, read LaunchDarkly in federal environments.
Data Export is an add-on feature

Data Export is available as an add-on feature to select plans. To learn more, read about our pricing. To add Data Export to your plan, contact Sales.

Overview

This topic explains how to create and test a Snowflake destination for Data Export. By exporting your LaunchDarkly experiment data to the same Snowflake warehouse as your other data, you can build custom reports in Snowflake to answer product behavior questions.

You can also run experiments using warehouse native metrics. To learn more, read Creating experiments using warehouse native metrics.

You can use the Snowflake Data Export integration with cloud providers in any region.

Prerequisites

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

  • 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/server URL by navigating to the user menu in Snowflake, hovering on Account, then clicking View account details:

The "Copy account URL" option in Snowflake.

The "Copy account URL" option in Snowflake.
  • If you use network policies within your Snowflake account, you must allow traffic from LaunchDarkly. The setup script you generate in the next section creates the required network rule and policy for you when you turn on the Allowlist LaunchDarkly’s IP option.

Connect your LaunchDarkly environment to Snowflake

The Snowflake Data Export setup uses a two-step flow. First, you generate a setup script in LaunchDarkly. Then, you run the script in Snowflake and return to LaunchDarkly to test the connection and save your destination.

We recommend having two browser windows or tabs open to switch between LaunchDarkly and Snowflake.

When you set up the integration, LaunchDarkly generates a SQL script that creates these Snowflake objects in your account. You can use the default names or customize them in step 6 of the following procedure.

To connect your LaunchDarkly environment to Snowflake:

  1. In LaunchDarkly, click the gear icon in the left sidenav to view Organization settings.

  2. Click Integrations and find “Snowflake Data Export.”

  3. Click Add integration. The Snowflake Data Export configuration page appears.

  4. Choose a Project and environment to export data from. Environments that already have a Snowflake Data Export destination are unavailable.

  5. Enter your Snowflake account URL.

  6. (Optional) Customize any of the Snowflake object names listed below. If you leave a field blank, LaunchDarkly uses the default value.

    • Warehouse name: defaults to LD_EXPORT_WH. Shared across all environments.
    • Database name: defaults to LD_EXPORT. Shared across all environments.
    • Role name: defaults to LD_EXPORT_ROLE. Shared across all environments.
    • Schema name: defaults to EXPORT_<projKey>__<envKey>, where <projKey> is your project key and <envKey> is your environment key. Unique to a project and environment.
    • User name: defaults to LD_EXPORT_USER_<projKey>__<envKey>. Unique to a project and environment.

    Each name can contain letters, digits, underscores, and $. Names must start with a letter or underscore and can be up to 255 characters.

  7. (Optional) If your Snowflake account uses network policies, turn on Allowlist LaunchDarkly’s IP (35.192.85.117). The generated script then creates the required Snowflake network rule and policy.

  8. Click Generate SQL. LaunchDarkly returns a setup script that creates the warehouse, database, role, schema, and user with the names you chose.

  9. Copy the generated script and, in Snowflake, paste it into a worksheet.

  10. In Snowflake, run the worksheet. This creates the necessary Snowflake resources.

  11. After reading the Integration Terms and Conditions, select the I have read and agree to the Integration Terms and Conditions checkbox.

  12. In LaunchDarkly, click Test connection and save. LaunchDarkly tests the Snowflake connection and, if it succeeds, creates and activates the destination.

Your Snowflake Data Export integration is now complete. If you plan to use Snowflake native Experimentation, the next step is to set up the Snowflake native Experimentation integration.

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.

To view the different event kinds for Snowflake Data Export destinations, read Warehouse Data Export schema reference.

Editing an existing destination

To edit a Snowflake Data Export destination after it is set up:

  1. In LaunchDarkly, click the gear icon in the left sidenav to view Organization settings.
  2. Click Integrations and find “Snowflake Data Export.”
  3. Find the destination you want to edit and click Edit. The Snowflake Data Export configuration page appears with the destination’s current settings.
  4. Update the fields you want to change.
  5. Click Save configuration.

The project and environment you chose in the initial configuration are permanent and cannot be changed.

Health checks

If your warehouse Data Export integration develops connection problems or other errors, the integration will display a health check warning. To learn more, read Warehouse health checks.