{"id":1827,"date":"2022-05-09T04:18:24","date_gmt":"2022-05-09T09:18:24","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=1827"},"modified":"2022-05-09T04:21:50","modified_gmt":"2022-05-09T09:21:50","slug":"introduction-to-sqlflow-data-flow-chain","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2022\/05\/introduction-to-sqlflow-data-flow-chain\/","title":{"rendered":"Introduction to SQLFlow Data Flow Chain"},"content":{"rendered":"

In this article, we will give a brief introduction to SQLFlow<\/a><\/strong> data flow chain.<\/p>\n

If a result set of a subquery or CTE is used in the from clause of an upper statement, the effect of the lower result set will be transferred to the upper level.<\/p>\n

Introduction to SQLFlow Data Flow Chain<\/figcaption><\/figure>\n

In CTE, there is an influence relationship:<\/p>\n

<\/p>\n

Since cteReports is used in the from clause of the upper statement, the impact will be as follows:<\/p>\n

<\/p>\n

If the intermediate result set is ignored, the end-to-end data flow is:<\/p>\n

<\/p>\n

Database icon:<\/p>\n

<\/p>\n

## Conclusion<\/h2>\n

Thank you for reading our article and we hope it can be helpful to you. If you want to learn more about SQLFlow, we would like to advise you to visit Gudu SQLFlow<\/strong> for more information. As a data lineage<\/a><\/strong> analysis tool, Gudu SQLFlow\u00a0<\/strong>can not only analyze SQL script files, obtain data lineage, and perform visual display, but also allow users to provide data lineage in CSV format and perform visual display. Thanks again!<\/p>\n","protected":false},"excerpt":{"rendered":"

In this article, we will give a brief introduction to SQLFlow data flow chain. If a result set of a subquery or CTE is used in the from clause of an upper statement, the effect of the lower result set will be transferred to the upper level. In CTE, there is an influence relationship: Since cteReports is used in the from clause of the upper statement, the impact will be as follows: If the intermediate result set is ignored, the end-to-end data flow is: Database icon: Conclusion Thank you for reading our article and we hope it can be helpful\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[30],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nIntroduction to SQLFlow Data Flow Chain<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n