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

Follow below steps to create API key.

1. Login: Login to https://<instance-name>.cloud.looker.com. Replace <instance-name> by your looker instance name. For example: https://abc.cloud.looker.com

2. Admin Panel: Navigate to Admin Panel on looker home page.

   

3. Roles Panel: Search for Roles on Admin Panel and click Roles to open Roles Panel.

   

4. Create A New Permission Set: On Role Panel follow below steps to create a New Permission Set.

   a. Go to New Permission Set

   

   b. Set name for New Permission Set, says DataHub Connector Permission Set and select following permissions

   • 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

     

5. Create A Role: On Role Panel follow below steps to create a new role.

   a. Go to New Role

   

   b. Set name for New Role, says DataHub Extractor and set following fields on this window.

   • Set Permission Set to permission set created in previous step i.e DataHub Connector Permission Set

   • Model Set to All

     Scroll down & click New Role

     

6. Create A New User: On Admin Panel follow below steps to create a new user.

   a. Search for Users and click Users to open Users Panel

   

   b. Click Add Users.

   

   c. 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

     click Save

     

7. Create An API Key: On User Panel follow below steps to create an API key.

   a. Click on newly created user on User Panel

   

   b. Click Edit Keys to open API Key Panel.

   

   c. On API Key Panel click New API Key to generate a new Client Id and Client Secret.

   

LookML Ingestion Guide: Setup & Prerequisites

Follow below steps to create GitHub Deploy Key

1. Generate a private-public ssh key pair: This will typically generate two files, e.g. looker_datahub_deploy_key (this is the private key) and looker_datahub_deploy_key.pub (this is the public key)

      ssh-keygen -t rsa -f looker_datahub_deploy_key

2. Login to GitHub: Login to https://github.com

3. 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 access

   

4. Make 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!