Data is considered to be the fuel that drives business growth and the engine of business innovation. Data is undoubtedly one of the assets that an organization recognizes and owns, but due to the increase in its massive data, the…
What is a data mart? A data mart is a simple form of data warehouse, a data mart for a single subject domain, such as: sales, finance, marketing, etc. The data source of the data mart can be an operating…
What is a data governance strategy? A data governance strategy is a set of rules that help protect data and establish standards for its access, use, and integrity. These strategies are often accompanied by standards that provide more detailed rules…
What Is Data Mining? Data mining is the exploration and analysis of data to discover meaningful patterns or rules. It is classified as a discipline within the field of data science. Data mining techniques are used to produce machine learning…
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…
Gudu SQLFlow is a platform for analyzing data lineage. You can directly submit SQL statements online for analysis, or you can choose to connect to a specified database to obtain metadata, upload a file directory from the local, or obtain…
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…
Gudu SQLFlow Data Flow Generation As one of the most popular data lineage tools, Gudu SQLFlow is a tool that automatically discovers data flow by analyzing SQL scripts. It shows the flow of data between tables/views and columns in a data…
