Skip to content
BENIBIX Learn

Natural Key

Data🗄️ Storage & WarehousingDimensional Modeling

Also known as Business Key, Domain Key

An ID that comes from the real world or the source, like an email address.

Think of it like

It is like your name on a school list. It comes from you, not from the school.

Example

A shop's product table uses codes like TSH-RED-M as the natural key. The warehouse adds a plain number as the surrogate key and keeps the code too.

Why it matters

It is how rows from the source are matched to rows in the warehouse. Lose it, and you cannot trace a row back.

Definition

A natural key is a value that already names a thing in the real world or in the source system. An email address, a product code or a tax number can be one. It has meaning, so people can read it. But it can change, be reused, or clash when two sources are merged. That is why warehouses often add a surrogate key and keep the natural key beside it.
The email in the customer table is a natural key. The number is the surrogate key.

Common mistake

Joining big tables on a natural key that can change, like an email. When it changes, the history splits in two.

Key takeaways

  1. 1
    From the source. Not made up by the warehouse.
  2. 2
    Has meaning. People can read it.
  3. 3
    Can change. So keep a surrogate beside it.

Compare