Skip to main content
DATA-WAREHOUSE-MANAGEMENT5 MIN READ

Work Through a Source-to-Mart Lineage

Trace a warehouse metric's lineage across source, staging, modeled contract, test, and consumer mart.

A customer count changed by 9 percent after a release, and the warehouse team needs to explain whether the source, model, quality rule, or mart changed. Trace source -> staging -> modeled contract -> quality guard -> consumer mart. The common trap is to show a DAG and call it lineage. A DAG tells you dependencies, but it may not tell a stakeholder what changed, who owns it, or which assumption was protected. 1. Start with the consumer metric Write the exact metric, dashboard, owner, and decision: executive active customers, used in Monday operating review. Lineage starts from the business…

Read the full lesson

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in

← Back to library
Contact us