Place data-quality checks at the right source, staging, mart, or metric layer.
Sort each check into the layer that should own it first. Source layer Staging layer Mart layer Metric layer Stripe ingestion completed within the expected daily freshness window Every customer_id in stg_orders is non-null after type casting and cleanup Each row in fct_subscriptions is unique at the published subscription-month grain Gross margin stays within the agreed 0 to 1 ratio range after metric calculation Accepted raw event_type values from the vendor API still match the ingestion contract Normalized status values in stg_accounts are limited to the standardized enum set Revenue mart rows still match one published row per order line…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in