6 SQL Lineage Tools for Vertica

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

SQLFlow

https://www.gudusoft.com/data-lineage-visualization-discovery-tools/

SQLFlow is an online SQL data lineage tool that visually represents the overall flow of data. It offers automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud, and Hadoop environments by parsing SQL Script and stored procedure. It enables impact analysis at a granular level, drilling down into table, column, and query-level lineage.

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

Go to vendor website

Octopai

https://www.octopai.com/

Octopai Data Lineage XD is the most complete, in-depth, and automated lineage tool that provides end-to-end lineage at the system level from the entry point into the data landscape, all the way to reporting and analytics. Its cross-system lineage reflects data flows and dependencies using automated and augmented methods to provide the most extensive cross-system view of the entire data landscape.

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

Go to vendor website

OvalEdge

https://ovaledge.com

OvalEdge provides a powerful and automated way to visualize your Data Flow Effortlessly. Its algorithms build the lineage from the most accurate source, source code. It crawls the source code from various connectors. After that, it parses its language like SQL, PL/SQL, XML, etc., and then builds the lineage.

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

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.