Looker Integration

Looker is a business intelligence software and big data analytics platform that helps to explore, analyze, and share real-time business analytics easily.

250

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

  1. Please create an Opsgenie account if you haven't done so already.
  2. Go to Opsgenie's Looker Integration page.

🚧

For Free and Essentials plans, you can only add the integrations from the Team Dashboards, please use the alternative instructions given below to add this integration.

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

📘

An alternative for Step 2) and Step 3) is to add the integration from the Team Dashboard of the team which will own the integration. To add an integration directly to a team, navigate to the Team Dashboard and open Integrations tab. Click Add Integration and select the integration that you would like to add.

  1. Copy the API Key.
  2. Click Save Integration.
2230

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).
686
  1. Configure the schedule period using "Delivery", "Repeat", and "Timezone" fields.
  2. Select Webhook from the "Destination" combo box.
  3. Paste the Opsgenie API key into the "Address" field.
1896
  1. (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.
  2. (Optional) Test that the integration works by clicking Send Test. Check to see that an alert is created in Opsgenie after a short time.
  3. Click Save All.