🗄️Staging Table
Also known as Landing Table, Stage Table
A table where new data waits. It is checked before it moves on.
Think of it like
It is like a mudroom by the front door. Muddy boots wait there before they come into the house.
Example
Each night 40,000 orders load into stg_orders. A check finds 12 rows with no customer, so those 12 stay behind and the rest move on.
Why it matters
Bad data stops before it reaches a report. If a load fails, the real tables are untouched.
Definition
Common mistake
Key takeaways
- 1Land it raw. Load the data as it came.
- 2Check it. Look for blanks, repeats and bad types.
- 3Move what passes. Only good rows reach the real table.