Telemetry
SQL recipe collection

Structured events SQL recipes

Use nested fields, time buckets, window functions, heartbeat checks, safe dimensions, and other reusable structured-event SQL patterns.

Beginnerservice_heartbeats

Detect Missing Service Heartbeats

Find services, workers, or scheduled tasks that stopped reporting before a failure event appeared.

See SQL and result
Intermediateagent_events

Query Nested AI Tool-Call Events

Filter dotted nested fields and rank failing tools without flattening the original event payload.

See SQL and result
Advancedapi_requests

Detect Error-Rate Spikes With a Rolling Baseline

Compare each hourly API error rate with a rolling seven-bucket average instead of relying on one permanent threshold.

See SQL and result

Adapt the event contract before the threshold

Keep the analysis pattern, but validate table names, field types, business definitions, time windows, and minimum-volume rules against your own events.

SQL reference