Docly

Looker Integration

Estimated reading: 2 minutes

This document walks through the steps required to create a service account in your Looker, which will be connected to your Stemma Instance for dashboard metadata extraction.

Stemma uses the Looker APIs (via Looker Python SDK) to extract the metadata of Folders, Dashboard, Dashboard Elements and Explore Queries, and data sources associated with them. The Stemma integration is purely read-only and doesn’t modify any assets in Looker. Read Looker’s docs: https://docs.looker.com/reference/api-and-integration

Stemma takes leverage of the API3 keys (Client ID & Client Secret) to make a secure connection between your Stemma and Looker instances. Below you can find out the steps required to create the new API3 keys for this integration.

What is extracted?

Stemma extracts information about Folders, Dashboard, Dashboard Elements, Explore Queries, and data sources associated with them.

Stemma will not extract Dashboards that are deleted, hidden or in a user’s personal folder.

Steps

Step 1: Make sure you have a Looker Admin role

Looker → Stemma integration requires an Admin role to fetch the correct data and build the relationships between the entities like Table Lineage, Dashboard Owners, etc.

So, as a first step, make sure you have an Admin role.

Step 2: Generate API3 keys

The next step is to create an API3 Key. From the Admin menu, navigate to the Users page.

Find the user you want to use to generate the API3 key, and click the “Edit” button under the Actions column.

Once you are on the “Edit User” page, find the API3 Keys settings, and click “Edit Keys

Click “New API3 Key” to generate a new Client ID and Client Secret.

Step 3: Provide the details to Stemma

  1. Navigate to the Admin tab of the Stemma UI and choose Connections and Add New Connection:
  1. In the pop-up window, choose Looker as the Connection type, provide a Connection Name, and then fill out the fields in the dialog box as follows:
    • Base URL
      Example: <https://stemma.cloud.looker.com/>
    • Client ID
      The one you generated in Step 2
    • Client Secret
      The one you generated in Step 2
  2. When you are finished, click Save Connection.