Snowflake
      Back to home
      1. Knowledge base
      2. Snowflake

      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

      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:

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

        Dataslayer destinations panel showing active connectors like Google Sheets and Snowflake.

      2. Click the New transfer button.

        Snowflake view in Dataslayer with a button to create a new transfer.

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

        Left panel showing source settings: selected Google Ads source, dates, filters, options, dimensions, and metrics.

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

        Destination setup section with transfer name, table, timezone, and write mode

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

        Bottom buttons for saving and previewing data, limited to 200 rows

      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.

      For guidance on locating the necessary credentials for the following steps, please refer to this article.

      To connect:

      1. Go to Looker Studio.

      2. Click Create > Report.
        Main Looker Studio screen displaying report templates, with the "Blank Report" option highlighted to start a report from scratch.

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

        Looker Studio interface for adding data sources, highlighting the Snowflake connector among available options.

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

        • User Name

        • Password


        uthentication form in Looker Studio for accessing Snowflake, prompting for username and password.
      5. Enter your Snowflake account URL and click Next.

        Input field in Looker Studio to enter the Snowflake account URL before proceeding with the connection.

      6. Choose the role, warehouse, database, and schema between the options displayed and click Next.

        Dropdown menu in Looker Studio to select role, warehouse, database, and schema for Snowflake connection.
      7. 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.

      Required field in Looker Studio to enter the SQL query that will fetch data from Snowflake into the report.

      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.

      Looker Studio report editor showing a blank canvas with layout, filter, and chart type option

      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!