After you connect Looker, Elementary will automatically and continuously extend the column-level-lineage to the dashboard level. This will provide you end-to-end data lineage to understand your downstream dependencies, called exposures.

Create permission set and role

To follow the least privilege security principle, before creating user for Elementary, create a permission set that allows to do only what is needed for Elementary to work.

  • Create a Permission Set

    1. In Looker, go to Admin > Roles. Click “New Permission Set”.
    2. Name the Permission Set “Elementary permissions” and check the boxes for the following permissions:
      • access_data
      • see_lookml_dashboards
      • see_looks
        • see_user_dashboards
        • see_sql
        • see_lookml
          • develop
  • Create a role

    1. Click “New Role”.
    2. Name the role “Elementary Role” as well.
    3. Select the “Elementary permissions” permission set
    4. Create the role.

Create a dedicated Elementary Looker user

In Looker, go to Admin > Users.

  1. Click Add Users. Provide any email you want.
  2. Under Roles, check “Elementary Role”.
  3. Click Done.

Create an API key for the user

  1. Find the user you just created and click Edit.
  2. You can give this user a name like Elementary.
  3. Under API Keys, click Edit Keys.
  4. Generate a new API key by clicking New API Key.
  5. Copy down the client ID and client secret.

Connecting Looker to Elementary

Navigate to the Account settings > Environments and choose the environment to which you would like to connect Looker. Choose the Looker BI connection and provide the following details to validate and complete the integration.

  • Host URL: Copy and paste the URL you see when you visit the homepage of your Looker instance. e.g. https://company.cloud.looker.com/
  • Client ID: The client ID you generated on Looker.
  • Client secret: The client secret you generated on Looker.
  • LookML code repository:
    • Token
      • Github
      • Gitlab - make sure the role is developer and the scopes include read_api, read_repository
    • Repository - The repository name where your LookML code is.

Connect Looker to Elementary environment