# Data Lineage

> A map of where data came from and where it goes next.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Data Provenance, Column-Level Lineage, Lineage Graph

## Think of it like

It is like a family tree for a number. It shows where the number came from, all the way back.

## Definition

Data lineage is the map of where data comes from and where it goes. It shows which source tables feed a table, and which reports read from it. Column-level lineage goes further and traces each field. Tools build it by reading SQL, pipeline code and query logs. You use it to find the cause of a bad number. You also use it to see what will break before you change something.

## Example

A revenue number on a dashboard looks wrong. Lineage traces it back through three tables to one source with a broken currency field.

## Why it matters

It turns a day of detective work into a few clicks. It also shows who to warn before a change.

## Common mistake

Drawing lineage by hand in a slide. It is out of date the next week. Build it from the code and logs.

## Three principles

- **Upstream.** Trace a number back to its source.
- **Downstream.** See what a change will break.
- **Built automatically.** From SQL, code and query logs.

## Related terms

- [Data Catalog](https://learn.benibix.com/term/data/data-catalog)
- [Metadata](https://learn.benibix.com/term/data/metadata)
- [Data Observability](https://learn.benibix.com/term/data/data-observability)
- [Software-Defined Asset](https://learn.benibix.com/term/data/software-defined-asset)
- [dbt (Data Build Tool)](https://learn.benibix.com/term/data/dbt)

## Told apart from

- [Data Catalog vs Data Lineage](https://learn.benibix.com/compare/data-catalog-vs-data-lineage): People think a data catalog and data lineage are the same tool. A catalog is a search box with a page for each table. It says what the table is and who owns it. Lineage is the map of how data flows from table to table. Most catalogs show lineage on each page. But one says what a table is, and the other says where it came from.

![A left-to-right graph: two sources, the shop database and the payments API, feed raw tables, which feed a cleaned orders table, which feeds a revenue table, which feeds a dashboard and a forecast model. One path is highlighted from the payments API to the dashboard.](https://learn.benibix.com/diagrams/data-lineage.svg)

---

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