{"id":2409,"date":"2022-08-20T22:58:28","date_gmt":"2022-08-21T03:58:28","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2409"},"modified":"2022-08-28T08:39:02","modified_gmt":"2022-08-28T13:39:02","slug":"introduction-of-gudu-sqlflow","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/introduction-of-gudu-sqlflow\/","title":{"rendered":"Introduction of Gudu SQLFlow"},"content":{"rendered":"\n

Gudu SQLFlow<\/a><\/strong> is an analysis software for analyzing SQL statements and discovering data lineage<\/a><\/strong> relationships. It is often used with metadata management<\/strong><\/a> tools and is a basic tool for enterprise data governance<\/strong><\/a>. In this article, we’ll give a brief introduction of Gudu SQLFlow<\/strong>.<\/p>\n\n\n

\n
\"Introduction<\/a>
Introduction of Gudu SQLFlow<\/figcaption><\/figure><\/div>\n\n\n

If you are not familiar with the SQL language, this article may not be for you. No prior knowledge of data lineage is required to read this article. You only need to simply understand the data lineage relationship as a data dependency between two or more tables in the database.<\/p>\n\n\n\n

Let’s analyze the following SQL statements to see how to sort out the data dependencies between various tables\/views.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

By analyzing the above INSERT SQL statement, we can know:<\/p>\n\n\n\n

The data of the deptsal table comes from the dept and emp tables. Further, the data dependency (data lineage) at the field level is:<\/p>\n\n\n\n