# Natural Key

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

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Business Key, Domain Key

## Think of it like

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

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

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

## Common mistake

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

## Three principles

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

## Related terms

- [Surrogate Key](https://learn.benibix.com/term/data/surrogate-key)
- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Slowly Changing Dimension (SCD)](https://learn.benibix.com/term/data/slowly-changing-dimension)
- [Data Deduplication](https://learn.benibix.com/term/data/data-deduplication)
- [Master Data Management (MDM)](https://learn.benibix.com/term/data/master-data-management)
- [Primary Key](https://learn.benibix.com/term/development/primary-key)

## Told apart from

- [Natural Key vs Surrogate Key](https://learn.benibix.com/compare/natural-key-vs-surrogate-key): People think a natural key and a surrogate key are two names for one ID, and they are not. A natural key comes from the source, like an email or a product code. People can read it. A surrogate key is a plain number the warehouse makes up. Warehouses join on the surrogate key. They keep the natural key to trace each row back.

![Two fact tables, sales and returns, each with a customer key and an amount, point to one highlighted customer table in the middle. Inside it, customer_key 1042 is marked as the surrogate key made by the warehouse, and email emma@example.com as the natural key from the source. An arrow leads to one report showing sales and returns per customer side by side.](https://learn.benibix.com/diagrams/dat3-conformed-dimension.svg)

---

Source: https://learn.benibix.com/term/data/natural-key
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.
