# Slowly Changing Dimension (SCD)

> A dimension whose details change over time. Type 2 keeps a row per version.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** SCD, SCD Type 2, Type 2 Dimension

## Think of it like

It is like a height chart on a door. You add a new mark each year and keep the old ones.

## Definition

A slowly changing dimension is a dimension whose details change now and then. A customer moves city, or a product gets a new price band. Type 1 just overwrites the old value, so history is lost. Type 2 adds a new row with start and end dates, so old facts keep their old details. Type 2 is the most common choice.

## Example

Lucy moves from Leeds to London in May. With Type 2, her March orders still count for Leeds, and her June orders count for London.

## Why it matters

Without it, old reports change when someone moves. Last year's sales by city would quietly shift.

## Common mistake

Writing over each change by default. You find out the past was lost when someone asks about last year.

## Three principles

- **Type 1.** Overwrite and lose the old value.
- **Type 2.** Add a new row with dates.
- **Keeps history.** Old facts keep old details.

## Related terms

- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Surrogate Key](https://learn.benibix.com/term/data/surrogate-key)
- [Fact Table](https://learn.benibix.com/term/data/fact-table)
- [Time Travel Query](https://learn.benibix.com/term/data/time-travel)
- [dbt Snapshot](https://learn.benibix.com/term/data/dbt-snapshot)

---

Source: https://learn.benibix.com/term/data/slowly-changing-dimension
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.
