Warehouse Lineage Layer

Once a reporting estate passes a few dozen models, nobody can answer two basic questions with confidence: where did this number come from, and is it current? Dashboards get quietly distrusted, and teams rebuild the same metric in three places.

• A parser that derives column-level lineage from warehouse query history and model definitions, without requiring analysts to hand-maintain a catalogue.
• Freshness and volume monitors per model with expected-window alerting, so a silently stalled load surfaces before the morning review.
• An impact view that answers, for any source column, which downstream models and dashboards break if it changes.
• A metric registry giving each executive figure one owning definition, with drift detection when a second definition appears.

On an estate of 140 models and 900 columns, lineage extraction achieved full coverage of parsed models and cut the time to answer a where-did-this-number-come-from question from open-ended investigation to under a minute.