Using Google Looker Studio with BigQuery and Kondado

Most Data Analytics stacks comprise three stages: an ETL tool + a Data Warehouse to centralize data + a visualization or BI tool. Here, we will show you how to use Google Looker Studio as a BI tool, along with BigQuery as your Data Warehouse and Kondado as your ETL tool.

Click here to access the tutorial showing the ways to share reports in Looker Studio.

1. Registering your BigQuery as a Destination in Kondado: Now that you have your database, it's time to log in to Kondado and register it to receive data from your tools.

To register your BigQuery as a destination, follow the step-by-step instructions by clicking here.

2. Creating Your Data Sources: Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit our wiki and follow the respective step-by-step instructions.

3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps

4. Accessing Google Looker Studio: To connect your BigQuery (which has already received data from Kondado) to Looker Studio, go to https://lookerstudio.google.com/ using the same Google account you used to register your BigQuery in Kondado (step 2), or use an account that has access to this database:

Connecting BigQuery as a Data Source:

Click on "Create" in the upper left corner and choose the "Data Source" option:

Select BigQuery from the list:

Click "Authorize" to grant access to BigQuery:

Then, select the Project name, Dataset, and table (which you named when creating the integration in Kondado) that you want to connect to Looker Studio:

Give a name to your Data Source:

Click "Connect" in the upper right corner:

You're all set! Now your table is connected to Looker Studio, where you can create reports, visualizations, or SQL queries.

Integrate Google Looker Studio with BigQuery and Kondado

Set up a complete data analytics stack by connecting your sources through Kondado to BigQuery, then visualizing the data in Google Looker Studio.

Register BigQuery as your destination

Create your data sources

Identify and register the sources or tools you want to extract data from, following Kondado's step-by-step instructions for each connector.

Build your first integration

With your destination and sources registered, create your first integration using Kondado's platform onboarding steps to start moving data into BigQuery.

Connect BigQuery to Looker Studio

Go to Looker Studio, create a new Data Source, select BigQuery, authorize access, and choose the Project, Dataset, and table that Kondado populated.

Design reports and visualizations

Once connected, use Looker Studio to build reports, dashboards, and SQL queries from your centralized BigQuery data for powerful data visualization.

Frequently asked questions

What are the three stages of a typical Data Analytics stack?▼

A typical stack comprises three stages: an ETL tool (Kondado), a Data Warehouse (BigQuery) to centralize data, and a visualization or BI tool (Google Looker Studio).

Do I need to use the same Google account for BigQuery and Looker Studio?▼

Yes, you should use the same Google account you used to register BigQuery in Kondado, or an account that has access to that BigQuery database, to ensure seamless connectivity.

What data sources can I connect to BigQuery through Kondado?▼

Kondado supports numerous sources including CRMs, ad platforms, e-commerce systems, and databases. You can explore data integration options to see available connectors.

How do I select the correct table when connecting BigQuery to Looker Studio?▼

When creating the integration in Kondado, you named your table—use that same table name, along with the correct Project and Dataset, when configuring the BigQuery data source in Looker Studio.

Can I create SQL queries directly in Looker Studio after connecting BigQuery?▼

Yes, once your BigQuery table is connected to Looker Studio, you can create reports, visualizations, and SQL queries directly within the platform.

Written by

Thassyo Pereira·Published 2023-11-06·Updated 2026-04-25