Zum Hauptinhalt springen

Sort Tests By Assumption

Match common dbt tests to the assumptions they protect.

dbt-basics5 min read

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.

← Back to library

Kontakt aufnehmen