Pick KPI tables first
Start with marts leadership opens every Monday — not every staging model.
Learn · Reliability
How to know a table went quiet before a dashboard lies.
The problem
Dashboards still render when the source table stops updating. The failure is quiet — until a meeting goes sideways.
The outcome
Set per-table freshness SLAs on BigQuery last-modified metadata, alert once when lag crosses the line, and show blast radius to downstream KPIs.
SLA hours
You define per table
Metadata
INFORMATION_SCHEMA
1 alert
Per root cause
Start with marts leadership opens every Monday — not every staging model.
e.g. warn at 12h, critical at 24h — numbers you can put in a runbook.
One stale source should not page for every child dashboard.
Replay a 3-day-stale orders table in /app.
Open workspace, or book a Data Stack Health Audit credited toward Managed.