home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Creating alerts

If you have the appropriate user permissions, you can create alerts on query-based or Look-linked tiles on user-defined dashboards or LookML dashboards that use new or legacy dashboards.

Creating an alert

Alerts can be set only on tiles that have at least one numeric measure or table calculation in the tile’s visualization. The visualization type and the fields present in the dashboard tile visualization determine whether you can set an alert condition that is based on a single field or table calculation value or on “any” field or table calculation value.

Depending on the dashboard tile’s visualization type and the kinds of fields that are present in the visualization, Looker checks your data in different ways. When you create an alert, it will be one of these types:

Alerts that are based on a table calculation that includes a row total are not supported.

To create alerts, your dashboard must be out of edit mode and you must be out of Development Mode.

To create an alert on a dashboard tile, click the tile’s bell icon and then click the New button at the bottom of the list of the existing alerts that you are permitted to see (you may need to scroll to see the entire list). If no alerts are currently configured for that tile, or if you do not have permission to see any existing alerts on that tile, hover over the dashboard tile to reveal the bell icon. Click the bell icon to open the alert creation window:

In the alert creation window, you can specify several components of your alert:

Each alert query captures the dashboard and tile settings at the time the alert was created. An alert query will not pick up any changes that are made to the dashboard or tile after the alert is created, including changes to dashboard filters or to the appearance of your dashboard tile’s visualization (such as changes to the visualization type). You would need to create a new alert after any changes are implemented for them to apply to your alert and notifications.

With the Enhanced Alerts Labs feature enabled, an alert syncs with many of the common types of changes that you or other users make to its underlying dashboard or tile — without the need to recreate the alert. See the Effect of dashboard edits on alerts documentation page for more information.

Naming an alert

The default alert title indicates which conditions need to be true for the alert to be triggered. If you want to rename your alert:

  1. Click the three-dot menu, and then click Edit Alert.
  2. Click once on the alert title.
  3. Enter a custom title, and then click away from the field or hit the Enter key to see your update.
  4. Click Save Alert to save your new title.

Your custom alert title will appear in any publicly visible alerts that are listed in the alert view window on that tile. The custom title will also appear in the alert notifications.

Hover over the custom title of any alert in the alert view window to see the conditions that trigger that alert.

Setting alert conditions

In the Condition drop-downs in the alert creation window, you can set the components that tell Looker how to check the tile data for changes and the kinds of changes that trigger an alert notification.

The alert condition is represented by these components:

These conditions include:

If the query contains a date or time field, additional conditions are available:

Using these comparison conditions with time series data has some additional considerations. For more information, see this Help Center article on Setting alerts based on time series data.

Looker only creates alerts that are based on comparisons of whole number and decimal data values. However, with a simple workaround, you can set alerts that are based on percentage changes of data values.

Setting alert notifications

Under the Where to send it section of the alert creation window, you can specify the destination of the alert notification.

Sending alerts to email

To send your alert notifications to email, select Email from the Where to send it drop-down. You can designate the recipients of the alert email notification. Your email will be listed by default, and you can modify the list of recipients as necessary. Your permissions determine which email domains you’re able to send alert notifications to.

Each recipient will receive an email with information about the alert and an option to unfollow the alert. If they choose to unfollow the alert, their email address will be removed from the recipient list.

Sending alerts to the Slack Attachment (API Token) integration

The Slack Attachment (API Token) action is available from the Looker Action Hub. When this action is enabled on the Actions page in the Admin panel, Slack Attachment (API Token) will show up as an option in the Where to send it drop-down of the alert creation window.

Admins of customer-hosted instances that use a self-hosted action hub server must restart their action hub server when they update their Looker instance.

Once a Looker admin has enabled the Slack Attachment (API Token) action and the Looker App bot user has been set up in Slack, you can send alert notifications to Slack by using the Slack Attachment (API Token) integration:

  1. Select Slack Attachment (API Token) from the Where to send it drop-down.

    The Share In field appears, populated with the channel and direct message options that are based on the credentials of the Looker App bot user in the Slack workspace:

  1. Select the direct message or channel that you want to send the alert notification to. Anyone in that channel will see a notification with information pertaining to the tile that the alert is set on:

    • A PNG image of the dashboard tile visualization
    • A message with the name of the dashboard or the custom alert title and the conditions that triggered the alert
    • A link to navigate to the tile’s dashboard
    • A link to unsubscribe from the alert notification

