Integrating your marketing data into Looker Studio can enhance your data analysis and visualization capabilities. Here’s a step-by-step guide on how to import your data using the Looker connector for Snowflake by Google
This Snowflake connector is provided by Snowflake. If you have any issues with the connection or the data, please refer to Snowflake Documentation.
If you store your marketing or business data in Snowflake using Dataslayer, you can create powerful dashboards in Looker Studio by connecting directly to Snowflake through its native connector. Dataslayer allows you to move data from platforms like Google Ads, Facebook Ads, and others into Snowflake. Once the data is there, you can visualize it in Looker Studio using Snowflake’s native integration.
This article shows you how to:
-
Load marketing data into Snowflake using Dataslayer.
-
Connect Snowflake to Looker Studio.
-
Build interactive dashboards based on your marketing data.
Step 1 - Load marketing data into Snowflake using Dataslayer
Dataslayer allows you to automate data transfers from multiple marketing platforms into your Snowflake environment. These transfers can be scheduled or run manually, depending on your needs.
To create a new transfer:
-
Log in Dataslayer and navigate to the Snowflake product.
-
Click the New transfer button.
-
Select your data source, accounts, date range, metrics, and dimensions.
-
Choose your Snowflake account, define the transfer settings (table name, timezone, write mode), and select a sync frequency.
-
Click Confirm changes to save and activate the transfer.
For a full step-by-step guide, please refer to this article.
Once the transfer is active, Dataslayer will begin sending your selected data into the Snowflake table you specified.
Step 2 - Connect Looker Studio to Snowflake
Looker Studio offers a native connector for Snowflake, allowing you to pull data directly from your Snowflake warehouse.
To connect:
-
Go to Looker Studio.
-
Click Create > Report.
-
In the data source list, search for and select Snowflake.
-
Enter the credential details mentioned below and click Submit.
-
User Name
-
Password
-
- Enter your Snowflake account URL and click Next.
-
Choose the Role between the options displayed and click Next.
-
AccountAdmin
-
OrgAdmin
- Public
- SecurityAdmin
- Snowflake_learning_role
- SYSAdmin
- UserAdmin
-
- Choose the Warehouse from the dropdown options and click Next.
- Choose the database from the dropdown options and click Next.
- Choose the Schema from the dropdown options and click Next.
- Enter your SQL query and click Add.
For this example, the format that was allowed is:
select * from "table_name" limit 100
Note: It is recommended to use double quotation marks as it may prevent the connection from being established as intended.
That's it! The connection has been established with the Snowflake connector.
Step 3 - Build your marketing dashboard
Now that your data is connected, you can start building your dashboard in Looker Studio:
-
Use charts, scorecards, and tables to display performance.
-
Add filters and date selectors to make reports interactive.
-
Combine Snowflake data with other sources in the same report if needed.
Tips for effective data import and visualization
-
Optimize queries: Use SQL views or filtered transfers to bring only the data you need into Snowflake. This improves query speed and dashboard performance.
-
Schedule updates: Keep your data fresh by setting up regular syncs in Dataslayer and scheduled refreshes in Looker Studio.
-
Validate your data: Periodically review your tables in Snowflake to ensure metrics are accurate and aligned with your marketing sources.
-
Use naming conventions: Maintain consistent table and field names to simplify Looker Studio setup and collaboration.
The Snowflake connector can only query a maximum of 1 million rows and 50 MB of data. If you exceed this limit, the data will be truncated. Learn more about this connector here.
As always, please contact us via our live chat or via email if you still have doubts or questions. We are happy to help!