Looker Studio

Looker Studio, previously known as Google Data Studio, is a free data visualization tool provided by Google. It enables users to create customizable, interactive dashboards and reports that can help in understanding data better.

Using Weld to build a data warehouse ensures that all your company's systems data is centralized, transformed, and ready for analysis within Looker Studio.

How to connect to Weld

Connect your data in Weld to Looker through a direct connection between your data warehouse and Looker Studio.

Connect Looker Studio to BigQuery

Connecting Looker Studio to Google BigQuery is a straightforward process. Here's how to set it up:

Access Looker Studio: Open Looker Studio and sign in using your Google account to begin.
Start a New Report: Select “Create” and then “Report” from the menu. You will be prompted to add a data source.
Select BigQuery as Data Source: Search for and select the BigQuery connector from the list of data sources.
Choose the BigQuery Project: You have three options for selecting the data:
- My Projects: Choose from the BigQuery projects that you have access to under your account.
- Shared Projects: Access any projects shared with you.
- Public Datasets: Use datasets made available publicly.
Select a Dataset: Within your chosen project, pick the dataset and then the specific table you wish to analyze. You can also write a custom SQL query to select data.
Authorize and Connect: Follow the prompts to authorize Looker Studio to access your BigQuery data. Then, hit the “Connect” button on the top right.
Add Data to Your Report: After connection, your data schema will appear. Add desired dimensions and metrics to your report.
Design the Report: Utilize Looker Studios tools to create visualizations such as charts and tables, then arrange them on your report.

You've now successfully connected Looker studio to Google BigQuery!

Connect Looker Studio to Snowflake

Connecting Snowflake to Looker Studio involves several key steps that allow you to visualize your Snowflake data using Looker Studio's tools. Here's a step-by-step guide on how to establish this connection:

Sign In to Google Looker Studio: Open Looker Studio and log in with your Google account credentials.
Add a Data Source: Click the + sign, and then select Data Source from the options.
Select the Snowflake Connector: In the Partner Connectors section, find and select the Snowflake connector, which is identifiable by the Snowflake logo.
Authorize the Connector: If prompted, authorize Google Looker Studio to use this community connector to ensure it can access your Snowflake data.
Enter Snowflake Credentials: You will need to provide your Snowflake user credentials to establish a connection. Enter your:
- Username
- Password
- Click Submit to proceed.
Configure Connection Settings: Next, you need to input the necessary details about your Snowflake environment. Provide the following information:
- Account URL: Your Snowflake account's URL.
- Role: The Snowflake role that has access to the desired data.
- Warehouse: The Snowflake warehouse that will be used for queries.
- Database: The specific database you want to connect to.
- Schema: The schema within the database.
- SQL Query: Optionally, you can enter an SQL query to retrieve specific data. Note that the SQL query should not end with a semicolon.
Establish the Connection: Click Connect once all the necessary information has been entered. Looker Studio will then attempt to connect to your Snowflake account.
Review Data Source Fields: After a successful connection, a page will display the data source fields derived from your Snowflake data or SQL query.
Create a Report or Explore Data: Finally, you can choose to either Create Report to start designing your data visualization dashboard or click Explore to examine the data further in Looker Studio.

By following these steps, you will be able to seamlessly integrate Snowflake with Looker Studio, enabling you to leverage advanced data visualization and reporting capabilities with your Snowflake data.