Connecting to Looker

When you begin a Looker import for the first time you will need to go through a few steps to connect Looker as a data source for Coefficient. The Looker Admin will need to generate credentials for you.

Looker Admin Instructions to create credentials

Note: Coefficient will need the following information: Client ID, Client Secret, and Connection URL.

If your Database is behind a firewall/private network you will need to whitelist our IP addresses:

  1. Open the Coefficient Sidebar and click on the Menu.

Screenshot 2023-03-10 at 7.44.19 PM.png

  1. Select Connected Sources.

Screenshot 2023-03-10 at 7.45.33 PM.png

  1. Select the Source to connect to, in this case: Looker.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/9aeb6bb6-0f18-42e7-9835-75460646b7d8/Screen_Shot_2021-06-24_at_1.48.00_PM.png

  1. Fill in the Required Fields. Check the box if you want to share the connection with your team.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ed2b8aaf-c759-4a00-8a04-4b7fb6a51d6e/Screen_Shot_2021-06-24_at_2.41.23_PM.png

  1. Sharing your connection with the Team

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/d44ab10d-981d-49d1-92a3-c2ab20a3eb45/Screen_Shot_2021-07-09_at_9.20.19_AM.png

When you check the box to share the Looker connection with your team, they will not have to enter the Client ID and Client Secret for their connection.

The Client Secret will not be shared or visible to the team when sharing the data connection in Coefficient.

Your team is anyone that shares the same email domain as you.

Import options with Looker

NOTE: When setting up a new Looker import, it may take a few moments to load the data depending on the size of your Looker report(s).

Import from a Look/ Report or Dashboard

  1. In the Coefficient sidebar, select Import Data and choose Looker from the list of Data Sources. This will open up an additional window for you to browse thru the folders to select a Look or Dashboard.