Looker Studio on BigQuery
  • 03 Feb 2023
  • 1 Minute to read
  • Dark
    Light
  • PDF

Looker Studio on BigQuery

  • Dark
    Light
  • PDF

Article summary

Panoply on BigQuery

To connect Looker Studio to your Panoply data warehouse built on BigQuery:

  1. In Panoply, click on BI Connection in the top menu to view your connection details.

    bi-connection-details-data-studio-1.png
  2. Sign In to your Looker Studio account using these credentials. 

    data-studio-2.png
  3. Once in Looker Studio, click on Create > Data Source to add a new Data Source.

    data-studio-3.png
  4. On the next screen, under Google Connectors, select BigQuery.

data-studio-4.png

  1. Click on Authorize to connect.

data-studio-5-1.png

  1. You will be re-directed to the Sign in with Google page. Select the Google account to continue.

data-studio-6.png

  1. You have successfully added Google BigQuery as your Data Source in Looker Studio.
  2. Next, click on MY PROJECTS.
    1. Select Project > Dataset > Table, then click Connect.

data-studio-7-1.png

  1. The Project name can be located under the BI Connection tab on your Panoply account.
  2. To connect with all Panoply’s native Data sources, please select “panoply” under Dataset.
  3. Click Connect.
  4. Your Data source will be re-named with your table name. Click on Create Report to get started.

data-studio-8-1.png

  1. You have successfully connected Looker Studio to your BigQuery data warehouse.

Was this article helpful?