Pipeline Health

97.8% success

Warehouse SLO view — success rate, throughput, freshness, and failed jobs.

Rows today

Queue length

Freshness

Warehouse health

p95 processing

Failed jobs 24h

Success rate trend

Rolling windows

Throughput vs queue

Rows (M) and queue depth

Failed jobs

AI-annotated root cause · open in Data Engineer for Fuel ETL

3 records

	Status	Error	AI note
Fuel ETL — duplicate transaction IDs Fuel	Failed	UNIQUE constraint violated on txn_id for 142 rows (card+timestamp collision after vendor file re-send).	Root cause: Comdata re-pushed Jul 22 file with regenerated IDs overlapping live feed. Quarantine table fuel_txn_dupes populated. Deduplicate on (card_last4, ts, gallons, location) and mark surrogate keys.	13 hours ago
GPS late partition GPS	Failed	Samsara API 429 — rate limit on historical backfill	Backoff + resume from watermark 23:00Z	20 hours ago
IFTA mileage reconcile Compliance	Failed	State code 'XX' not in dim_geo	Map unknown state to reject queue; notify Tax	21 hours ago

Warehouse health

Certified refresh window

Star schema

Healthy

86 tables

Rows today 2,300,000

Certified metrics

Healthy

64 KPIs

Rows today 2,300,000

fact_fuel

Warning

Quality watch

Rows today 2,300,000