7 SQL Lineage Tools for Databricks

Alvin provides column-level highly accurate lineage and usage data across your entire data stack, and a host of features that help your team deliver measurable business impact. It lets you search and filter your assets by usage, last used, tags, data sensitivity, parent, platform, type, any pretty much anything else you can think of.

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

Go to vendor website

OpenMetadata

https://open-metadata.org/

OpenMetadata is a single place to discover, collaborate and get your data right. It supports a comprehensive lineage for all data assets by capturing the relation between entities. It traces the path of data across tables, pipelines, and dashboards, while the manual lineage helps augment the lineage captured from machine metadata with user knowledge.

Automatic discovery:
Data flow visualization:
Environment:	Online
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

Secoda

https://www.secoda.co/data-lineage

Secoda provides end-to-end data lineage across your entire data stack. It automates column and table level data lineage. In additional, Secoda also brings in tests, events, and ETL into data lineage. All of Secoda's lineage is automated, but users can also manually contribute to lineage using Secoda's API.

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

Fivetran

https://www.fivetran.com/data-movement/transformations

Fivetran is the automated data movement platform moving data out of, into and across your cloud data platforms. It allows you to monitor data movement, logs, and status from connector extract to successful warehouse load through modeling — all in one data lineage graph (DLGs). DLGs show the dependencies between your dbt models so that you can track the flow of data from your connectors to your destination.