/
Integrate with Looker

Integrate with Looker

Owned by Shivi Sivasubramanian
Last updated: Aug 05, 2024 by Meghali Deb Roy (Deactivated)
3 min read

Looker allows users querying their data to extract practically useful insights. When configured, Looker sends out a notification when certain criteria is met in a Look (a saved query). Extracted insights trigger alert creation in Compass so the right person can take action in a timely manner.

What does the integration offer?

Use Compass's Looker integration to create an alert based on query results in Looker. Compass adds an alerting layer top of the Looker, determines the right people to notify based on on-call schedules, notifies via email, text messages (SMS), phone calls and iOS and Android push notifications, and escalates alerts until the alert is acknowledged or closed.

How does the integration work?

When a scheduled query is run by Looker, Looker creates an alert in Compass. Looker can be configured to skip alert creation when the query returns something or nothing, and results changed or not changed since the last time.

Set up the integration

Looker is an API-based integration. Setting it up involves the following steps:

  • Add a Looker integration in Compass

  • Configure the integration in Looker

Add a Looker integration

In this release, only incoming integrations are fully supported in the Standard plan, at a team level. To use outgoing integrations or the outgoing part of bidirectional integrations, upgrade to a higher subscription plan. There may be restrictions on how you can create and apply integration rules as well.

You can add this integration only from your team’s operations page. Adding an integration from your team’s operations page makes your team the owner of the integration. This means Compass only assigns the alerts received through this integration to your team.

To add a Looker integration in Compass, complete the following steps:

  1. Go to your team’s operations page.

  2. On the left navigation panel, select Integrations and then Add integration.

  3. Run a search and select “Looker”.

  4. On the next screen, enter a name for the integration.

  5. Optional: Select a team in Assignee team if you want a specific team to receive alerts from the integration.

  6. Select Continue.
    The integration is saved at this point.

  7. Expand the Steps to configure the integration section and copy the integration URL.
    You will use this URL while configuring the integration in Looker later.

  8. Select Turn on integration.
    The rules you create for the integration will work only if you turn on the integration.

Configure the integration in Looker

To configure the integration of Looker with Compass, complete the following steps:

  1. In Looker, go to the Look for which you want to trigger alerts.

  2. Select Create Schedules or Edit Your Schedules in case you have existing schedule(s).

  3. Enter values into Delivery, Repeat, and Timezone to configure the schedule period as necessary.

  4. Select "Webhook" for Destination.

  5. Paste the API URL copied previously from Compass into Address.

  6. Modify Send if and other settings as needed.

    • To create an alert only when results changed, check the and results changed since last run checkbox.

    • To create an alert only when the query returns some result, select there are results from the combo box.

  7. Optional: Select Send Test to test the integration. Check if an alert is created in Compass.

  8. Select Save All.