# Dimension Table

> A table that names the things in the facts, such as shops and dates.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Dimension, Dim Table

## Think of it like

It is like a phone book. It turns a code into a name, a place and other details.

## Definition

A dimension table describes the things in your facts. Each row is one thing, such as one product, one shop or one day. It holds words people filter and group by, such as product name, city or month. A fact row points to it with a key. Dimension tables are short and wide, and change much less often than facts.

## Example

dim_product has one row per product, with its name, brand, size and colour. A report groups sales by brand using it.

## Why it matters

Dimensions are what make numbers readable. Without them, a report shows codes instead of names.

## Common mistake

Putting numbers you add up in a dimension. Those belong in the fact table.

## Three principles

- **One row per thing.** A product, a shop, a day.
- **Words to filter by.** Names, places and groups.
- **Changes slowly.** Far fewer updates than facts.

## Related terms

- [Fact Table](https://learn.benibix.com/term/data/fact-table)
- [Slowly Changing Dimension (SCD)](https://learn.benibix.com/term/data/slowly-changing-dimension)
- [Surrogate Key](https://learn.benibix.com/term/data/surrogate-key)
- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Conformed Dimension](https://learn.benibix.com/term/data/conformed-dimension)
- [Natural Key](https://learn.benibix.com/term/data/natural-key)

## Told apart from

- [Fact Table vs Dimension Table](https://learn.benibix.com/compare/fact-table-vs-dimension-table): People mix up fact tables and dimension tables, and they hold different things. A fact table holds the numbers from events, one row per sale or click, and it grows fast. A dimension table holds the words you slice by, such as product or store. It is short and wide. Reports sum the facts and group by the dimensions.

![Left: a star schema, with a sales fact table in the middle and four dimension tables around it, each joined straight to the fact. Right: a snowflake schema, where the product dimension is split further into a category table.](https://learn.benibix.com/diagrams/star-vs-snowflake-schema.svg)

---

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