AI-driven operations
at scale

1-- Detect temperature anomalies in the last hour
2-- by comparing against the rolling 24h average
3LET $avg = (SELECT VALUE math::mean(value)
4    FROM reading
5    WHERE sensor = sensor:turbine_01
6    AND timestamp > time::now() - 24h)[0];
7
8SELECT timestamp, value
9FROM reading
10WHERE sensor = sensor:turbine_01
11    AND timestamp > time::now() - 1h
12    AND value > $avg * 1.3;