{"id":1878,"date":"2022-05-16T01:37:10","date_gmt":"2022-05-16T06:37:10","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=1878"},"modified":"2022-05-16T05:27:09","modified_gmt":"2022-05-16T10:27:09","slug":"gudu-sqlflow-data-lineage-analysis-level-introduction","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/","title":{"rendered":"Gudu SQLFlow Data Lineage Analysis Level Introduction"},"content":{"rendered":"

Gudu SQLFlow Data Lineage Analysis Level<\/h2>\n

Gudu SQLFlow<\/a><\/strong> is one of the most popular data lineage management tools<\/a>\u00a0<\/strong>available on the market today. It is a tool for automatically discovering data flow by analyzing SQL scripts.\u00a0In order to meet the various needs of users for data lineage<\/a><\/strong> analysis, it is necessary to divide the Gudu SQLFlow data lineage analysis model into several levels, each of which is suitable for specific needs.<\/p>\n

\"Gudu
Gudu SQLFlow Data Lineage Tool<\/figcaption><\/figure>\n

Gudu SQLFlow Data Lineage Analysis Model<\/h3>\n

Gudu SQLFlow currently supports three data lineage analysis models, namely the complete data lineage analysis model, the table-level data lineage analysis model, and the column-level data lineage analysis model.<\/p>\n

Complete data lineage analysis model:\u00a0<\/strong><\/h4>\n

In this model, the lineage analysis of the data generated by Gudu SQLFlow includes all the details such as the result set generated during the SELECT statement, the function calls used to calculate new column values \u200b\u200bbased on the input columns, the data line used to transform data from one column to another uppercase and lowercase expressions, etc.\u00a0This data lineage analysis model is the basis for all other higher-level lineage models that include only some of the lineages in this full model by omitting or aggregating some of the relationships and entities in this model.<\/p>\n

\"Complete_data_lineage_analysis_model\"<\/p>\n

Table-level data lineage analysis model:<\/h4>\n

This model tracks the flow of data in the table TOTABLE based on SQL statements. In other words, from this model, you can see what SQL statements are used to move data from one table to another.\u00a0The model contains only three entities: source table, target table and SQL statement and the relationship between them. If you want to see how the data moves through the SQL statement, you can use this full model of the SQL statement to find out more.<\/p>\n

\"Table-level_data_lineage_analysis<\/p>\n

Column-level data lineage analysis model:<\/h4>\n

This model tracks the flow of data from one column to another based on SQL statements.\u00a0In other words, from this model you can see what SQL statement is used to move\/affect data from one column to another, the model contains only three entities: source column, target column and SQL statement and the relationship between them.\u00a0If you want to understand how data flows and interacts in an SQL statement, you can use this full model of the SQL statement to find out more.<\/span><\/p>\n

\"Column_level_data_lineage_analysis_model\"<\/p>\n

Conclusion<\/h3>\n

Thank you for reading our article and we hope it can help you have a better understanding of the Gudu SQLFlow data lineage tool<\/strong>.\u00a0If you want to know more about the use and technical information of Gudu SQLFlow,\u00a0please log on to their official website and you will get more support and help.<\/p>\n","protected":false},"excerpt":{"rendered":"

Gudu SQLFlow Data Lineage Analysis Level Gudu SQLFlow is one of the most popular data lineage management tools\u00a0available on the market today. It is a tool for automatically discovering data flow by analyzing SQL scripts.\u00a0In order to meet the various needs of users for data lineage analysis, it is necessary to divide the Gudu SQLFlow data lineage analysis model into several levels, each of which is suitable for specific needs. Gudu SQLFlow Data Lineage Analysis Model Gudu SQLFlow currently supports three data lineage analysis models, namely the complete data lineage analysis model, the table-level data lineage analysis model, and the\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":[26,35,27,36],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nGudu SQLFlow Data Lineage Analysis Level Introduction<\/title>\n<meta name=\"description\" content=\"Gudu SQLFlow Data Lineage Analysis Level 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\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gudu SQLFlow Data Lineage Analysis Level Introduction\" \/>\n<meta property=\"og:description\" content=\"Gudu SQLFlow Data Lineage Analysis Level Introduction\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-16T06:37:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-16T10:27:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/Gudu_SQLFlow-19.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=\"2 minutes\" \/>\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\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\",\"name\":\"Gudu SQLFlow Data Lineage Analysis Level Introduction\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2022-05-16T06:37:10+00:00\",\"dateModified\":\"2022-05-16T10:27:09+00:00\",\"description\":\"Gudu SQLFlow Data Lineage Analysis Level Introduction\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gudu SQLFlow Data Lineage Analysis Level Introduction\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\"},\"author\":{\"name\":\"han yu\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130\"},\"headline\":\"Gudu SQLFlow Data Lineage Analysis Level Introduction\",\"datePublished\":\"2022-05-16T06:37:10+00:00\",\"dateModified\":\"2022-05-16T10:27:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/\"},\"wordCount\":459,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"keywords\":[\"data lineage\",\"Data Lineage Tool\",\"Gudu SQLFlow\",\"Gudu SQLFlow data lineage tool\"],\"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":"Gudu SQLFlow Data Lineage Analysis Level Introduction","description":"Gudu SQLFlow Data Lineage Analysis Level 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\/gudu-sqlflow-data-lineage-analysis-level-introduction\/","og_locale":"en_US","og_type":"article","og_title":"Gudu SQLFlow Data Lineage Analysis Level Introduction","og_description":"Gudu SQLFlow Data Lineage Analysis Level Introduction","og_url":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/","og_site_name":"SQL and Data Blog","article_published_time":"2022-05-16T06:37:10+00:00","article_modified_time":"2022-05-16T10:27:09+00:00","og_image":[{"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/05\/Gudu_SQLFlow-19.png"}],"author":"han yu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"han yu","Est. reading time":"2 minutes"},"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\/gudu-sqlflow-data-lineage-analysis-level-introduction\/","url":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/","name":"Gudu SQLFlow Data Lineage Analysis Level Introduction","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2022-05-16T06:37:10+00:00","dateModified":"2022-05-16T10:27:09+00:00","description":"Gudu SQLFlow Data Lineage Analysis Level Introduction","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Gudu SQLFlow Data Lineage Analysis Level Introduction"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/"},"author":{"name":"han yu","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/e8cef08dc9a534a547554f37fa63b130"},"headline":"Gudu SQLFlow Data Lineage Analysis Level Introduction","datePublished":"2022-05-16T06:37:10+00:00","dateModified":"2022-05-16T10:27:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/gudu-sqlflow-data-lineage-analysis-level-introduction\/"},"wordCount":459,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"keywords":["data lineage","Data Lineage Tool","Gudu SQLFlow","Gudu SQLFlow data lineage tool"],"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\/1878"}],"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=1878"}],"version-history":[{"count":9,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1878\/revisions"}],"predecessor-version":[{"id":1892,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1878\/revisions\/1892"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}