Looker

Setup

The Looker API is a secure, "RESTful" application programming interface for managing your Looker instance and fetching data through the Looker data platform. With the Looker API, you can write applications or automation scripts to provision new Looker user accounts, run queries, schedule reports, etc. Just about anything you can do in the Looker application you can do via the Looker API.

Step One - Create Client ID and Client Secret

1. Create API credentials on the Users page in the Admin section of your Looker instance. If you're not a Looker admin, ask your Looker admin to create the API credentials for you. Get to know more about it here. In case you are the admin go to users tab.

2. On the users tab click on the user for which you want to create the API credentials.

3. Click on Edit keys

4. Click on New API Key

5. Store the Client Id and Client Secret

Step Two- Enter details on 5X

Host URL

This is the host URL from where you access Looker instance.

API Host URL

Your Looker admin can specify an API path by entering it in the API Host URL field on the Admin > API page in the following format:

https://<instance_name>.cloud.looker.com

Copy this and paste it in on 5X. Learn more about here

Client ID

Paste the Client ID that you generated in Step 1.

Client Secret

Paste the Client Secret that you generated in Step 1.

Step Three -Validate details on 5X

Once you have entered the details click on validate we will check the Looker credentials before adding the account to 5X account.

Notes

Connections can be made from Looker to different data warehouses (Snowflake, GBQ, redshift) from the platform.

If the data warehouses are behind a firewall, then the following Looker IP addresses needs to be added to allow list for the connections to work.

34.82.120.25

35.247.5.99

35.233.172.23

35.197.64.57

34.82.193.215

35.233.222.226

35.247.117.0

35.247.61.151

35.233.249.160

35.247.55.33