Skip to main content
Version: Next

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.

    Looker home page

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

    Looker roles search

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

    a. Go to New Permission Set

    Looker 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

      Looker permission set window

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

    a. Go to New Role

    Looker new role button

    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

      Looker new role window

  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

    Looker user search

    b. Click Add Users.

    Looker add user

    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

      Looker new user window

  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

    Looker user panel

    b. Click Edit Keys to open API Key Panel.

    Looker user view

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

    Looker new api key

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

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

    Looker home page

  2. 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!