# One Big Table (OBT)

> One wide table with all the details on each row. Queries need no joins.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Wide Table, Flat Wide Table

## Think of it like

It is like a lunchbox with the whole meal packed in. You do not visit five shops to eat.

## Definition

One big table is a warehouse design where the facts and all their details sit in one wide table. The joins to customer, product and date tables are done once, when the table is built. Queries then read one table with no joins. Names and labels repeat on every row, so it takes more space. Columnar storage keeps that cost low.

## Example

A sales table carries the store, customer and product names on each row. Anyone can sum sales by store with one short query.

## Why it matters

Queries are simple and fast, and many BI tools work best on a single table. Columnar storage makes the repeated values cheap.

## Common mistake

Forgetting to rebuild it when a detail changes. If a product is renamed, the old name stays on every row until the next build.

## Three principles

- **Join once.** Joins happen when the table is built.
- **Repeat details.** Every row carries its names and labels.
- **Rebuild to update.** Changes show after the next build.

## Related terms

- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Denormalization](https://learn.benibix.com/term/data/denormalization)
- [Columnar Storage](https://learn.benibix.com/term/data/columnar-storage)
- [Fact Table](https://learn.benibix.com/term/data/fact-table)
- [Grain](https://learn.benibix.com/term/data/grain)
- [Dimensional Modeling](https://learn.benibix.com/term/data/dimensional-modeling)

## Told apart from

- [One Big Table vs Star Schema](https://learn.benibix.com/compare/one-big-table-vs-star-schema): People think one big table is just a messy star schema. Both hold the same facts and details. A star schema keeps each detail table apart and joins them when you ask. One big table does the joins once, ahead of time, and keeps the result. The star is easier to change. The big table is easier to query.

![Left: a star schema with a sales table in the middle and customer, product, store and date tables around it, so each query joins up to five tables. An arrow marked join once leads to the highlighted one big table on the right, with date, store, customer, product and amount on every row. Names repeat on every row, and no joins are needed.](https://learn.benibix.com/diagrams/dat-one-big-table.svg)

---

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