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

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 on looker home page.

Looker home page

Open Roles Panel

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

Looker roles search

Create A New Permission Set

On Role Panel follow below steps to create a New Permission Set.

Go to New Permission Set

Looker 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

Looker permission set window

Create A Role

On Role Panel follow below steps to create a new role.

  1. Go to New Role

    Looker new role button

  2. 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
  3. Scroll down & click New Role

    Looker new role window

Create A New User

On Admin Panel follow below steps to create a new user.

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

    Looker user search

  2. Click Add Users.

    Looker add user

  3. 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
  4. Click Save

    Looker new user window

Create An API Key

On User Panel follow below steps to create an API key.

  1. Click on newly created user on User Panel

    Looker user panel

  2. Click Edit Keys to open API Key Panel.

    Looker user view

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