> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Explore the Lineage View

> Explore lineage diagrams interactively to understand how data flows between sources, transformations, and dashboards.

# Explore the Lineage View

Collate shows you end-to-end lineage for tables, dashboards, and pipelines — all in one interactive graph. Search for any data asset, expand the graph, and trace upstream and downstream relationships. Each edge in the graph carries the SQL query, pipeline information, and column-level details.

## Understanding the Lineage Graph

The lineage graph has three core elements:

* **Source node**: The table on the left — where data originates.
* **Target node**: The table on the right — where data ends up. You can also spot it by the arrow pointing into it.
* **Edge**: The connection between source and target. Click any edge to see the source, target, description, and the SQL query used to generate the view.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/edge.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=438d981bdaf665cd80270b8a1970b9cd" alt="Edge Information: Source and Target" width="2730" height="1017" data-path="public/images/ai-2.0/data-lineage/edge.png" />

<Tip>
  **Tip**: Metadata ingestion also brings in view lineage automatically, if your database has views (data assets of type View).
</Tip>

## Configure the Lineage Display

Control how many upstream and downstream nodes appear in the graph.

Open **Lineage Config** to set the number of upstream nodes, downstream nodes, and nodes per layer. You can display up to **3** levels of upstream and downstream nodes.

<img src="https://mintcdn.com/collatedocs/NrIZfP8Avf1SnI7W/public/images/how-to-guides/lineage/nodes.png?fit=max&auto=format&n=NrIZfP8Avf1SnI7W&q=85&s=00664ac51edb64ff603870894ef3a82b" alt="Lineage Config" width="1058" height="870" data-path="public/images/how-to-guides/lineage/nodes.png" />

## Explore Data Asset Details

Click any node in the graph to see a quick preview of that asset.

The preview shows:

* **Name, description, owner, tier, and usage** for the asset
* **Type-specific details** — for tables, this includes the table type, query count, and column count
* **Data quality metrics** — tests passed, aborted, and failed
* **Tags** associated with the asset
* **Schema** — column names, types, and descriptions

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/lineage2.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=c1cc3bf91a0d81fd4be5e94d1f9e2765" alt="Quick Glance at the Data Asset from Lineage View" width="2806" height="950" data-path="public/images/ai-2.0/data-lineage/lineage2.png" />

## Explore Column-Level Lineage

Click a table node to expand it and see its columns. Collate traces how individual columns flow from source to target — so you can follow a specific field all the way through your pipeline.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/lineage1.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=c456580574abed4c16598aafcdd6b686" alt="Column-Level Data Lineage in Collate" width="5645" height="2039" data-path="public/images/ai-2.0/data-lineage/lineage1.png" />

## Pipeline Lineage

For pipelines, Collate first ingests lineage from your databases. When you configure pipeline ingestion, you specify the database service name — Collate then links the database tables to the pipeline, and the edge information shows which pipeline created the relationship.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/pipeline.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=9322a6f5c3843edd6b911133640a02c2" alt="Database and Pipeline Lineage" width="2709" height="954" data-path="public/images/ai-2.0/data-lineage/pipeline.png" />

## Dashboard Lineage

For dashboards, Collate ingests lineage from your databases first. When you run dashboard ingestion, Collate pulls in data models and charts and links them back to the source database tables.

## Lineage Layers

Switch between layers to explore different dimensions of your data's lineage.

### Column Layer

Trace individual fields — like `customer_id` or `first_name` — as they move across tables and pipelines. The column layer shows exactly how each attribute transforms along the way.

<img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-lineage/column-layer.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=75b7eed6e2975ed7ad054334454f1a6b" alt="Column Layer in Lineage" width="1825" height="558" data-path="public/images/ai-2.0/data-lineage/column-layer.png" />

### Observability Layer

See data quality results directly in the lineage graph — test passes, failures, and pending checks appear on each node. This helps you quickly spot which assets in the pipeline have quality issues.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/observability-layer.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=d202412c5946921ad454f1b9d6c5de1c" alt="Observability Layer in Lineage" width="1813" height="621" data-path="public/images/ai-2.0/data-lineage/observability-layer.png" />

### Service Layer

See how data moves across services — from Hive to Redshift to Power BI to Tableau. The service layer gives you a system-level view of the full data journey, from ingestion through transformation to consumption.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/service-layer.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=f2b34aa8e9c55f29d3692b28031afbeb" alt="Service Layer in Lineage" width="1821" height="625" data-path="public/images/ai-2.0/data-lineage/service-layer.png" />

### Domain Layer

Group assets by business domain — like "Ecommerce" or "Customer Data" — to understand lineage in business terms. This view connects your technical assets to the business functions they support.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-lineage/domain-layer.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=9a270c8f0b802d5ea7479e6921b0d619" alt="Domain Layer in Lineage" width="1822" height="625" data-path="public/images/ai-2.0/data-lineage/domain-layer.png" />

### Data Product Layer

See the lineage of your curated, consumption-ready data products — like *Customer Registry* or *Superstore*. The data product layer shows which trusted outputs belong to which domain and where they come from.

<img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-lineage/data-product-layer.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=eabb79488f10c98c9805a2f4b79f9dd3" alt="Data Product Layer in Lineage" width="1888" height="627" data-path="public/images/ai-2.0/data-lineage/data-product-layer.png" />

<Card title="How Column-Level Lineage Works" href="/ai-2-0/how-to-guides/data-lineage/column">
  Explore and edit the rich column-level lineage.
</Card>
