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

# Lineage

> Datafold offers a column-level and tabular lineage view.

## Column-level lineage

Datafold's column-level lineage helps users trace and document the history, transformations, dependencies, and both downstream and upstream processes of a specific data column within an organization's data assets. This feature allows you to pinpoint the origins of data validation issues and comprehensively identify downstream data processes and applications.

To view column-level lineage, set **Lineage detail** to **Columns**.

![](https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/data_app_lineage_graph_columns-97a1aa84140dc7bd0b242eb70d6e5d81.png?fit=max\&auto=format\&n=hQ4DukKOuaj6vjhH\&q=85\&s=a02dc2c18664786f79cf7bd4524e704e)

Lineage Graph Columns Dropdown

### Highlight path between assets

To highlight the column path between assets, click the specific column. Reset the view by clicking the **Exit selected path** button.

![](https://mintcdn.com/datafold/Q7OqZ4fuuETHBSvX/images/data_app_lineage_selected_path-ae2fb8bab8b62f9479a6e148a399bc5a.png?fit=max\&auto=format\&n=Q7OqZ4fuuETHBSvX\&q=85\&s=0e261d393437069ff59ed1dd705569d8)

Selected Path in Lineage Graph

## Tabular lineage

Datafold also offers a tabular lineage view.

You can sort lineage information by depth, asset type, identifier, and owner. Click on the **Actions** button for further options:

![](https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/tabular_lineage_actions_dropdown-b583e8f59c747058d8a5c95ed6d12843.png?fit=max\&auto=format\&n=4ZNRDufNo9R1p08Q\&q=85\&s=a2b72b5aafae515768c8f6bf8163ce66)

Tabular Lineage Actions Dropdown

### Focus lineage

Drill down onto the data node or column of interest.

### Show definition

Access the SQL definition associated with the selected column to understand how the data was queried from the source:

![](https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/tabular_lineage_actions_show_sql_code-da905cea8201954e3b0eb17f3fe108de.png?fit=max\&auto=format\&n=4ZNRDufNo9R1p08Q\&q=85\&s=285cc3de38895e398d74761a28927821)

Show SQL Query in Tabular Lineage

### Show usage details

Access detailed information about the column's read, write, and cumulative read (the sum of read count including read count of downstream columns) for the previous 7 days:

![](https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/tabular_lineage_actions_usage_details-c0462ebd7bee2bc769169ff2b7640d56.png?fit=max\&auto=format\&n=4ZNRDufNo9R1p08Q\&q=85\&s=962e7831072bdca9461ea7af185013ba)

Usage Details in Tabular Lineage

## Search and filters

Datafold offers powerful search and filtering capabilities to help users quickly locate specific data assets and isolate data connections of interest.

In both the graphical and tabular lineage views, you can filter by tables or columns within tables, allowing you to go as granular as needed.

![](https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/tabular_lineage_actions_search-f5cef28a24e5a1603e5c04d9696a4ff8.png?fit=max\&auto=format\&n=4ZNRDufNo9R1p08Q\&q=85\&s=e43f245bfe7f2a29932374343f0dd517)

Search and Filter in Tabular Lineage

### Table filtering

Simply enter the table's name in the search bar to filter and display all relevant information associated with that table.

### Column filtering

To focus specifically on columns, you can search using a combination of keywords. For instance, searching "column table" will display columns associated with a table, while a query like "column dim customer" narrows the search to columns within the "dim customer" table.

## Settings

You can configure the settings for Lineage under Settings > Data Connections > \[connection] > Advanced settings:

![](https://mintcdn.com/datafold/BHI8Zy_v4DyXlmzL/images/lineage_advanced_settings-8787d8f5b01d1a6572b2d73f486ad49a.png?fit=max\&auto=format\&n=BHI8Zy_v4DyXlmzL\&q=85\&s=685c29c694dcf151d533fb4d6922293f)

Lineage Advanced Settings

### Schema Sync Schedule (UTC)

Customize the frequency and timing of when to update the indexes on database schemas. The schedule is defined through a cron tab expression.

### Table inclusion/exclusion

You can filter to include and/or exclude specific tables to be shown in Lineage.

When the inclusion list is set, only the tables specified in this list will be visible in the lineage and search results.

When the inclusion list is not set, all tables will be visible by default, except for those explicitly specified in the exclusion list.

### Lineage Sync Schedule (UTC)

Customize the frequency and timing of when to scan the query history of your data warehouse to build and update the data lineage. The schedule is defined through a cron tab expression.

## FAQ

> **How is lineage computed?**
>
> Datafold computes column-level lineage by:
>
> 1. Ingesting, parsing and analyzing SQL logs from your databases and data warehouses. This allows Datafold to infer dependencies between SQL statements, including those that create, modify, and read data.
> 2. Augmenting the metadata graph with data from various sources. This includes metadata from orchestration tools (e.g., dbt), BI tools, and user-provided documentation.

> **Is there a programmatic way to retrieve lineage?**
>
> Yes. Lineage can be queried programmatically through the [Datafold MCP server](https://docs.datafold.com/classic/datafold-mcp.md) or the lineage (Explore) endpoints of the [Datafold API](https://docs.datafold.com/classic/api-reference/introduction.md). The GraphQL API used by the app itself is not a stable public API.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.