# Data Dictionary

> A list of each column in a table and what it means.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Column Dictionary, Field Dictionary

## Think of it like

It is like the key on a map. It tells you what each little sign means.

## Definition

A data dictionary lists every column in a set of tables, so people know what each one holds. For each one, it gives the name, the type and what it means. It also lists the values that are allowed, the units and whether a blank is fine. Analysts read it before they use a table they do not know. A business glossary defines words. A data dictionary defines columns.

## Example

The dictionary says amount is in cents, not euros. Emma reads it and divides by 100 before building her chart.

## Why it matters

One misread unit or code can make a report off by 100 times. The dictionary prevents that.

## Common mistake

Writing it once in a spreadsheet and never again. Keep it next to the code, so it changes when the table does.

## Three principles

- **Every column.** Name, type and meaning.
- **Rules and units.** Allowed values and units.
- **Kept current.** Updated when the table changes.

## Related terms

- [Business Glossary](https://learn.benibix.com/term/data/business-glossary)
- [Metadata](https://learn.benibix.com/term/data/metadata)
- [Data Catalog](https://learn.benibix.com/term/data/data-catalog)
- [Database Schema](https://learn.benibix.com/term/development/schema)

## Told apart from

- [Business Glossary vs Data Dictionary](https://learn.benibix.com/compare/business-glossary-vs-data-dictionary): People think a business glossary and a data dictionary are the same list. A glossary explains business words, like active customer, in plain words. A data dictionary lists the columns in a table. It gives each one a type and a unit. One says what a word means. The other says where it is kept.

![A catalog page for the orders table. A search box at the top finds it. The card shows a description, an owner, a PII tag, the columns with types, a link to the glossary term Net Revenue, and a small lineage trail from the shop database to a dashboard.](https://learn.benibix.com/diagrams/data-catalog.svg)

---

Source: https://learn.benibix.com/term/data/data-dictionary
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-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
