Alerting on numeric data
Grafana managed alerts query the following backend data sources that have alerting enabled:
- community developed backend data sources with alerting enabled ( and
alerting
properties are set in the )
The alerting engine publishes some internal metrics about itself. You can read more about how Grafana publishes . See also, View alert rules and their current state.
Alerting on numeric data
This feature is supported with backend data sources that query tabular data:
- SQL data sources such as MySQL, Postgres, MSSQL, and Oracle.
- The Azure Kusto based services: Azure Monitor (Logs), Azure Monitor (Azure Resource Graph), and Azure Data Explorer.
A query with Grafana managed alerts or SSE is considered numeric with these data sources, if:
- The table response returned to Grafana from the query includes only one numeric (e.g. int, double, float) column, and optionally additional string columns.
For a MySQL table called “DiskSpace”:
You can query the data filtering on time, but without returning the time series to Grafana. For example, an alert that would trigger per Host, Disk when there is less than 5% free space:
When this query is used as the condition in an alert rule, then the non-zero will be alerting. As a result, three alert instances are produced: