📥Full Load
Also known as Full Refresh, Full Extract, Full Reload, Truncate and Load
Copy the whole table again each time. Simple, but slow when the table is big.
Think of it like
It is like tipping out a toy box and putting each toy back. Nothing is missed, but it is slow.
Example
A shop reloads its list of 300 stores every night, and it takes seconds. Its 50 million orders are loaded a bit at a time instead.
Why it matters
It is the safe choice when deletes and edits are hard to track. Every run ends with an exact copy.
Definition
Example code
sql
TRUNCATE TABLE stores;
INSERT INTO stores
SELECT * FROM source_stores;Common mistake
Key takeaways
- 1Every row. Nothing depends on what changed.
- 2Simple. No dates or markers to track.
- 3Costly at size. Run time grows with the table.