Looker Ingestion Guide: Setup & Prerequisites
In order to configure ingestion from Looker, you'll first have to ensure you have an API key to access the Looker resources.
Looker Prerequisites
Login
Login to https://<instance-name>.cloud.looker.com
.
Replace <instance-name>
by your looker instance name. (For example: https://abc.cloud.looker.com
)
Navigate to Admin Panel
Navigate to Admin Panel
on looker home page.
Open Roles Panel
Search for Roles
on Admin Panel
and click Roles
to open Roles Panel
.
Create A New Permission Set
On Role Panel
follow below steps to create a New Permission Set
.
Go to New Permission Set
Set name for New Permission Set
, says DataHub Connector Permission Set
and select following permissions
Permission List
- access_data
- see_lookml_dashboards
- see_looks
- see_user_dashboards
- explore
- see_sql
- see_lookml
- clear_cache_refresh
- manage_models
- see_datagroups
- see_pdts
- see_queries
- see_schedules
- see_system_activity
- see_users
Scroll down and select all permissions mentioned above & click New Permission Set
Create A Role
On Role Panel
follow below steps to create a new role.
Go to
New Role
Set name for
New Role
, saysDataHub Extractor
and set following fields on this window.- Set
Permission Set
to permission set created in previous step (i.eDataHub Connector Permission Set
) Model Set
toAll
- Set
Scroll down & click
New Role
Create A New User
On Admin Panel
follow below steps to create a new user.
Search for
Users
and clickUsers
to openUsers Panel
Click
Add Users
.On
Adding a new user
set detail in following fields.- Add user's
Email Addresses
- Set
Roles
to the role created in previous step i.e.DataHub Extractor
- Add user's
Click
Save
Create An API Key
On User Panel
follow below steps to create an API key.
Click on newly created user on
User Panel
Click
Edit Keys
to openAPI Key Panel
.On
API Key Panel
clickNew API Key
to generate a newClient Id
andClient Secret
.
LookML Ingestion Guide: Setup & Prerequisites
Follow below steps to create GitHub Deploy Key
Generate a private-public ssh key pair: This will typically generate two files, e.g.
looker_datahub_deploy_key
(this is the private key) andlooker_datahub_deploy_key.pub
(this is the public key)ssh-keygen -t rsa -f looker_datahub_deploy_key
Login to GitHub: Login to https://github.com
Add Deploy Key: Navigate to
GitHub Repository
->Settings
->Deploy Keys
and add public key i.e. looker_datahub_deploy_key.pub as deploy key with read accessMake note of the private key file, you will need to paste the contents of the file into the GitHub Deploy Key field later while configuring ingestion on DataHub Portal.
Next Steps
Once you've done all of the above steps, it's time to move on to configuring the actual ingestion source within DataHub.
Need more help? Join the conversation in Slack!