The schema.yml file in this directory specifies that the materializations of the two models we are building are incremental.
We employ different strategies for these models:
- For the
all_orders model, we utilize the delete+insert strategy. This strategy is implemented because there may be changes in the status of an order that are included in the data updates. - For the
all_order_productsmodel, we employ the default append strategy. This approach is chosen because the same combination oforder_idandproduct_idmay appear multiple times in the sources. This indicates that a new quantity of the same product has been added or removed from a specific order.