{"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

\"1\"
\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

\"2\"<\/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

\"3(1)\"<\/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

\"01-3\"<\/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

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

\"4\"<\/p>\n

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

\"02-3\"<\/p>\n

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

\"6(1)\"<\/p>\n

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

\"03-3\"<\/p>\n

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

\"04-3\"<\/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<meta name=\"description\" content=\"Gudu SQLFlow direct data flow introduction\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gudu SQLFlow direct data flow introduction\" \/>\n<meta property=\"og:description\" content=\"Gudu SQLFlow direct data flow introduction\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-26T07:28:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/1-7.png\" \/>\n<meta name=\"author\" content=\"han yu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"han yu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\",\"name\":\"Gudu SQLFlow direct data flow introduction\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2022-05-26T07:28:26+00:00\",\"dateModified\":\"2022-05-26T07:28:26+00:00\",\"description\":\"Gudu SQLFlow direct data flow introduction\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gudu SQLFlow direct data flow introduction\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\"},\"author\":{\"name\":\"han yu\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130\"},\"headline\":\"Gudu SQLFlow direct data flow introduction\",\"datePublished\":\"2022-05-26T07:28:26+00:00\",\"dateModified\":\"2022-05-26T07:28:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/\"},\"wordCount\":275,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"keywords\":[\"Best Data Lineage Tools\",\"data lineage software\",\"direct data flow\",\"Gudu SQLFlow\"],\"articleSection\":[\"sql\",\"SQL language\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130\",\"name\":\"han yu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/401910b33aed92b7ba8fb4415a22a935?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/401910b33aed92b7ba8fb4415a22a935?s=96&d=mm&r=g\",\"caption\":\"han yu\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/yuhan10080710229\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Gudu SQLFlow direct data flow introduction","description":"Gudu SQLFlow direct data flow introduction","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/","og_locale":"en_US","og_type":"article","og_title":"Gudu SQLFlow direct data flow introduction","og_description":"Gudu SQLFlow direct data flow introduction","og_url":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/","og_site_name":"SQL and Data Blog","article_published_time":"2022-05-26T07:28:26+00:00","og_image":[{"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/1-7.png"}],"author":"han yu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"han yu","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/","url":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/","name":"Gudu SQLFlow direct data flow introduction","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2022-05-26T07:28:26+00:00","dateModified":"2022-05-26T07:28:26+00:00","description":"Gudu SQLFlow direct data flow introduction","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Gudu SQLFlow direct data flow introduction"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/"},"author":{"name":"han yu","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130"},"headline":"Gudu SQLFlow direct data flow introduction","datePublished":"2022-05-26T07:28:26+00:00","dateModified":"2022-05-26T07:28:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/05\/gudu-sqlflow-direct-data-flow-introduction\/"},"wordCount":275,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"keywords":["Best Data Lineage Tools","data lineage software","direct data flow","Gudu SQLFlow"],"articleSection":["sql","SQL language"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130","name":"han yu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/401910b33aed92b7ba8fb4415a22a935?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/401910b33aed92b7ba8fb4415a22a935?s=96&d=mm&r=g","caption":"han yu"},"url":"https:\/\/www.dpriver.com\/blog\/author\/yuhan10080710229\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2127"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=2127"}],"version-history":[{"count":6,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2127\/revisions"}],"predecessor-version":[{"id":2143,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2127\/revisions\/2143"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=2127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=2127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=2127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}