When dealing with large-scale data environments, analyzing data lineage manually becomes impractical. You might have hundreds of SQL files across different repositories, databases, and ETL processes. This is where SQLFlow Job comes into play – a powerful feature that enables…
Data professionals often face a common challenge in BigQuery and other SQL databases: tracking the journey of a specific column through multiple layers of views, especially when those views are created with SELECT *. While SELECT * is convenient during…
When browsing through SQL scripts, you’ve likely seen schema-qualified table names written in two distinct ways: dbo.MyTable and [dbo].[MyTable]. Functionally, they often seem to produce the same result, which begs the question: Does it matter which one you use? And…
Welcome to a journey of SQL mastery! In the ever-evolving landscape of data management, having a strong command over SQL syntax is crucial. As you embark on this comprehensive guide for 2024 and beyond, you are about to explore the…
It is pretty easy to retrieve data lineage from a SQL Server database by using Gudu SQLFlow. Please following those steps and you will get the data lineage in a visual presentation in several minutes. 1. Visit the Gudu SQLFlow…
There are lots of improvements since V0.4, below are some of the most important improvements: Oracle SQL and PLSQL query parse tree structure was fully accessible. toString() of all parse tree node classes was supported, so you can get text of parse…
In this version, we can easily fetch table and column from stored procedures(packages) of Oracle and SQL Server. Let’s take this create trigger statement(Oracle) for example: CREATE TRIGGER hr.emp_permit_changes BEFORE DELETE OR INSERT OR UPDATE ON hr.employees BEGIN INSERT INTO…
