Category Uncategorized

Discover data lineage from sub-query and CTE

SQL’s flexibility allows multiple approaches to achieve the same result in a statement. Below, three variations of SQL statements are shown to update the PARENT_TABLE column in the CCF table based on values from the PARENT_TABLE column in the CCF_BAK…

The Top 5 Most Popular Data Lineage Tool

Introduction Data lineage analysis is crucial for understanding data flow, ensuring data quality, and maintaining regulatory compliance. Here’s a look at the top five data lineage analysis tools, with SQLFlow leading the pack, along with pricing information where available. 1.…

Enhancing Data Governance with Gudu SQLFlow

Introduction Effective data governance ensures data integrity, security, and compliance. Gudu SQLFlow provides comprehensive features that facilitate robust data governance practices by enhancing data visualization and management. Here’s how users can leverage Gudu SQLFlow to improve their data governance framework.…

SQL Visualizer

What is SQL Visualizer and how can it help? A SQL visualizer, also known as a database visualization tool or SQL query visualizer, is a software application designed to help users interact with and visualize data stored in relational databases…

Ingest Oracle metadata on Datahub

Datahub is an open-source metadata platform for the modern data stack. We have integrated the SQLFlow into Datahub so that the SQLFlow data lineage is enabled in the Datahub UI. Check this blog for how to integrate SQLFlow into Datahub.…

Ingest PostgreSQL metadata on Datahub

Datahub is an open-source metadata platform for the modern data stack. We have integrated the SQLFlow into Datahub so that the SQLFlow data lineage is enabled in the Datahub UI. Check this blog for how to integrate SQLFlow into Datahub. There are three…