# Fact Table

> The table of events you count, such as sales. It holds numbers and keys.

**Field:** Data Engineering  
**Category:** Storage & Warehousing

## Think of it like

It is like a pile of till receipts. Each one is a sale, with an amount and a few codes.

## Definition

A fact table holds the events a business measures. Each row is one event, such as one sale or one click. It stores numbers, such as amount and quantity. It also stores keys that point to dimension tables, such as the date and the product. Fact tables are long and thin, and often the biggest tables in a warehouse.

## Example

Each row of fact_sales has a date key, a shop key, a product key, a quantity and an amount. It grows by a million rows a day.

## Why it matters

Most business numbers are sums over a fact table. How it is built sets what you can ask.

## Common mistake

Not stating the grain. If no one knows whether one row is a sale or a sale line, totals come out wrong.

## Three principles

- **One row, one event.** Each row is something that happened.
- **Numbers to add.** Amounts and counts live here.
- **Keys to describe.** Keys point to dimension tables.

## Related terms

- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Dimensional Modeling](https://learn.benibix.com/term/data/dimensional-modeling)
- [Foreign Key](https://learn.benibix.com/term/development/foreign-key)
- [Grain](https://learn.benibix.com/term/data/grain)

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