Use Case
Define Alert Rules in SQL. Detect Incidents in Milliseconds.
Replace fragile monitoring scripts with streaming SQL queries that continuously evaluate every event, log, and metric — and trigger alerts the moment conditions are met.
Trusted by 1,000+ Data-Driven Organizations
for Real-time Analytics
The Problem
Are You Discovering Incidents From Customer Complaints?
Traditional monitoring polls metrics every 30-60 seconds and runs threshold checks in batch. Between checks, critical events go unnoticed — your customers discover outages before your team does.
With RisingWave
Evaluate Every Event Against Every Rule, Continuously
RisingWave lets you write alert rules as SQL queries that run continuously. No polling intervals, no missed events. When CPU > 95% AND error_rate > 5% for 3 consecutive minutes, you know within seconds — not after the next batch run.
An ISO (Independent System Operator) manages a 45GW regional grid. Grid frequency must stay within 59.95–60.05 Hz — deviations beyond this range trigger automatic load shedding. With 12GW of intermittent solar and wind, frequency stability is a second-by-second challenge.
| pmu_id | substation | frequency_hz | voltage_kv | phase_angle | rocof | ts |
|---|---|---|---|---|---|---|
| PMU-4401 | Riverside 345kV | 59.93 | 344.2 | -2.14 | -0.08 | 2024-07-18T15:42:00.016Z |
| PMU-4401 | Riverside 345kV | 59.91 | 343.8 | -2.31 | -0.12 | 2024-07-18T15:42:00.033Z |
| PMU-2208 | Mesa Verde 230kV | 59.96 | 229.7 | -1.08 | -0.04 | 2024-07-18T15:42:00.016Z |
| PMU-2208 | Mesa Verde 230kV | 59.94 | 229.5 | -1.22 | -0.06 | 2024-07-18T15:42:00.033Z |
| PMU-6615 | Clearwater 500kV | 60.01 | 499.8 | 0.42 | 0.01 | 2024-07-18T15:42:00.016Z |
| PMU-3309 | Ironwood 138kV | 59.97 | 137.9 | -0.73 | -0.03 | 2024-07-18T15:42:00.016Z |
CREATE MATERIALIZED VIEW frequency_excursions AS
SELECT
pmu_id,
substation,
frequency_hz,
voltage_kv,
rocof,
ts,
CASE
WHEN frequency_hz < 59.90 OR frequency_hz > 60.10 THEN 'CRITICAL'
WHEN frequency_hz < 59.95 OR frequency_hz > 60.05 THEN 'WARNING'
END AS severity,
CASE
WHEN rocof < -0.10 THEN 'ACCELERATING'
WHEN rocof < -0.05 THEN 'DEVELOPING'
ELSE 'STABLE'
END AS trend
FROM pmu_readings
WHERE (frequency_hz < 59.95 OR frequency_hz > 60.05)
AND ABS(rocof) > 0.05;| substation | frequency_hz | rocof | severity | recommended_action | detected_at |
|---|---|---|---|---|---|
| Riverside 345kV | 59.91 | -0.12 | CRITICAL | Solar output drop at Mojave Flats Solar (84/300 MW) | 2024-07-18T15:42:00.033Z |
| Mesa Verde 230kV | 59.94 | -0.06 | WARNING | Solar output drop at Mojave Flats Solar (84/300 MW) | 2024-07-18T15:42:00.033Z |
| Sun Valley Solar 230kV | 59.95 | -0.05 | WARNING | Load surge in Zone 4 South (3820 MW vs 3290 MW forecast) | 2024-07-18T15:42:00.016Z |
Move From Reactive to Proactive Monitoring
Use streaming SQL to continuously evaluate every event, detect incidents in milliseconds, and alert your team before users are impacted.
