# Foundational ranks 5 of 16 for data lineage, at 58.0 of 100

TOOL PROFILE, read 10 Nov 2026

**The short answer.** Foundational ranks 5 of 16 on the Upstream data lineage ranking at 58.0 of 100, read 10 Nov 2026. Its best criterion is Coverage of the stack at 7 of 10, and its weakest is Lineage that carries meaning at 4. The matrix records 4 of five depths as documented.

- **Category:** Code-level lineage
- **Status:** Exists under this name on 10 Nov 2026.
- **Depth, table to metric:** Table: documented; Column: documented; Transformation logic: documented; BI field: documented; Metric: none found
- **Systems named:** Snowflake, BigQuery, Databricks, Redshift, dbt, Spark, Airflow, Kafka, Power BI, Tableau, Looker, Sigma, GitHub, GitLab
- **Rank and total:** 5 of 16, 58.0 of 100

4 of 5 depths documented, 0 partial

## Foundational on the seven criteria

| Criterion | Weight | Score | Why |
| --- | --- | --- | --- |
| Depth of lineage | 25 | 6 | Code-parsed column lineage incl. PySpark and BI DAX/LookML; no metric lineage found. |
| Lineage that carries meaning | 20 | 4 | Docs, owners and tags shown; no downstream propagation found. |
| Served to agents | 20 | 6 | Remote MCP tied to user account, many client guides, public API. |
| Coverage of the stack | 15 | 7 | Named source control, languages, ETL, warehouses and BI. |
| Stays current without work | 10 | 7 | Pull-request webhooks and scheduled scans with versioned graph. |
| Safe to deploy | 5 | 7 | Metadata-first, SOC 2 Type II, token roles and auditing. |
| Price transparency | 5 | 4 | Pricing by tracked objects described; no dollars. |

Blind scores for Foundational, 0 to 10. A vendor claim scores at most 7 until a second source confirms it.

## Where Foundational is strongest

Foundational derives column lineage by analyzing source code (SQL via SQLGlot, Spark, ORMs, COBOL) across repositories, warehouses and BI.

## Where Foundational falls short

Pricing is by tracked objects with no published amounts, and downstream propagation of tags was not found.

## Foundational in each situation

| Situation | Rank | Total | Leader |
| --- | --- | --- | --- |
| [Untrusted dashboards](/best-for/untrusted-dashboards/) | 5 | 60.0 | Euno 68.0 |
| [dbt and a warehouse](/best-for/dbt-warehouse/) | 4 | 60.0 | Euno 66.5 |
| [Agents this year](/best-for/agents-this-year/) | 7 | 58.5 | Euno 68.5 |
| [A regulated field](/best-for/regulated-field/) | 3 | 59.0 | Euno 67.5 |
| [BI sprawl](/best-for/bi-sprawl/) | 2 | 62.0 | Euno 66.5 |

Each situation ranks the same scores under its own published weights.

## The evidence on Foundational, fact by fact

