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

# Introduction to SQLFlow Data Flow Chain

- han yu
- May 9, 2022
- SQL language

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.

Introduction to SQLFlow Data Flow Chain

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 to you. If you want to learn more about SQLFlow, we would like to advise you to visit Gudu SQLFlow for more information. As a data lineage analysis tool, Gudu SQLFlow 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!

### 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