Even if embed users have permissions to send alert notifications to the Slack Attachment integration, they will not see the Slack Attachment (API Token) in the Where to send it drop-down unless their Slack workspace is configured for the Looker App bot user.

Sending alerts to the Slack integration

The Slack action is available from the Looker Action Hub. When this action is enabled on the Actions page in the Admin panel, Slack will show up as an option in the Where to send it drop-down of the alert creation window. A Looker admin must also connect at least one Slack workspace to the Looker instance.

The Slack integration is available to Looker-hosted deployments that satisfy these conditions:

  • The Looker instance is on 6.24 or later.
  • The IP Allowlist feature is not enabled on the Looker instance.

This Slack integration is not supported for customer-hosted instances.

To enable installation of the Looker App, your Slack workspace owner may need to adjust the app installation settings for your Slack workspace.

Once a Looker admin has enabled the Slack action and connected the appropriate Slack workspaces, you can send alert notifications to Slack:

  1. Select Slack from the Where to send it drop-down.

    If you have not already authenticated into Slack, a Sign in with Slack button appears under the Where to send it drop-down:

  1. Click Sign in with Slack. Looker will request access to the Slack workspace. If your Looker admin has connected multiple Slack workspaces to your Looker instance, a drop-down menu appears in the upper right of the OAuth page. Select the appropriate Slack workspace from the drop-down. Click Allow.

You can also authenticate into Slack from your personal account page in Looker. If your Looker admin has connected multiple Slack workspace to your Looker instance, you’ll see a list of workspaces with options to log in to each one individually.

After you have logged in to at least one Slack workspace, the rest of the Slack fields in the alert creation window appear:

  1. The Workspace drop-down shows a list of any workspaces that you’re signed in to. Select a workspace from the list. If you do not see the workspace to which you want to send the alert notification, you can see a list of the workspaces that your Looker admin has connected to your Looker instance and sign in to each one individually from your personal account page in Looker.
  2. The Share In field is populated with the channel and direct message options that are based on the selected Slack workspace. Select the direct message or channel that you would like to send the alert notification to. Anyone in that channel will see a notification with information pertaining to the tile that the alert is set on:

    • A PNG image of the dashboard tile visualization
    • A message with the name of the dashboard or the custom alert title and the conditions that triggered the alert
    • A link to navigate to the tile’s dashboard
    • A link to unsubscribe from the alert notification

Even if embed users have permissions to send alert notifications to the Slack integration, unless their Slack workspace is connected to the Looker instance, they will not see the Slack option in the Where to send it drop-down.

Setting alert frequency

You can set the frequency at which Looker will check your data for changes (and to send an alert notification if the alert conditions are met) under the Frequency section of the alert creation window. The default frequency is Daily at 05:00. These are the available frequency options:

Start and End times are inclusive. For example, if you set Check every to 12 hours with a Start time of 05:00 and an End time of 17:00, Looker will check the data at 05:00 and 17:00.

Looker sends alerts according to the time zone that is indicated in the Application Time Zone setting on the Admin Settings page, or, if enabled, the alert creator’s User Specific Time Zone.

Setting alerts permissions

You can set your alert’s permissions by selecting the Public or Private options from the Permissions drop-down in the alert creation window. If an alert is not unfollowable, it is marked Public by default, which means that any Looker user with following permissions on the dashboard tile’s underlying content can see your alert and its settings on the alert view window. They can also follow your alert so that they can receive email notifications when your alert’s conditions are triggered.

Alerts to the Slack and Slack Attachment (API Token) integrations cannot be followed; however, if you are creating an alert to one of these destinations and mark it Public, other users will be able to see and duplicate your alert settings.

You can set your alert to Private so that its settings are viewable only to you (and admins) by choosing the Private option from the Permissions drop-down in the alert creation window.

For security reasons, some alerts cannot be viewed or followed by other users, and you will not be able to view or set the alert permissions.

Top