- **foundational-01** (Depth of lineage, Foundational's own claim): Foundational parses transformation code to determine how columns are created, modified and consumed, giving column-level lineage across platforms, including for assets never queried. [Source](https://docs.foundational.io/en/articles/14046538-explore-data-lineage.md), read 10 Nov 2026.
- **foundational-02** (Depth of lineage, Foundational's own claim): Foundational's SQL lineage engine builds an AST with the open-source SQLGlot parser and derives column lineage, ignoring ephemeral CTEs. [Source](https://docs.foundational.io/en/articles/9479381-sql-lineage.md), read 10 Nov 2026.
- **foundational-03** (Depth of lineage, Foundational's own claim): For dynamic code like PySpark, Foundational simulates execution in a sandbox to build precise column-level lineage. [Source](https://docs.foundational.io/en/articles/12802881-solution-architecture.md), read 10 Nov 2026.
- **foundational-04** (Depth of lineage, Foundational's own claim): Foundational analyzes source code directly rather than parsing query logs. [Source](https://docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md), read 10 Nov 2026.
- **foundational-05** (Depth of lineage, Foundational's own claim): Foundational supports Power BI including M-Query and DAX, Tableau including Prep Flow, and Looker including LookML. [Source](https://docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md), read 10 Nov 2026.
- **foundational-06** (Lineage that carries meaning, Foundational's own claim): Foundational shows existing documentation first and uses AI over lineage, usage and neighbouring assets to fill gaps; users can set owners, tags and certified or deprecated status. [Source](https://docs.foundational.io/en/articles/14044714-maintain-data-asset-documentation.md), read 10 Nov 2026.
- **foundational-07** (Lineage that carries meaning, none-found): None found on 2026-11-10: Foundational documentation of tags, classifications or glossary terms propagating automatically downstream along lineage (MCP examples query columns tagged pii and their downstream consumers). [Source](https://docs.foundational.io/en/articles/11194236-use-foundational-mcp-with-your-ai-tools.md), read 10 Nov 2026.
- **foundational-08** (Served to agents, Foundational's own claim): Foundational hosts a remote MCP server (Streamable HTTP) giving AI tools end-to-end lineage, usage, code definitions and ownership. [Source](https://docs.foundational.io/en/articles/11194236-use-foundational-mcp-with-your-ai-tools.md), read 10 Nov 2026.
- **foundational-09** (Served to agents, Foundational's own claim): Foundational MCP requires a user account in the app and uses an authentication flow in the browser, so access is tied to a user. [Source](https://docs.foundational.io/en/articles/11194236-use-foundational-mcp-with-your-ai-tools.md), read 10 Nov 2026.
- **foundational-10** (Served to agents, Foundational's own claim): Foundational documents MCP setup guides for Claude, ChatGPT/Codex, Cursor, VS Code, Devin, Copilot, Agentforce and Snowflake Cortex, and a Public lineage API with tokens (Admin, Read Only, Remote Extractor). [Source](https://docs.foundational.io/en/articles/9920307-create-api-tokens.md), read 10 Nov 2026.
- **foundational-11** (Coverage of the stack, Foundational's own claim): Foundational lists source control GitHub, GitLab, Azure DevOps and Bitbucket, languages including SQL, Python, Scala, Java, COBOL, and ETL tools such as Informatica, Fivetran, Airflow, Kafka. [Source](https://docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md), read 10 Nov 2026.
- **foundational-12** (Coverage of the stack, Foundational's own claim): Foundational lists warehouses and databases including Snowflake, BigQuery, Databricks, Redshift, Fabric, Oracle, PostgreSQL, MongoDB and SAP, and BI tools including Power BI, Tableau, Looker, Sigma and QuickSight. [Source](https://docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md), read 10 Nov 2026.
- **foundational-13** (Coverage of the stack, Foundational's own claim): Foundational exports lineage as OpenLineage to Amazon S3 and to Collibra, and integrates with Cyera. [Source](https://docs.foundational.io/llms.txt), read 10 Nov 2026.
- **foundational-14** (Stays current without work, Foundational's own claim): Foundational is triggered by pull-request webhooks and runs scheduled scans of BI tools and warehouses, keeping a versioned lineage graph. [Source](https://docs.foundational.io/en/articles/12802881-solution-architecture.md), read 10 Nov 2026.
- **foundational-15** (Stays current without work, Foundational's own claim): Foundational CI runs impact analysis on pull requests and can block merges. [Source](https://docs.foundational.io/en/articles/12802881-solution-architecture.md), read 10 Nov 2026.
- **foundational-16** (Safe to deploy, Foundational's own claim): Foundational is metadata-first and by default needs no customer data access; data access only for optional observability checks. [Source](https://docs.foundational.io/en/articles/12802881-solution-architecture.md), read 10 Nov 2026.
- **foundational-17** (Safe to deploy, Foundational's own claim): Foundational states SOC 2 Type II compliance and a public Trust Center. [Source](https://docs.foundational.io/en/articles/9515541-security-and-compliance.md), read 10 Nov 2026.
- **foundational-18** (Safe to deploy, Foundational's own claim): Foundational API tokens have roles and expiry settings and the API Tokens screen supports auditing token usage and ownership. [Source](https://docs.foundational.io/en/articles/9920307-create-api-tokens.md), read 10 Nov 2026.
- **foundational-19** (Price transparency, Foundational's own claim): Foundational prices by the number of tracked objects in the lineage graph, not seats; no dollar amounts published. [Source](https://www.foundational.io/pricing), read 10 Nov 2026.
- **foundational-20** (Profile, Foundational's own claim): Foundational describes itself as a unified knowledge graph of code and data movement across repositories, applications, databases, cloud and on-prem systems, and offers mainframe COBOL lineage. [Source](https://www.foundational.io/), read 10 Nov 2026.
- **foundational-21** (Profile, Foundational's own claim): Foundational announced a Cyera integration that traces security findings to the code that wrote them. [Source](https://www.foundational.io/), read 10 Nov 2026.
- **foundational-22** (Profile, none-found): None found on 2026-11-10: Foundational founding year or funding on the homepage, pricing page and docs index. [Source](https://www.foundational.io/), read 10 Nov 2026.
- **foundational-23** (Depth of lineage, none-found): None found on 2026-11-10: Foundational documentation of metric-level lineage (semantic-layer metrics) in the pages read; BI coverage lists Power BI DAX and LookML. [Source](https://docs.foundational.io/en/articles/14046538-explore-data-lineage.md), read 10 Nov 2026.

## Compare Foundational

- [Euno vs Foundational](/compare/euno-vs-foundational/)
- [DataHub vs Foundational](/compare/datahub-vs-foundational/)
- [Alternatives to Foundational](/alternatives/foundational/)

## Sources

- docs.foundational.io/en/articles/14046538-explore-data-lineage.md: https://docs.foundational.io/en/articles/14046538-explore-data-lineage.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/9479381-sql-lineage.md: https://docs.foundational.io/en/articles/9479381-sql-lineage.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/12802881-solution-architecture.md: https://docs.foundational.io/en/articles/12802881-solution-architecture.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md: https://docs.foundational.io/en/articles/15082464-supported-languages-and-platforms.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/14044714-maintain-data-asset-documentation.md: https://docs.foundational.io/en/articles/14044714-maintain-data-asset-documentation.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/11194236-use-foundational-mcp-with-your-ai-tools.md: https://docs.foundational.io/en/articles/11194236-use-foundational-mcp-with-your-ai-tools.md (read 10 Nov 2026)
- docs.foundational.io/en/articles/9920307-create-api-tokens.md: https://docs.foundational.io/en/articles/9920307-create-api-tokens.md (read 10 Nov 2026)
- docs.foundational.io/llms.txt: https://docs.foundational.io/llms.txt (read 10 Nov 2026)
- docs.foundational.io/en/articles/9515541-security-and-compliance.md: https://docs.foundational.io/en/articles/9515541-security-and-compliance.md (read 10 Nov 2026)
- www.foundational.io/pricing: https://www.foundational.io/pricing (read 10 Nov 2026)
- www.foundational.io: https://www.foundational.io/ (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalineagecompare.com/tools/foundational/
