Looker Setup Guide

Looker is a business intelligence and data analytics platform.

Setup instructionslink

Download JSON filelink

1. In the Fivetran dashboard, click BI Tools, then click + BI Tool.

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

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

4. Make a note of the following:

   • Project Name
   • Dataset
   • OAuth Credentials Email
   • Password

   You will need them to configure Looker.

5. Click Save.

Connect BigQuery to Lookerlink

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.