Looker

Integrating Revefi with Looker enables seamless tracking of metadata and lineage of visualizations and looks.

Note: If you are not a Looker Admin, have your Looker admin follow the steps below to create the API credentials for you.

Step 1: Create a new permission set

Navigate to Roles and create a new permission set called Revefi Permission Set. Select the see_system_activity permission.

Step 2: Create a new role

Under Roles, create a new role called Revefi Role. Select the Revefi Permission Set.

Step 3: Create a new user

Go to the Users page and create a new user called looker-revefi-user@<domain>.com. Note: this email does not have to be valid. In the Roles section, select Revefi Role to assign the role to the user.

Step 4: Create API keys for the user

On the Users page, click on the Edit Keys button. The Edit User API Keys page opens and shows the existing API keys. Click the New API key button to generate a new key. Note the client ID and client secret generated in this step.

Step 5: Connect Looker to Revefi

The API credentials that you generated include a client ID and a client secret. You'll need to provide these to the Looker connection within Revefi along with the URL for your Looker instance via the Connections page in app.revefi.com:

📘

Partial Lineage

You may observe incomplete lineage representation within Revefi for Looker Persistent Derived Tables. To enable full lineage tracking for Persistent Derived Tables, please contact [email protected].

Troubleshooting Connection Issues

  • Error: Validation failed. Please check your credentials.

What’s Next

Once that is done, Revefi will get all definitions from Looker (models, explores, dashboards, looks, views and boards) and create lineage with your warehouse tables. All your BI artifacts now have Revefi Monitoring enabled. You can easily see the health of a visualization by introspecting health of underlying tables. From any of your warehouse tables, you can also use lineage to get to impacted Looker objects.