Data engineering·Cost, layout and query performance
the model rebuilds only the last three days each run instead of the whole four-year table, and once a month you rebuild it fully anyway.
Incremental model
Also calledincremental materialisation, incremental build
A transformation that processes and appends or merges only new or changed data rather than rebuilding from scratch. It is how a large table stays affordable to maintain, and it introduces the possibility of the incremental result diverging from what a full rebuild would produce. That is why a periodic full refresh is not redundancy but a correctness check, and why teams that never run one eventually cannot explain a discrepancy.