Challenge: dbt 2
Three situations from a shared project, where macros, tests and contracts meet.
The Analytics Engineer’s Field Guidedbt 2: make it trustworthyChallenge: dbt 2
Three situations from a shared project, where macros, tests and contracts meet.
Alice changes the net_eur macro and writes a unit test on stg_orders, giving rows for source('raw', 'orders') only. stg_orders also refs dim_vat_rates. What happens when the test runs?
fct_orders has an enforced contract and no versions. Alice renames country to country_code in the SQL and in the YAML, in one merge request. Two dashboards read country, and both are declared as exposures. What do you expect?
fct_orders has an enforced contract, with constraints not_null and unique on order_id. A bad load sends the same order twice. What happens on Snowflake?
Finish this set to count it as done.