SQL Lineage Tools for Azure Synapse

Dataedo

Dataedo allows you to extract lineage automatically or design flows manually and visualize how data moves through the system with interactive diagrams.

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

Collibra Data Lineage

Collibra Data Lineage extracts and maintains lineage automatically from source systems, SQL dialects, ETL tools, and BI tools. It provides detailed technical lineage at the table, column, transformation, and SQL query levels to quickly understand the impact of potential changes. Moreover, its interactive lineage diagram shows a summary of lineage from source to destination.

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

Informatica Data Lineage

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: Yes
Data flow visualization: Yes
Environment: Online
Free edition: No
Metadata management: Yes
Version control integration: Yes

Fivetran

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.

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