all about SQL
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…
In this article, we’ll introduce some of the SQL elements that generate direct dataflows, which are the main archetypes of production dataflows. 1、Select Example statement: The data for the target column “eName” comes from the scott.emp.empName column, so we have…
In this article, we will introduce where-group-by clauses in Gudu SQLFlow indirect data flow. 1. column in the where clause Some columns in the source table in the WHERE clause do not affect the target columns, but are critical to…
An important foundational work in data governance is to analyze the data lineage in an organization. With complete data lineage, we can use it for data traceability, table and column change impact analysis, data compliance certification, data quality inspection, and more.…
Gudu SQLFlow Indirect Data Flow & Pseudo Columns Introduction This article describes some of the SQL elements that generate indirect data flow. Indirect data flow is typically generated by columns used in where clauses, group by clauses, aggregate functions, etc. To…
