Sort Tests By Assumption

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

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

Already have an account? Sign in