How to import Snowflake data into Looker Studio

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

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:

1. Log in Dataslayer and navigate to the Snowflake product.

2. Click the New transfer button.

3. Select your data source, accounts, date range, metrics, and dimensions.

4. Choose your Snowflake account, define the transfer settings (table name, timezone, write mode), and select a sync frequency.

5. Click Confirm changes to save and activate the transfer.

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:

1. Go to Looker Studio.

2. Click Create > Report.

3. In the data source list, search for and select Snowflake.

4. Enter the credential details mentioned below and click Submit.

   • User Name

   • Password

5. Enter your Snowflake account URL and click Next.

6. Choose the Role between the options displayed and click Next.

   • AccountAdmin

   • OrgAdmin

   • Public
   • SecurityAdmin
   • Snowflake_learning_role
   • SYSAdmin
   • UserAdmin
7. Choose the Warehouse from the dropdown options and click Next.
8. Choose the database from the dropdown options and click Next.
9. Choose the Schema from the dropdown options and click Next.
10. Enter your SQL query and click Add.
    

select * from "table_name" limit 100

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.

As always, please contact us via our live chat or via email if you still have doubts or questions. We are happy to help!