• Get started
  • Documentation

Integrate Opsgenie with Looker

Looker logo

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 Opsgenie so the right person can take action in a timely manner.

What does Opsgenie offer to Looker users?

Use Opsgenie’s Looker integration to create an alert based on query results in Looker. Opsgenie 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 & Android push notifications, and escalates alerts until the alert is acknowledged or closed.

Functionality of the integration

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

Add Looker integration in Opsgenie

If you're using Opsgenie's Free or Essentials plan or if you’re using Opsgenie with Jira Service Management's Standard plan, you can add this integration from your team dashboard only. The Integrations page under Settings is not available in your plan.

  1. Go to Teams and select your team.

  2. Select Integrations on the left navigation and then select Add integration.

Adding the integration from your team dashboard will make your team the owner of the integration. This means Opsgenie will assign the alerts received through this integration to your team only. Follow the rest of the steps in this section to set up the integration.

  1. Go to Settings > Integrations. Search for Looker and select Add

  2. Specify who is notified of Looker alerts using the Responders field. Auto-complete suggestions are provided as you type.

  3. Copy the API Key.

  4. Click Save Integration.

Configuration in Looker

  1. Go to the Look to trigger alert creation for and click the Create Schedules link at the right of the screen, or Edit Your Schedules link in the case that there are existing schedule(s).

Looker schedule

2. Configure the schedule period using "Delivery", "Repeat", and "Timezone" fields.

3. Select Webhook from the "Destination" combo box.

4. Paste the Opsgenie API key into the "Address" field.

Looker webhook

5. (Optional) Adjust Send If settings according to your needs. For instance;

  • 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.

6. (Optional) Test that the integration works by clicking Send Test. Check to see that an alert is created in Opsgenie after a short time.

7. Click Save All.

Still need help?

The Atlassian Community is here for you.