Gudu SQLFlow Data Lineage Analysis Level Introduction
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 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.