4 SQL Lineage Tools for Apache Spark

Dataedo

https://dataedo.com/product/data-lineage

Dataedo provides SQL lineage tracking by visualizing how data flows through queries, transformations, and databases. This enhances transparency, supports troubleshooting, and ensures data accuracy across SQL-based environments.

Automatic discovery:
Data flow visualization:
Environment:	On-premises
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Monte Carlo

https://docs.getmontecarlo.com/docs/field-lineage

Monte Carlo is a data observability platform that offers field-level data lineage functionality, making it faster and easier to conduct root cause and impact analysis for critical data issues. With field-level lineage fully automated, data engineers and analysts can confidently make changes to tables without losing trust and visibility in their data at each stage of its life cycle.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Informatica Data Lineage

https://www.informatica.com/products/data-catalog/data-lineage.html

Informatica Data Lineage tool provides automated end-to-end data lineage with detailed and summary views of data movement across data pipelines. With Informatica, you can derive lineage from code in SQL scripts, stored procedures and AI/ML code. It streamlines tracking data flow from system- to column-level for detailed impact analysis.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

OpenLineage

https://openlineage.io/

OpenLineage is an open platform for collection and analysis of data lineage. It tracks metadata about datasets, jobs, and runs. Pipeline components - like schedulers, warehouses, analysis tools, and SQL engines - can use a standard API for capturing lineage events to send data about runs, jobs, and datasets to a compatible OpenLineage backend for further study.