{"id":2127,"date":"2022-05-26T02:28:26","date_gmt":"2022-05-26T07:28:26","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2127"},"modified":"2022-05-26T02:28:26","modified_gmt":"2022-05-26T07:28:26","slug":"gudu-sqlflow-direct-data-flow-introduction","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/","title":{"rendered":"Gudu SQLFlow direct data flow introduction"},"content":{"rendered":"

In this article, we’ll introduce some of the SQL elements that generate direct dataflows, which are the main archetypes of production dataflows.<\/p>\n

### 1\u3001Select<\/h3>\n

Example statement:<\/p>\n

\nThe data for the target column “eName” comes from the scott.emp.empName column, so we have a direct data flow like this:<\/p>\n

<\/p>\n

The result set RS-1 produced by the select list is a relation, including columns and rows.<\/p>\n

dataflow in XML<\/strong><\/p>\n

<\/p>\n

The above relationship represents the data flow from the source column with id=3 to the destination column with id=6.<\/p>\n

The data flow is as shown in the figure:<\/p>\n

<\/p>\n

### 2. Function<\/h3>\n

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

\nIn the above SQL, a direct data flow is generated from the column salary to the round function:<\/p>\n

<\/p>\n

The data flow is as shown in the figure:<\/p>\n

<\/p>\n

dataflow in xml<\/strong><\/p>\n

<\/p>\n

The data flow is as shown in the figure:<\/p>\n

<\/p>\n

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

<\/p>\n

### Conclusion<\/h3>\n

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

As one of the best data lineage tools<\/a><\/strong> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this article, we’ll introduce some of the SQL elements that generate direct dataflows, which are the main archetypes of production dataflows. 1\u3001Select 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\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,8],"tags":[31,38,43,27],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nGudu SQLFlow direct data flow introduction<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n