Royal Civic Teal admin experience
Operational control surface
Admin / Transform

Pipeline monitor

SJ

Data flow

Live — nodes light up as pipeline runs
Not runRunningFreshClick any node to inspect

Pipeline broken at the dbt transform stage

Raw ingestion is current to 7 Jun 2026, but dbt hasn't run since 1 Jul 2025. The 16 landed streams are sitting in raw_airbyte un-transformed — gold and the KPI API are ~11 months stale.

Open dbt Studio
Console
-- Pipeline monitor ready. Run an Airbyte sync or dbt build to see output.
Last Airbyte sync
7 Jun
manual-20260607 · ok
Last dbt run
1 Jul 2025
~11 months ago
Streams awaiting transform
16
landed, not staged
Downstream stale
39
models · 1 API · 1 dashboard

Run history

Airbyte syncs and dbt runs, newest first
JobTypeStartedDurationRowsResult
manual-20260607075706Airbyte sync7 Jun 2026 08:573m 12s10,648Succeeded
manual-20260606213814Airbyte sync6 Jun 2026 21:382m 58s9,945Succeeded
airbyte_job-1Airbyte sync5 Jun 2026 21:301m 04sIncomplete
dbt_run · scheduleddbt runsince 2 Jul 2025Not scheduled
dbt_run-20250701dbt run1 Jul 2025 02:007.1s17,765Succeeded

Model results · last dbt run

1 Jul 2025 — unchanged since
ModelStageRowsResult
stg_work_ordersstagingPass
stg_complaintsstagingPass
int_kpi_actualsanalytics17,765Pass
kpi_cascade_snapshotgold17,765Pass
fct_kpi_actualsgold17,765Pass
mart_executive_summarygold312Pass

All models passed on the last run — the problem is freshness, not correctness.

Downstream impact

serving stale data
Gold schema
39 models built 1 Jul 2025
Stale
KPI API
serving gold.kpi_cascade_snapshot
Stale
Executive dashboard
reads mart_executive_summary
Stale
Governance
2 open freshness issues raised
Flagged
A model is shown stale because its last successful run predates the latest source data — never marked fresh by assumption.

Pipeline Schedule

Loading…