How to integrate my Google Bigquery Warehouse with Looker Studio?

Introduction

Looker studio is an intuitive and easy to use, self-serve business intelligence (BI) tool, that allows you to visualize your data in vibrant reports and dashboards, helping you draw actionable insights to guide your business decisions.

In order to link your Data Warehouse to Looker Studio, you will need to use Connectors. Click here to view a list of connectors.

Steps to Connect BigQuery to Looker Studio

  1. Sign in to Looker Studio. You will reach the Home Page of Looker Studio.

    looker studio home page

  2. In the top left, click + Create then select Data Source.

    looker studio create data source

  3. A page will open up listing connectors supported by Looker Studio. Click on the required connector to connect to data. Typing in the required connector’s name in the search box will make it easy to find it. You can change the name of the Data Source by editing the name on the top left corner of the screen.

    looker studio connectors list

  4. Select the BigQuery connector to access this data source.

  5. If prompted, click Authorize to allow Looker Studio to access your data on your behalf.

    looker studio authorise

  6. Provide your account details and proceed to add the data source.

    looker studio oauth

  7. You will be able to view your projects from the BigQuery data warehouse to which you have access. Click on the required project to view the details of its datasets. Click on the required datasets to view details of all Tables contained in it. Click on the required Table.

    looker studio projects

  8. Once you have selected the required Table, click on Connect on the top right corner.

    looker studio connect table

  9. This will open up a list of all the fields in the selected table.

  10. You are now ready to create a Report/ Visualisation using Looker Studio.

    looker studio table fields

  11. You can read more about connecting Looker Studio to Google BigQuery here.

Finding your DataChannel managed BigQuery Warehouse details

  1. Login to the DataChannel Console.

  2. Access the Data Warehouse page by clicking on the Data Warehouse Tab on the sidebar.

    dc managed bigquery 1

  3. Click on the card of the data warehouse that you want to connect to Looker Studio .

  4. The following screen would show up. All the required details will be available in the form that opens up.

dc managed bigquery 2

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.