Looker is a business intelligence and data analytics platform.
Setup instructionslink
Download JSON filelink
-
In the Fivetran dashboard, click BI Tools, then click + BI Tool.
-
On the Select your BI tool page, select Looker.
-
Click Download file to download the OAuth Credentials JSON file.
-
Make a note of the following:
- Project Name
- Dataset
- OAuth Credentials Email
- Password
You will need them to configure Looker.
-
Click Save.
Connect BigQuery to Lookerlink
-
Open Looker.
-
In the Admin section, select Connections then click New Connection.
-
Enter a Name for the connection.
-
In the Dialect drop-down menu, select Google BigQuery Standard SQL.
-
Enter the Project Name, Dataset, and OAuth Credentials Email you found in Step 1.
-
In the OAuth Credentials P12 File field, upload the file you downloaded in Step 1.
-
Enter the Password you found in Step 1.
-
(Optional) Enable the Persistent Derived Tables option. Set Temp Dataset to
looker_scratch
, and set your PDT Maintenance Schedule. -
Set Max Billing Tier and Max Billing Gigabytes to
100
. -
Use the default values for the other fields.
-
Click Add Connection.
-
Click Test to test the connection.
For more information, see Looker’s BigQuery documentation.