{"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\/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
Introduction to SQLFlow Data Flow Chain<\/figcaption><\/figure>\n

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

\"Introduction_to_SQLFlow_Data_Flow_Chain<\/p>\n

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

\"Introduction_to_SQLFlow_Data_Flow_Chain<\/p>\n

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

\"Introduction_to_SQLFlow_Data_Flow_Chain<\/p>\n

Database icon:<\/p>\n

\"Introduction_to_SQLFlow_Data_Flow_Chain<\/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<meta name=\"description\" content=\"Introduction to SQLFlow Data Flow Chain\" \/>\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\/introduction-to-sqlflow-data-flow-chain\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to SQLFlow Data Flow Chain\" \/>\n<meta property=\"og:description\" content=\"Introduction to SQLFlow Data Flow Chain\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-09T09:18:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-09T09:21:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/Introduction_to_SQLFlow_Data_Flow_Chain-1.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\/introduction-to-sqlflow-data-flow-chain\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/\",\"name\":\"Introduction to SQLFlow Data Flow Chain\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2022-05-09T09:18:24+00:00\",\"dateModified\":\"2022-05-09T09:21:50+00:00\",\"description\":\"Introduction to SQLFlow Data Flow Chain\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to SQLFlow Data Flow Chain\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/\"},\"author\":{\"name\":\"han yu\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130\"},\"headline\":\"Introduction to SQLFlow Data Flow Chain\",\"datePublished\":\"2022-05-09T09:18:24+00:00\",\"dateModified\":\"2022-05-09T09:21:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/\"},\"wordCount\":181,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"keywords\":[\"SQLFlow Data Flow\"],\"articleSection\":[\"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":"Introduction to SQLFlow Data Flow Chain","description":"Introduction to SQLFlow Data Flow Chain","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\/introduction-to-sqlflow-data-flow-chain\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to SQLFlow Data Flow Chain","og_description":"Introduction to SQLFlow Data Flow Chain","og_url":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/","og_site_name":"SQL and Data Blog","article_published_time":"2022-05-09T09:18:24+00:00","article_modified_time":"2022-05-09T09:21:50+00:00","og_image":[{"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/Introduction_to_SQLFlow_Data_Flow_Chain-1.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\/introduction-to-sqlflow-data-flow-chain\/","url":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/","name":"Introduction to SQLFlow Data Flow Chain","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2022-05-09T09:18:24+00:00","dateModified":"2022-05-09T09:21:50+00:00","description":"Introduction to SQLFlow Data Flow Chain","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Introduction to SQLFlow Data Flow Chain"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/"},"author":{"name":"han yu","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130"},"headline":"Introduction to SQLFlow Data Flow Chain","datePublished":"2022-05-09T09:18:24+00:00","dateModified":"2022-05-09T09:21:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/introduction-to-sqlflow-data-flow-chain\/"},"wordCount":181,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"keywords":["SQLFlow Data Flow"],"articleSection":["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\/1827"}],"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=1827"}],"version-history":[{"count":10,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1827\/revisions"}],"predecessor-version":[{"id":1843,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1827\/revisions\/1843"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}