# Looker

## Before you start

To connect Looker to Select Star, you will need...

* Admin access to your Looker account.
* Admin access to your LookML repo(s) in GitHub.

Complete all of the following steps to see Looker metadata, lineage, and popularity in Select Star.

{% hint style="info" %}
If you want to **create an API3 Key** on a **Looker account with Admin access**, start at [step 3](#3.-create-a-new-api3-key).
{% endhint %}

1. [Create a Select Star Permission Set and Role in Looker](#1.-create-a-select-star-permission-set-and-role-in-looker)
2. [Create a Select Star user in Looker](#2.-create-a-select-star-user-in-looker)
3. [Create a new API3 Key](#3.-create-a-new-api3-key)
4. [Grant view access to Shared Folder](#4.-grant-view-access-to-shared-folder)
5. [Connect Looker API in Select Star](#connect-looker-to-select-star)
6. [Connect LookML repo to Select Star](#connect-lookml-repo-to-select-star)

## 1. Create a Select Star Permission Set and Role in Looker

Create a new Permission Set called `Select Star` with the following permissions:

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-bc22b65265ad4b944b48ec25fcfcf60a9859794f%2FScreen%20Shot%202021-11-10%20at%2010.33.10%20AM.png?alt=media\&token=565fe439-160f-461d-bc57-90015f714908)

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-dfd7ea6a18eaf00f0873d43848c7df222ef2ce0f%2FScreen%20Shot%202021-11-10%20at%2010.33.27%20AM.png?alt=media\&token=b5c1a07a-6fea-4c3d-8a2e-ec3307174a78)

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-8f14abed64d09913de6dfc798a709dbd28797a85%2FScreen%20Shot%202021-11-10%20at%2010.33.34%20AM.png?alt=media\&token=9245026d-1d8a-4672-b825-177a4c55bb78)

Create a new role called `Select Star Role` . Choose the `Select Star` Permission Set you just created and the `All` Model Set as shown below.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-2972b97279d5b1bbf49f07b638891f3753f107fc%2FScreen%20Shot%202021-11-10%20at%2011.17.21%20AM.png?alt=media\&token=b1cfed22-c07b-432c-be1d-5c19eaa5b406)

When created, the Role Permissions will look like the following:

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-7fcd2ae4f3292d64851d27ce742d75932433ead7%2FScreen%20Shot%202021-11-10%20at%2011.19.29%20AM.png?alt=media\&token=ede83155-f73f-49d8-a7ab-3e67f0419732)

## 2. Create a Select Star user in Looker

Now the role is created, you can assign the `Select Star Role` to a Looker User.

You can either assign the role to an existing Looker user, or create a new user by sending an invite to <selectstar@getselectstar.com> with the `Select Star Role`.

{% hint style="info" %}
You can also create an API3 key in your own Looker account, as long as your permissions include everything from step 1.
{% endhint %}

## 3. Create a new API3 Key

From the main Looker page, Click **Admin**, then **Users**.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-f52563945859994fc392d14bd0c12e54ec088022%2FLooker_admin_users.gif?alt=media\&token=29c76589-41c6-4d7c-93b9-7498928e5bdb)

Find your Select Star user and click the **Edit** button. Under API3 Keys, click the **Edit Keys** button.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-d13e72ce01b7e69cf20372a27e223a040dfa2b13%2FScreen%20Shot%202021-11-10%20at%2011.45.23%20AM.png?alt=media\&token=43e8f78c-0f0a-4629-a2bd-4cb171a01a84)

Create a **New API3 Key**.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-80dd7ee25aa92c6320bb1529a1e1c464efffe3c9%2FScreen%20Shot%202021-11-10%20at%2011.49.26%20AM.png?alt=media\&token=853a0a49-7762-45bc-b9a4-3e82ef08ac42)

You will see a new API3 Key with a **Client ID** and **Client Secret**.

## 4. Grant view access to Shared Folder

You may need to grant view access to the user you created in [step 1](#1-create-select-star-user-in-looker) on the Shared Folder in order to see your dashboards in Select Star.

Navigate to the Shared folder in Looker.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-e27cfe843b6a74bba0b32bfca6eb80e53bb3e899%2FScreen%20Shot%202021-09-28%20at%201.59.51%20PM.png?alt=media\&token=5d9e49e2-4aa8-4473-8eaf-6df2fe12a82c)

