The Alerts History page in the Alerts & Schedules section of the Admin menu shows the recent history of all active alerts, including running, complete, and failed alerts.
Looker admins can manage all active and inactive alerts on the Alerts management admin page.
A new alert job is executed at the frequency specified when the alert was created. For example, if an alert specifies sending a notification to certain addresses every Monday once the alert conditions are met, then Looker will make a new alert job each Monday to send that content to those recipients. However, Looker won’t actually send the notification unless the alert conditions have been met.
At the top of the Alerts History page, you can filter the active alert jobs by status:
- All: all alerts, sorted in descending order from most recent
- Running: only alert jobs that are currently running
- Complete: only alert jobs that completed successfully
- Failed: only alert jobs that failed to complete successfully
If a user deletes the dashboard or dashboard tile that the alert is on, that alert will be disabled and any followers or recipients will no longer receive notifications when the alert conditions are met.
Admins will see immediately that the name of the dashboard has been replaced with a - for the alert on the Alert History page. After the next time the alert query runs, the alert will be removed.
Alert History Information
|Time||The time when the alert job executed.|
|Status||Whether the job is current running, complete, or failed.|
|Alert Name||The title of the alert. Clicking this link will direct you to the Alerts management admin page and filter the results to display only the alert you have clicked. To clear the filter and see all alerts on the Alerts management admin page, click the X icon in the banner.|
|Dashboard||The name of the dashboard containing the tile with the alert. Clicking this link will direct you to the dashboard.|
|Owner||The name of the person who created the alert. Clicking this link will direct you to the Edit User page for that user.|
|Condition Met||A Yes or No that indicates whether the alert conditions were met when the alert query was last run. A — symbol is displayed if the alert query has not yet run or if the alert query ran but it could not be determined whether the alert conditions were met. This column displays red error or yellow warning icons related to any errors or warnings surfaced when running the alert query or delivering the alert notification. See the Message column or hover over the error or warning icon to see the associated error message, if applicable.
A yellow icon indicates that the data on the dashboard tile did not change between the two most recent alert queries. Read more about this message in the Alert Error and Warning Messages section below.
|Message||This column displays messages explaining any errors or warnings surfaced when running the alert query or delivering the alert notification. Read more about these messages in the Alert Error and Warning Messages section below.|
|Runtime||How long the job ran or has been running.|
Alert Error and Warning Messages
The Alert History admin page displays any errors or warnings surfaced when running the alert query or delivering the alert notification. Error messages, if applicable, appear in the Messages column or when you hover over the error or warning icon in the Condition Met column.
For alerts that are set up to deliver notifications to the Slack or Slack Attachment (API Token) integrations, the error message
Notification delivery failed with existing configuration appears when the alert query determines that the alert conditions have been met but the notification could not be delivered. This failure may occur if something about the Slack configuration has changed since the alert was created — for example, if the Slack workspace that the alert was delivering to was disconnected from the Looker instance, or if the Slack channel that the alert was delivering to was deleted, or if Looker cannot connect to the integrations.
Warning: Querying Fresh Data
New in Looker 7.20, the Condition Met column displays a warning if your alert is querying data that has not changed since the previous alert query was run.
A yellow warning icon in the Condition Met column indicates that the data on the dashboard tile upon which the alert is based did not change between the two most recent alert queries.
There are a few explanations for why the data did not change between queries. For example, if the alert creator specified that the tile’s data is checked at a frequency of every hour but the caching policy of the tile’s underlying model specifies that the database is checked for updates every six hours, then the alert query will be running on unchanged data. Aligning the alert query and data update frequencies should circumvent this warning.
See more about how Looker handles caching on the Caching Queries and Rebuilding PDTs with Datagroups documentation page. See more about how alert queries work with time series data in the Setting Alerts Based on Time Series Data Help Center article.
Managing Alerts from the Alert History Page
You can manage any alert listed in the Alert History table. Click on the Alert Name to be directed back to the Alerts management admin page.