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

# Gudu SQLFlow direct data flow introduction

- han yu
- May 26, 2022
- sql, SQL language

In this article, we’ll introduce some of the SQL elements that generate direct dataflows, which are the main archetypes of production dataflows.

### 1、Select

Example statement:

The data for the target column “eName” comes from the scott.emp.empName column, so we have a direct data flow like this:

The result set RS-1 produced by the select list is a relation, including columns and rows.

dataflow in XML

The above relationship represents the data flow from the source column with id=3 to the destination column with id=6.

The data flow is as shown in the figure:

### 2. Function

During data flow analysis, functions play a key role, accepting columns as arguments and producing results that may be scalar or set-valued.

In the above SQL, a direct data flow is generated from the column salary to the round function:

The data flow is as shown in the figure:

dataflow in xml

The data flow is as shown in the figure:

If you turn off “show function” and set the “/if” option, the data flow results as follows:

### Conclusion

Thank you for reading our article and we hope it can help you to have a better understanding of Gudu SQLFlow direct data flow. If you want to learn more about Gudu SQLFlow data lineage software, we would like to advise you to visit their official website for more information.

As one of the best data lineage tools available on the market today, 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.

### Newsletter Updates

Enter your email address below to subscribe to our newsletter

I accept the Privacy Policy

### Related Posts

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

#### Introduction to Gudu SQLFlow Indirect Data Flow and Pseudo Columns

- May 21, 2022