Telemetry
SQL recipe collection

API reliability SQL recipes

Calculate request error rates, latency percentiles, release regressions, error budgets, and customer impact from structured API events.

Beginnerapi_requests

Calculate API Error Rate by Route

Use SQL to rank API routes by 5xx error rate while protecting the result from low-volume noise.

See SQL and result
Intermediateapi_requests

Calculate p50, p95, and p99 API Latency

Compare median and tail latency by endpoint with DataFusion-compatible percentile SQL.

See SQL and result
Intermediateapi_requests

Calculate API Error-Budget Burn Rate

Turn hourly request failures into an SLO burn-rate series that shows how quickly the allowed error budget is being consumed.

See SQL and result
Intermediateapi_requests

Compare API Reliability by Release

Compare traffic, 5xx rate, and p95 latency across application releases without attributing every post-deploy change to the deploy.

See SQL and result
Beginnerapi_requests

Rank Error Fingerprints by Customer Impact

Rank normalized application errors by occurrences and affected accounts instead of letting one retry loop dominate the incident view.

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