Foundational Data Lineage: Review, Pricing & Features
Everything you need to evaluate Foundational for data lineage: what it is, my review, pricing, features, integrations and the best alternatives.
By Ari Bajo - data engineer turned writer.
Updated on November 19, 2026
- Product
- Foundational
- Category
- Enterprise data governance
- Pricing
- Quote from sales
- Deployment
- SaaS, hybrid
On this page
What is Foundational?
Foundational is a data control plane that builds a knowledge graph of code and data movement, with column-level lineage from source code, pull request impact analysis, and data contracts. It's used to see the downstream impact of code changes before they merge.
Foundational review
Foundational is the best data lineage tool for data and engineering teams that want to see the downstream impact of code changes in Git pull requests and govern data across repositories, databases, and BI.
Strengths
- Lineage comes from source code, so impact shows before the code runs.
- Posts downstream impact to pull requests.
- Data contracts are YAML files next to the code, turned into monitors.
Caveats
- Needs access to your Git repositories to parse code.
- Lineage covers the languages it parses: SQL, Spark, Python and Java.
Foundational pricing
Foundational pricing isn't in my data yet. Check the pricing page for current plans.
Foundational features
Foundational appears in my lists of the best data lineage and data contracts tools. It supports 33 of the 70 tracked data governance features.
Foundational data catalog
Automated Metadata Harvesting: Connectors scan warehouses, BI tools and ETL on a schedule, and code repositories on every change (docs).
Search & Discovery: Search with filters by keyword, asset type, platform, database, schema and certification status (docs).
Usage & Popularity Statistics: Tracks query frequency, access patterns and user activity per asset, with historical trends, to find unused tables and dashboards (docs).
Asset Certification: Owners can set a certification status on assets, such as certified or deprecated, and filter by it (docs).
AI-Powered Search: Foundational IQ answers questions in plain English, but semantic search in the catalog is not documented (docs).
Custom Fields & Templates: Manual lineage uploads accept custom attributes, but custom metadata fields in the catalog are not documented (docs).
Metadata Propagation: The Lineage API docs suggest propagating PII labels downstream as an automation you build; no built-in propagation is documented (docs).
Business Glossary: No business glossary is documented (docs).
Foundational data lineage
Compare: data lineage tools
Table-Level Lineage: Lineage graph of tables, files, jobs and dashboards across the stack (docs).
Column-Level Lineage: Column-level lineage from SQL, dbt, Spark and application code (Java, Scala, .NET, Python, COBOL), without running the code (docs).
End-to-End Lineage: From upstream operational databases and application code through warehouses to BI dashboards such as Tableau, Looker and Power BI (docs).
Impact Analysis: Every pull request is compared against the lineage graph to show downstream impact before merge, and can block the merge (docs).
Automated Lineage Extraction: Static analysis of SQL and application code (Python, Java, Scala, .NET, COBOL, ORMs), plus connectors for dbt, Airflow, warehouses and BI tools (docs).
OpenLineage Support: Ingests OpenLineage events and exports lineage as OpenLineage events to Amazon S3, which Collibra can read (docs).
Foundational data stewardship
Review & Approval Workflows: Workflows and Alerts assign reviewers automatically to changes that modify tables, inside the pull request flow (docs).
Metadata Automation: Workflows and Alerts automate notifications and reviewer assignment when specific changes or events occur (docs).
Critical Data Elements: No register of critical data elements is documented (docs).
Governance Campaigns: No bulk governance campaigns are documented (docs).
Governance Scorecards: No governance scorecards are documented (docs).
Foundational AI features
AI Chat Assistant: Foundational IQ answers questions about lineage, costs and sensitive data in plain English and can open pull requests with your approval (docs).
AI Documentation Generation: AI fills documentation gaps from lineage, usage, source code and neighboring assets, and updates it when the stack changes (docs).
Agentic Metadata Enrichment: Documentation is generated and updated automatically, but autonomous tagging or classification by agents is not documented (docs).
Foundational data compliance
Audit Trail: The Lineage API returns the graph as it existed at a past point in time, and Foundational IQ uses the change history of code and assets (docs).
Compliance Reporting: No compliance reports are documented (docs).
Regulatory Framework Mapping: No regulation templates; BCBS 239 is only discussed as a reason for mainframe lineage (docs).
Data Activity Monitoring: Query history is read for usage and costs, not monitored for access to sensitive data (docs).
ROPA: No GDPR Article 30 register is documented (docs).
Data Retention Policies: No retention rules are documented (docs).
Data Subject Rights: No data subject request workflow; Foundational does not access data (docs).
Foundational collaboration
Alert Notifications: Alerts to Slack, Microsoft Teams and email when changes affect downstream assets or contracts are violated (docs).
Discussions & Annotations: No comments or discussions on catalog assets are documented (docs).
Ticketing Integrations: No Jira or ServiceNow integration is documented (docs).
Foundational data marketplace
Subscription Management: Workflows notify chosen people when changes affect specific tables or dashboards (docs).
Self-Service Access Requests: No access requests (docs).
Data Products: No data products are documented (docs).
Data Mesh Support: Contracts live in each team's repository, but domains and data products are not modelled (docs).
Foundational data quality
Compare: data contracts tools
SQL Table Tests: Contract business rules check required fields, value ranges and key uniqueness (docs).
Anomaly Detection: Observability monitors catch freshness and volume problems, with anomaly rules and custom thresholds (docs).
Data Profiling: Table statistics such as null counts, zero counts and distinct values per column, with custom thresholds; lighter than dedicated profilers (docs).
Data Contracts: YAML contracts (.fd.yml) next to the code, with schema, business, anomaly and SLA rules, checked on pull requests and continuously (docs).
Data Health Scores: Not documented (docs).
Foundational AI governance
AI Lineage: Code analysis traces data from warehouses to external AI endpoints such as OpenAI and to downstream ML models (training-data lineage) (docs).
AI Asset Inventory: No catalog of AI models or agents is documented (docs).
AI Regulatory Compliance: Not documented (docs).
AI Model Health Score: Not documented (docs).
AI Agent Access Governance: The MCP server gives agents lineage context, but nothing is enforced at query time (docs).
Foundational workflows
REST / GraphQL API: REST Lineage API to query entities and the lineage graph, including as it existed at a past point in time (docs).
dbt Integration: Parses dbt and dbt Fusion projects for column-level lineage and checks dbt changes on pull requests (docs).
Webhooks: Teams notifications use an incoming webhook; general outbound webhooks are not documented (docs).
Python SDK: No SDK; a sample Python project calls the REST API (docs).
Foundational data context layer
MCP Server: MCP server for Claude, ChatGPT, Copilot, Cursor, Snowflake Cortex and others, with lineage, usage and code definitions (docs).
Knowledge Graph: One directed graph of code, tables, columns, jobs and dashboards with owners and tags, queried by the API, MCP and Foundational IQ (docs).
Semantic Layer Interop: LookML and dbt are parsed for lineage; importing metric definitions is not documented (docs).
Semantic Models: No semantic model generation is documented (docs).
Verified Queries: Not documented (docs).
Unstructured Data Catalog: Lineage can reach unstructured data lakes, but documents are not catalogued (docs).
Not covered: Data classification · Master data management
Foundational integrations
Foundational reads code from GitHub, GitLab, Bitbucket and Azure DevOps to trace lineage across Snowflake, Databricks, BigQuery, Redshift, dbt and Airflow, and works with 11 AI agent clients. Foundational lists 95 integrations in total.
- Data Warehouse: Amazon Redshift, Databricks SQL, Google BigQuery, IBM DB2, OpenText Analytics Database (Vertica), Oracle DB, Snowflake
- Databases: Amazon Aurora, Amazon RDS, Apache Cassandra, Apache CouchDB, Azure SQL Database, Couchbase, Google BigTable, Google Cloud Spanner, Greenplum, Mainframe, MariaDB, Microsoft SQL Server, MongoDB, MySQL, PostgreSQL
- Query Engine: Amazon Athena, Hive SQL, Trino
- Data Platform: Alteryx, IBM DataStage, Informatica, Microsoft Fabric, TIBCO Data Virtualization, Talend
- Streaming: Apache Kafka, Confluent
- Data Integration: AWS Glue, Airbyte, Azure Data Factory, Fivetran, Google Datastream
- Data Transformation: Apache Spark, Coalesce, Google Dataflow, Google Dataform, Matillion, SQLMesh, dbt
- Data Orchestration: Apache Airflow
- BI: Amazon QuickSight, Apache Superset, Domo, Hex, Looker, Looker Studio, Metabase, Mode, Power BI, SAP Business Objects, Sigma, Sisense, Spotfire, Tableau, ThoughtSpot
- Data Applications: HubSpot, SAP ERP, Salesforce, Workday
- Data Governance: Collibra, OpenLineage
- AI Agents: ChatGPT, Claude, Claude Code, Cursor, Devin, Factory Droid, GitHub Copilot, Microsoft Copilot, OpenAI Codex, Salesforce Agentforce, Snowflake Cortex
- Notifications: Microsoft Teams, Slack
- Code Repositories: Azure DevOps, Bitbucket, GitHub, GitLab
- Authentication: Google OAuth, Google Workspace, JumpCloud, Microsoft Entra, Okta, Onelogin, OpenID, Ping, Rippling, SAML
- Data Security: Cyera
Foundational deployment options
SaaS Deployment: Cloud platform that reads metadata and code, never data (docs).
Hybrid Deployment: Enterprise plans run an agent or the parsing and analysis inside your network; only the sanitized lineage graph is synced (docs).
Data Residency: Multi-region deployments are mentioned, but a region choice for the SaaS is not documented (docs).
Self-Hosted Deployment: Even with local processing, the lineage graph is synced to Foundational's cloud (docs).
Foundational security
SSO: SSO with SAML 2.0 or OpenID Connect (docs).
RBAC: Two user roles, Admin and Read Only, plus API token roles (docs).
Audit Log: Audit Logs record user actions, login events and account changes (docs).
Compliance Certifications: SOC 2 Type II (docs).
SCIM Provisioning: SCIM provisioning from Okta, Azure and other identity providers (docs).
Foundational alternatives
The closest Foundational alternatives and most popular competitors are Gable, Recce, Solidatus, Atlan and OpenLineage. They share Foundational's main use cases and features, from the closest match down. The Foundational alternatives page compares their pricing, deployment and features, and says when to choose each one instead.
For field-level lineage of sensitive data across services, consider Gable. For data diffs on dbt pull requests only, Recce; for a full catalog with lineage, Atlan; for open-source runtime lineage, OpenLineage.
- 1. GableFoundational vs Gable
- 2. Recce
- 3. SolidatusFoundational vs Solidatus
- 4. AtlanFoundational vs Atlan
- 5. OpenLineage
Foundational FAQ
Is Foundational open source?
No. Foundational is proprietary software with no open-source edition.
Which data platforms does Foundational integrate with?
Foundational reads code from GitHub, GitLab, Bitbucket and Azure DevOps to trace lineage across Snowflake, Databricks, BigQuery, Redshift, dbt and Airflow, and works with 11 AI agent clients.
What are the best Foundational alternatives and competitors?
The closest alternatives are Gable, Recce, Solidatus, Atlan and OpenLineage. The Foundational alternatives page compares their features and pricing and says when to choose each one over Foundational.
Browse all 102 tool profiles, grouped by category.
Evaluating data tools in 2026?
I curate the most comprehensive lists of data tools, up-to-date comparison tables, and actionable market guides for data teams. More useful than a Gartner report. More reliable than asking AI. Next up: Data FinOps.