Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Gudu SQLFlow Data Lineage Analysis Level Introduction

- han yu
- May 16, 2022
- SQL language

## Gudu SQLFlow Data Lineage Analysis Level

Gudu SQLFlow is one of the most popular data lineage management tools available on the market today. It is a tool for automatically discovering data flow by analyzing SQL scripts. In order to meet the various needs of users for data lineage analysis, it is necessary to divide the Gudu SQLFlow data lineage analysis model into several levels, each of which is suitable for specific needs.

Gudu SQLFlow Data Lineage Tool

### Gudu SQLFlow Data Lineage Analysis Model

Gudu SQLFlow currently supports three data lineage analysis models, namely the complete data lineage analysis model, the table-level data lineage analysis model, and the column-level data lineage analysis model.

#### Complete data lineage analysis model:

In this model, the lineage analysis of the data generated by Gudu SQLFlow includes all the details such as the result set generated during the SELECT statement, the function calls used to calculate new column values ​​based on the input columns, the data line used to transform data from one column to another uppercase and lowercase expressions, etc. This data lineage analysis model is the basis for all other higher-level lineage models that include only some of the lineages in this full model by omitting or aggregating some of the relationships and entities in this model.

#### Table-level data lineage analysis model:

This model tracks the flow of data in the table TOTABLE based on SQL statements. In other words, from this model, you can see what SQL statements are used to move data from one table to another. The model contains only three entities: source table, target table and SQL statement and the relationship between them. If you want to see how the data moves through the SQL statement, you can use this full model of the SQL statement to find out more.

#### Column-level data lineage analysis model:

This model tracks the flow of data from one column to another based on SQL statements. In other words, from this model you can see what SQL statement is used to move/affect data from one column to another, the model contains only three entities: source column, target column and SQL statement and the relationship between them. If you want to understand how data flows and interacts in an SQL statement, you can use this full model of the SQL statement to find out more.

### Conclusion

Thank you for reading our article and we hope it can help you have a better understanding of the Gudu SQLFlow data lineage tool. If you want to know more about the use and technical information of Gudu SQLFlow, please log on to their official website and you will get more support and help.

### Newsletter Updates

Enter your email address below to subscribe to our newsletter

I accept the Privacy Policy

### Related Posts

#### Gudu SQLFlow direct data flow introduction

- May 26, 2022

#### Introduction to where-group-by clause in Gudu SQLFlow indirect data flow

- May 25, 2022

#### How to Get Data Lineage by Analyzing Oracle’s SQL Statements and Stored Procedures?

- May 23, 2022