Google Data Studio on BigQuery

Google Data Studio on BigQuery

Panoply documentation is moving! Click here to view the new site!  __________________________________________________________________________________________________________________

To determine whether your data warehouse is built on BigQuery or Redshift, see the BI Connect Page on the Panoply platform.

Panoply on BigQuery

To connect Google Data 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.
  2. Sign In to your Data Studio account using these credentials. 
  3. Once in Data Studio, click on Create > Data Source to add a new Data Source.
  4. On the next screen, under Google Connectors, select BigQuery.
  5. Click on Authorize to connect.

  6. You will be re-directed to the Sign in with Google page. Select the Google account to continue.
  7. You have successfully added Google BigQuery as your Data Source in Google Data Studio.
  8. Next, click on MY PROJECTS.
    1. Select Project > Dataset > Table, then click Connect.
    2. The Project name can be located under the BI Connection tab on your Panoply account.
    3. To connect with all Panoply’s native Data sources, please select “panoply” under Dataset.
    4. Click Connect.
  9. Your Data source will be re-named with your table name. Click on Create Report to get started.

  10. You have successfully connected Data Studio to your BigQuery data warehouse.
Getting started is easy! Get all your data in one place in minutes.
Try Panoply Free