Looker Setup Guide

Looker is a business intelligence and data analytics platform.

Setup instructions

Download JSON file

1. In the Fivetran dashboard, go to the Destinations page.

2. Select your managed BigQuery destination.

3. Go to the BI Tools tab, then click + BI Tool.

4. On the Select your BI tool page, select Looker.

5. Click Download file to download the OAuth Credentials JSON file.

6. Make a note of the following:

   • Project Name
   • Dataset
   • OAuth Credentials Email
   • Password

   You will need them to configure Looker.

7. Click Save.

Connect BigQuery to Looker

1. Open Looker.

2. In the Admin section, select Connections then click New Connection.

   

3. Enter a Name for the connection.

4. In the Dialect drop-down menu, select Google BigQuery Standard SQL.

5. Enter the Project Name, Dataset, and OAuth Credentials Email you found in Step 1.

   

6. In the OAuth Credentials P12 File field, upload the file you downloaded in Step 1.

7. Enter the Password you found in Step 1.

   

8. (Optional) Enable the Persistent Derived Tables option. Set Temp Dataset to looker_scratch, and set your PDT Maintenance Schedule.

   

9. Set Max Billing Tier and Max Billing Gigabytes to 100.

10. Use the default values for the other fields.

11. Click Add Connection.

    

12. Click Test to test the connection.

    

For more information, see Looker's BigQuery documentation.