SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data lineage tools for Snowflake
Data lineage tools are software that allows to extract, view and analyze data lineage. Data lineage is the process of understanding and visualizing data flow from the source to different destinations. It allows to create a map of the data journey through the entire ecosystem.
Dataedo
Dataedo allows you to extract lineage automatically or design flows manually and visualize how data moves through the system with interactive diagrams. Dataedo supports object and column-level data lineage.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
MANTA
MANTA is a data lineage platform that automatically scans your data environment to build a powerful map of all data flows and deliver it through a native UI and other channels to both technical and non-technical users. It automatically scans every nook and cranny to get immediate, accurate, and up-to-date lineage.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Collibra Data Lineage
Collibra Data Lineage automatically maps relationships between data to show how data flows from system to system and how data sets are built, aggregated, sourced and used, providing complete, end-to-end lineage visualization.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Tokern
Tokern Lineage Engine is a fast and easy to use platform to collect, visualize and analyze column-level data lineage in databases, data warehouses and data lakes in AWS and GCP. You can use the API or library to access column-level lineage and automate data quality triage, scan and tag PII/PHI/sensitive data, programmatically monitor and manage ACLs, data and ETL pipeline cleanup, and impact analysis.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Free |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
SQLFlow
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.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
ASG Data Intelligence
ASG Data Intelligence (ASG DI) is the solution for data distrust. It is a metadata-driven platform that makes technical data “smarter” with end-to-end views of the data and its movements (data lineage) combined with business meaning and usage guardrails. It lets you visualize data flows mapped to business context, and it uniquely traces lineage by parsing code from data sources, applications, tools, and source code.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Global IDs
Global IDs Data Lineage provides automated analysis of the actual flow of data through your enterprise, enabling you to understand – in real-time – where data originates, how it flows through the ecosystem, and how it is transformed en route.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Atlan
Atlan provides effortless data lineage & governance by letting you auto-construct data lineage & deploy best-in-class data access governance without compromising on data democratization. It automatically parses through your SQL query logs in your data warehouses and BI tools to create a visual view of data lineage.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Alteryx Connect
Alteryx Connect uses powerful search capabilities to find and reuse information contained in data files, databases, visualizations, dashboards, workflows, analytic apps, and more. It lets you automatically capture and visualize data lineage between assets, improving the overall quality and reliability of shared information between data, process, and people. You can get technical data lineage by loading metadata from source and target systems and interpreting Alteryx workflows.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
MetaCenter
MetaCenter automates data lineage analysis across Databases, ETL, Business Intelligence, Cloud, and Hadoop environments. It lets you reduce data management costs by automating data lineage and impact analysis documentation.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Tree Schema
Tree Schema lets you explore your data lineage and understand where your data comes from and where it is going. It leverages the APIs in your database and dashboard tools to automatically extract your data lineage. Granular field-level source to target mapping provides an end-to-end view for your data lineage while describing connections between databases.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
OpenLineage
OpenLineage is an open platform for collection and analysis of data lineage. It tracks metadata about datasets, jobs, and runs, giving users the information required to identify the root cause of complex issues and understand the impact of changes. OpenLineage contains an open standard for lineage data collection, a metadata repository reference implementation (Marquez), libraries for common languages, and integrations with data pipeline tools.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Free |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Datameer
Datameer SaaS Data Transformation is the industry’s first collaborative, multi-persona data transformation platform integrated into Snowflake. In Datameer, complete data lineage is captured, all the way down to each and every transformation. This helps you understand where your data came from, how it was shaped, and where it went to.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
ER/Studio
ER/Studio is an enterprise data modeling, architecture, and governance tool. It comes with a data lineage tab which is used to primarily document ETL processes from scratch. With visual data lineage support, you can visually document source/target mapping and sourcing rules for data movement across systems.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Secoda
Secoda is a data discovery tool that offers an intuitive, collaborative, and easy to implement data discovery built. It automatically extracts queries to generate data lineage. Currently, it is supporting table lineage for Snowflake, dbt, Redshift, and BigQuery, with support for Postgres, MySQL, and Microsoft SQL Server coming soon. Secoda data lineage can help data teams identify the downstream and upstream dependencies of a table easily. On each dependency, you will be able to see how many levels away a particular table is, with the ability to view the data in a visual form coming soon.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Data lineage forms the foundation for accurate data analytics and management. The core features of data lineage focuses on:
• Identifying data quality issues.
• Performing root cause analysis.
• Enabling to understand which data sources are outdated or which datasets are relevant.
• Minimizing the risk of migration projects.
• Providing transparency over the life cycle of data.
Data lineage tools map the data flow and help you understand where the data originated, how it flows and transforms. To help you find the right tool for your company, we prepared a list that includes some of the best data lineage tools.