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.