Data engineering·Cost, layout and query performance
you drop the table and rebuild it entirely from source, which is expensive, slow and definitely correct.
Full refresh
Also calledfull rebuild, rebuild from scratch
Rebuilding a model completely rather than incrementally. It is the answer to a logic change, a late-arriving correction, or an incremental model that has drifted, and it is the baseline every incremental build is an optimisation of. Keeping it working — rather than letting it rot until it no longer runs at all — is what preserves the ability to recover, and it is usually discovered to be broken at the worst possible moment.