# Staging Table

> A table where new data waits. It is checked before it moves on.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Landing Table, Stage Table

## Think of it like

It is like a mudroom by the front door. Muddy boots wait there before they come into the house.

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)
- [Extract, Load, Transform (ELT)](https://learn.benibix.com/term/data/elt)
- [Data Quality](https://learn.benibix.com/term/data/data-quality)
- [Incremental Load](https://learn.benibix.com/term/data/incremental-load)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Medallion Architecture](https://learn.benibix.com/term/data/medallion-architecture)

![A source file of tonight's orders is loaded into a highlighted table called stg_orders, which holds raw rows as they came, is emptied before each load, and is read by no report. Rows then pass through checks for blanks, repeats and types, and only rows that pass move into the real orders table. A note says bad rows stop in staging and every report stays as it was.](https://learn.benibix.com/diagrams/dat-staging.svg)

---

Source: https://learn.benibix.com/term/data/staging-table
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
