Challenge: dbt 1
Three situations from a real project. Each one draws on more than one lesson of this part.
The Analytics Engineer’s Field Guidedbt 1: build the modelsChallenge: dbt 1
Three situations from a real project. Each one draws on more than one lesson of this part.
fct_orders is incremental with incremental_strategy='delete+insert' and unique_key='order_date'. Each run selects orders updated in the last two days. Today the till corrects one order placed ten days ago. What happens to that old date in fct_orders?
fct_order_lines is incremental, merging on order_line_id, with the default on_schema_change. Alice adds discount_eur to its SELECT and her change is merged. What does the next nightly run do?
dim_menu_item sits on a snapshot, one row per version. fct_order_lines joins it ON item_id only. After the margherita's June price change, May's margherita revenue has doubled. What's the fix?
Finish this set to count it as done.