Looker on BigQuery

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.
   

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

4. On the Connections screen, click Add Connection.
   

5. 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.
      

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

You have successfully connected Looker to your BigQuery data warehouse.