Follow these steps to connect your Looker instance to Select Star.
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.
Create a new Permission Set called
Select Starwith the following permissions:
Create a new role called
Select Star Role. Choose the
Select StarPermission Set you just created and the
AllModel Set as shown below.
When created, the Role Permissions will look like the following:
Now the role is created, you can assign the
Select Star Roleto a Looker User.
From the main Looker page, Click Admin, then Users.
Find your Select Star user and click the Edit button. Under API3 Keys, click the Edit Keys button.
Create a New API3 Key.
You will see a new API3 Key with a Client ID and Client Secret.
Navigate to the Shared folder in Looker.
Find the gear icon in the upper right part of the screen and click Manage Access.
Grant View access to the Select Star user you created.
Go to the Select Star Settings. **** Click Data in the sidebar, then + Add to create a new Data Source.
Choose Looker in the Source Type dropdown and provide the following information:
- Display Name: This value is
Lookerby default, but you can override it if desired.
- Host URL: The full URL of your Looker instance.
Click Connect to proceed.
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.
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.
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.
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.
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.