Add Looker BI Tool to Fivetranlink
- On the top-right of the “BI Tools” page, click on “New BI Tool”.
- Select “Looker” and you will be brought to the Looker setup form.
Click “Save & Test” in the Looker setup form.
Add Connection to Lookerlink
In the Admin section of Looker, navigate to the Connections page and click “New Connection”.
Name is usually a descriptive name of this data warehouse, like “production” or “bigquery”.
Select Dialect of “Google BigQuery Standard SQL”.
Use the values in the Fivetran setup wizard to fill in the form.
Download the OAuth Credentials P12 File clicking the button “Download file” in the Looker setup wizard. Then, upload the file into looker. Use password specified in “Password” field in the Looker setup wizard.
If you are going to use Persistent Derived Tables, select the option and set Temp Dataset to “looker_scratch”. PDT Maintenance Schedule is up to you.
Set both Max Billing Tier and Max Billing Gigabytes to “100”. Leave the other values as defaults.
Add Connection to complete this setup.
Finally, test the connection and you should see all tests pass.