Looker Setup Guide Lite
Follow our setup guide to connect Looker to Fivetran.
Prerequisites
To connect Looker to Fivetran, you need a Looker account with Admin role.
Setup instructions
Find domain
Log in to your Looker account.
Find the domain in your Looker URL and make a note of it. For example:
- If your URL is
https://fivetrandemo.looker.com/folders/home, then your domain isfivetrandemo.looker.com. - If your URL is
https://fivetrandemo.cloud.looker.com/folders/home, then your domain isfivetrandemo.cloud.looker.com.
- If your URL is
Generate API credentials
- On the navigation menu, click Admin and then go to the Users tab.
- Select your user and then click Edit.
- In the API3 Keys section, click Edit Keys.
- Click New API3 Key. Make a note of Client ID and Client Secret. You will need them to configure Fivetran.
Finish Fivetran configuration
In the connection setup form, enter your chosen Destination schema name.
Enter the Domain you found in Step 1.
Enter the Client ID and Client secret you found in Step 2.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.
(Context Layer only) Set the Enable GitHub integration toggle to ON to sync additional metadata from your GitHub repository into your context layer. Then, address the following fields:
- GitHub Repository URL: Enter the SSH URL of your GitHub repository.
- SSH Deploy Key: Copy this generated SSH public key. Next, follow GitHub's Deploy key setup instructions to add it to your semantic model repository. Paste the public key into the Key field and leave Allow write access unselected.
Click Save & Test. Fivetran will take it from here and sync data from your Looker account.