|
In this article, you’ll learn the following: |
Available in Enterprise for Testing, FullStack, and Personalize.
Overview
Integrating your VWO account with Snowflake will enable you to stream your VWO experiment data directly to Snowflake. This allows you to consolidate your experiment data in a powerful, scalable data warehouse, providing the ability to run complex SQL queries and perform advanced data analysis.
For example, if you’re exporting both Salesforce and VWO data to Snowflake, you can combine CRM data from Salesforce with A/B test results from VWO. This enables you to analyze customer behaviour patterns, understand how different segments respond to various tests, and develop more effective marketing strategies based on comprehensive customer insights.
Enabling the Integration
To enable this integration, you first need to create the essentials in Snowflake so that VWO can process the integration. Once that is in hand, you can enable the integration in VWO.
Step 1: Set Up Roles, Warehouse, Database, and Schema in Snowflake
- Log in to your Snowflake account.
- Create a role, warehouse, database, and schema for this integration.
- Provide appropriate access permissions to the role, with at least SYSADMIN-level privileges for the warehouse, database, and schema.
- Create a user and assign them a role with at least SYSADMIN-level privileges.
You can use the following script to accomplish all the aforementioned steps:
NOTE: Ensure you follow the Snowflake identifier requirements while renaming the resources.
Step 2: Turn On the Integration at VWO
- Log in to your VWO account.
- From the left panel of your VWO dashboard, go to Configurations > Integrations. This menu provides integrations that can be enabled at the account level.
- Browse for the Snowflake integration, click on it, and turn on the toggle switch to enable it.
- Now, you’ll be taken to the Config tab to connect your Snowflake account with VWO.
Enter the details in the following fields and click Create Connection:
| Which Field? | What is it for? |
| Host | The domain of the Snowflake instance, including account, region, cloud environment, and ending with snowflakecomputing.com. E.g., accountname.us-east-2.aws.snowflakecomputing.com |
| Role | The role created for VWO to access Snowflake. E.g., VWO_ROLE |
| Warehouse | The warehouse was created for VWO to sync data into. E.g., VWO_WAREHOUSE |
| Database | The database created for VWO to sync data into. E.g., VWO_DATABASE |
| Schema | The default schema used for all statements issued from the connection that do not explicitly specify a schema name |
| Username | The username created to allow VWO to access the database. E.g., VWO_USER |
| Password | The password associated with the username |
Once the connection is established, your VWO experiment data will start streaming to your Snowflake account.
If you wish to enable the Snowflake integration for your campaigns, select the campaign, go to Configuration > Integrations, and select Snowflake.