Find the gear icon in the upper right part of the screen and click **Manage Access.**

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-fc97ecc76e3a811c271bcbed24136ec56629dacd%2FScreen%20Shot%202021-09-28%20at%201.58.38%20PM.png?alt=media\&token=45e8fede-da14-46d5-baa7-3853fba11ed3)

Grant **View** access to the Select Star user you created.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-6de3a2e35e601931e3631ad27384ead878c24994%2FScreen%20Shot%202021-09-28%20at%201.55.26%20PM.png?alt=media\&token=6216f66c-b5f7-466a-b10d-15e982912bce)

## 5. Connect Looker API to Select Star

Go to the Select Star **Settings**. Click **Data** in the sidebar, then **+ Add** to create a new Data Source.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-1b5ef3716637dedbfa0eb69326a83270b0773b0b%2FAdd_Data_Source_Settings.gif?alt=media)

Choose **Looker** in the Source Type dropdown and provide the following information:

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-08eafe135454044ae686ebaa68713fe073c99cb0%2FScreen%20Shot%202021-11-10%20at%2011.58.08%20AM.png?alt=media\&token=977b2396-3754-417a-aa62-16f6efbc5f99)

* **Display Name:** This value is `Looker` by default, but you can override it if desired.
* **API Client ID:** The API3 Client ID from [Step 4](#4.-grant-view-access-to-shared-folder) above.
* **API Client Secret:** The API3 Client Secret from [Step 4](#4.-grant-view-access-to-shared-folder) above.
* **Host URL:** The full URL of your Looker instance.

Click **Connect** to proceed.

## **6. Connect LookML repo to Select Star**

In order for Select Star to connect the data warehouse and Looker data models, access to the GitHub repo for the LookML code is required. If you do not need to see lineage, you can click **Next** to skip this step.

Select Star will automatically detect LookML projects connected to your Looker instance.

{% hint style="info" %}
If you do not see any LookML projects, please check the Model Set in [Step 1](#1.-create-a-select-star-permission-set-and-role-in-looker). Select Star detects LookML projects based on access to Looker models using the API.
{% endhint %}

{% hint style="warning" %}
You must use a SSH connection when integrating Looker with Git. This is required to set up deploy keys on most major Git Repositories including Github and Gitlab.

Check the *Connecting to Git using SSH* section in the Looker docs.

<https://docs.looker.com/data-modeling/getting-started/setting-up-git-connection>
{% endhint %}

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-9645c980d313bd84b5cbdf7f9bf7ed9870a05f8e%2FScreen%20Shot%202021-11-10%20at%2012.01.01%20PM.png?alt=media\&token=02dbc566-3ec6-43e9-8e72-c76b0ae29a16)

For each project you want to connect, click **Copy Key**.

Open your browser in a new window or tab, and go to your LookML repo in GitHub.

Click on **Settings >** **Deploy keys** on the sidebar.

Click the **Add deploy key** button in the corner.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-a3f7303eb457c0faceb37498d69740958b43a3c3%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

Paste in the entire key copied from Select Star into the **Key** text box.

Set the title to a descriptive name, such as `Select Star Ingestion Key`.

**You do not need to allow write access.**

Click **Add key.**

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-4fb96d7231f3963f90f7e89bc2746f6db4e6f3f6%2Fimage.png?alt=media)

Return to Select Star and click the **Next** button at the bottom of the modal.

Your metadata should start loading automatically. Please allow 24-48 hours to completely generate popularity and lineage.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-46450c1ec9645fe7c26c89000df9cc169a839a6f%2FScreen%20Shot%202021-11-10%20at%2012.04.30%20PM.png?alt=media\&token=ee6fe7ab-2a4a-4754-b0e3-191f75bcb8bd)

When the sync is complete, you'll be able to explore Looker in Select Star. See the link below for more information on Looker in Select Star.

{% content-ref url="../learning-data/getting-started-looker" %}
[getting-started-looker](https://docs.selectstar.com/learning-data/getting-started-looker)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.selectstar.com/integrations/looker.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.