How to integrate data into Snowflake with Windsor.ai

Snowflake is a cloud-based data platform designed for data warehousing, data lakes, and analytics. It enables organizations to store, manage, and analyze large volumes of data efficiently.

With a scalable architecture that separates storage and computing functions, Snowflake allows users to scale resources independently, optimizing both performance and cost-efficiency. Unlike traditional on-premise solutions, Snowflake operates entirely in the cloud on AWS, Azure, and Google Cloud, supporting both structured and semi-structured data formats, such as JSON and Parquet.

By integrating Snowflake with Windsor.ai data connectors, you can:

• Unify marketing, sales, and CRM data (e.g., Facebook Ads, Google Ads, Google Analytics, Salesforce) in one centralized location.
• Apply data-driven attribution to evaluate the impact of each touchpoint on the conversion, campaign, or ad level.
• Combine costs from all connected channels to calculate metrics like cost per acquisition (CPA) or return on ad spend (ROAS).
• Leverage cross-channel analytics for informed, data-driven decision-making.

Explore our video tutorial and a step-by-step guide to seamlessly integrate your data into Snowflake with the Windsor.ai ELT connector.

1. Log in to your Windsor.ai account or register if you don’t have one.

2. Select the data source which you want to stream data from, e.g., Google Analytics 4. Sign in with your associated Google account and select the next step, “Data preview.”

You’ll see your GA4 data in your Windsor.ai account. Now, let’s proceed with setting up a Snowflake database for data integration.

1. Go to your Snowflake account and create a new user role, e.g. Windsor_Upload (you can type any name).

Admin-> User & Roles-> + Role

2. Then, create a new user and assign the previously created role to it.

Admin-> User & Roles-> + User

3. Grant necessary database privileges to the created role. Create a database if there is none present for Google Analytics 4 data.

Data-> Databases-> Select Database-> + Privilege-> Select Role and Privileges

4. Grant necessary privileges of the schema and database table to the created role. Create schema and table if there are none present for Google Analytics 4 data.

Data-> Databases-> Select Database-> Select Schema-> + Privilege-> Select Role and Privileges

Data-> Databases-> Select Database-> Select Schema-> Select Table-> + Privilege-> Select Role and Privileges

5. Get the required fields from Snowflake to create the connection between Snowflake and the Windsor.ai platform.

• Get the username of the newly created user. 

Admin-> User & Roles-> Select User

• Get the password of the newly created user. If you don’t remember the password you set while creating the user, you can reset it.
• Get the account.

Admin-> Accounts

• Get the warehouse. 

Admin-> Warehouses

• Get the database, schema, and table names. 

Data-> Databases-> Select Database-> Select Schema-> Tables-> Select Table

Here it is; you have set up the database on the Snowflake side. Now, let’s import your data from Windsor.ai to this database.

1. Go to your Windsor.ai account and move to the data preview page. Select Snowflake as your data destination and add a destination task.

2. Enter all the credentials required and click on “Test connection.” 

You’ll see a success message at the bottom if the connection is set properly; otherwise, the error message will be displayed. When successful, click on “Save” in the lower right corner of the form. The data stream to Snowflake has started.

3. You can now see the task running in the selected data destination section. The green “upload” button with the status “ok” indicates that the task is active and running successfully.

4. You can also verify that your data is being added to the database by previewing the data table in your Snowflake account.

Cheers! Your Google Analytics 4 data is now integrated into the Snowflake database and ready for analysis.