Match each assumption to the dbt test style that best protects it. unique relationships Every order must have an order_id Each row in dim_customers has one customer_id Order status is only placed, shipped, completed, returned, or cancelled Every order customer_id exists in dim_customers Payment id should never be blank Subscription state is active, trialing, paused, or cancelled Each invoice appears once in the invoice fact Each line item points to a known order
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in