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…
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in