What you can do
Catalog & Lineage
Looker dashboards, Looks, and explores appear as assets in Paradime’s catalog and lineage, so you can trace dbt™ models through to the reports built on them.
Prerequisites
We advise creating a new Looker user, something like paradime_user in order to grant the correct access required to connect all your Looker nodes to your data models in Paradime.
Step 1: Create a dedicated Looker user for Paradime
1. Create a new permission set called paradime-permission and include permissions to:
access_datasee_lookml_dashboardssee_lookssee_user_dashboardssee_sqlsee_lookmldevelopsee_schedulessee_pdtssee_system_activty
2. Create a new model set and include all models for which you want to visualize the data dependencies in Paradime lineage.
3. Create a new role in Looker called paradime-role and add the permissions set created in step:1 and the model set created in step:2:
4 Create the Looker user as paradime_user and grant role paradime-role
👉 See also:
https://cloud.google.com/looker/docs/admin-panel-users-roles
Step 2: Generate your Looker API 4 credentials
Paradime connects to Looker via the Looker API4. In order for Paradime to connect to Looker we require:- Host name: usually this should look something like this
https://<yourcompany>.cloud.looker.comyou can find this in your General > Settings section in Looker. - Client ID
- Client Secret
Generate your API4 credentials
- Create API4 credentials on the Users page in the Admin section of your Looker instance - navigate to Users pages, click on the Edit button for the user you want to generate the API credentials, then click on Edit keys and finally to New API4Key. If you’re not a Looker admin ask your Looker admin to create the API3 credentials for you.
- API4 credentials are always bound to a Looker user account. API requests execute “as” the user associated with the API4 credentials. Calls to the API will only return data that the user is allowed to see and modify.
- The API4 credentials that you generated include a client ID and a client secret. You’ll need to provide these to the Paradime in order to connect to Looker.
Catalog & Lineage
Bring Looker assets into Paradime’s data catalog and column-level lineage, so you can trace dbt™ models through to the dashboards and Looks built on them. The Looker integration is set up by the Admin user for your organization profile. In Paradime, go to Settings → Integrations (see connecting integrations), find Looker, and click Connect.Step 3: Connection parameters
Click on connect and add the API credentials of your Looker user.Step 4: Connect your Looker repository
Select your git host provider and add you Looker repository Git URL. Paradime will generate a Deploy Key for your repository. You must provide this Deploy Key in the Repository configuration of your Git host.💡 Note that for the Looker repository, Paradime will need only Read access.