Skip to content
BENIBIX Learn

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

A staging table is a short-term table where new data lands before it moves into the real tables. The data is loaded just as it came, with no changes. Checks then look for blanks, repeats and wrong types. Only rows that pass are moved on. The staging table is usually emptied before the next load.
New rows wait in staging. Only the rows that pass the checks reach the real table.

Common mistake

Letting reports read from staging. Its rows have not been checked, and they vanish at the next load.

Key takeaways

  1. 1
    Land it raw. Load the data as it came.
  2. 2
    Check it. Look for blanks, repeats and bad types.
  3. 3
    Move what passes. Only good rows reach the real table.