Looker on BigQuery
  • 27 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

Looker on BigQuery

  • Dark
    Light
  • PDF

Article Summary

Panoply on BigQuery

To connect Looker to BigQuery:

  1. In Panoply, click on BI Connection. **Click on Send your service account JSON file to your email. When you receive the file, save it in an easy to find location. You will need it in step 5.

looker-connect-tools.png

  1. Log In to your Looker account.
    looker-1.png
  2. On the top menu, click Admin. Toward the bottom of the drop down menu, under Database, select Connections.

looker-2-1

  1. On the Connections screen, click Add Connection.

looker.png

  1. On the next screen, fill the connection details:
    1. Enter a Name to identify this connection. This name can be anything.
    2. In the Dialect box, select “Google BigQuery Standard SQL” from the drop-down.
    3. Enter your Project ID under Project Name. The Project ID can be found under the BI Connection details on your Panoply account, as seen in Step 1.
    4. In the Service Account Email field, enter the "client_email" on your Service Account JSON file, as downloaded in Step 1.
    5. Upload the Service account JSON file you downloaded in Step 1.
    6. Click Add Connection.

looker-4-1.png
looker-5-1.png

  1. Your BigQuery data warehouse has been added. Click on Test.

looker-6.png

You have successfully connected Looker to your BigQuery data warehouse.


Was this article helpful?