{"id":3940,"date":"2022-05-22T01:45:21","date_gmt":"2022-05-22T09:45:21","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3940"},"modified":"2022-05-22T03:09:58","modified_gmt":"2022-05-22T11:09:58","slug":"get-the-data-lineage-of-complex-sql-statements","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/jp\/%e8%a4%87%e9%9b%91%e3%81%aa-sql-%e3%82%b9%e3%83%86%e3%83%bc%e3%83%88%e3%83%a1%e3%83%b3%e3%83%88%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e7%b5%b1%e3%81%ae%e5%8f%96%e5%be%97\/","title":{"rendered":"\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092 1 \u5206\u3067\u53d6\u5f97\u3059\u308b\u65b9\u6cd5| | Gudu SQLFlow"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#e8eaf0;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1310.4px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\" style=\"font-size:18px;line-height:26px;\"><h2>\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092 1 \u5206\u3067\u53d6\u5f97<\/h2>\n<p><strong><a href=\"https:\/\/www.gudusoft.com\/jp\/%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e7%b5%b1%e7%9f%a5%e8%ad%98%e3%83%99%e3%83%bc%e3%82%b9\/\">\u30c7\u30fc\u30bf\u7cfb\u7d71<\/a><\/strong> \u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba \u30c7\u30fc\u30bf \u30ac\u30d0\u30ca\u30f3\u30b9\u306b\u304a\u3051\u308b\u975e\u5e38\u306b\u91cd\u8981\u306a\u30ea\u30f3\u30af\u3067\u3059\u3002\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba \u30c7\u30fc\u30bf \u30ac\u30d0\u30ca\u30f3\u30b9\u306b\u304a\u3051\u308b\u30c7\u30fc\u30bf\u7cfb\u7d71\u306e\u91cd\u8981\u306a\u5f79\u5272\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002 <em><strong><a href=\"https:\/\/www.gudusoft.com\/jp\/whats-data-lineage-why-important\/\">\u30c7\u30fc\u30bf \u30ea\u30cd\u30fc\u30b8\u30e5\u3068\u306f\u4f55\u304b\u3001\u306a\u305c\u305d\u308c\u307b\u3069\u91cd\u8981\u306a\u306e\u304b?<\/a><\/strong><\/em>. SQL \u8a00\u8a9e\u306f\u30c7\u30fc\u30bf\u51e6\u7406\u3067\u5e83\u304f\u4f7f\u7528\u3055\u308c\u3066\u304a\u308a\u3001SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u306f\u8c4a\u5bcc\u306a\u30c7\u30fc\u30bf\u7cfb\u5217\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002 SQL \u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3068\u306f\u4f55\u304b\u3001\u304a\u3088\u3073 SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u96a0\u3055\u308c\u3066\u3044\u308b\u3053\u308c\u3089\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u767a\u898b\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002 <em><strong><a href=\"https:\/\/medium.com\/@han.yu_47442\/how-to-discover-data-lineage-in-sql-language-in-5-minutes-406ba357b3d9\">5 \u5206\u3067 SQL \u8a00\u8a9e\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u767a\u898b\u3059\u308b\u65b9\u6cd5\u306f?<\/a><\/strong><\/em>.<\/p>\n<div id=\"attachment_3949\" style=\"width: 941px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3949\" decoding=\"async\" class=\"size-full wp-image-3949\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute.png\" alt=\"\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092 1 \u5206\u3067\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\" width=\"931\" height=\"496\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-200x107.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-300x160.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-400x213.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-600x320.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-768x409.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute-800x426.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/How_to_Get_the_Data_Lineage_of_Complex_SQL_Statements_in_One_Minute.png 931w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><p id=\"caption-attachment-3949\" class=\"wp-caption-text\">\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092 1 \u5206\u3067\u53d6\u5f97\u3059\u308b\u65b9\u6cd5<\/p><\/div>\n<p><span class=\"Y2IQFc\" lang=\"en\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u4e3b\u306b \u304c\u63d0\u4f9b\u3059\u308b UI\u3001Rest API\u3001\u304a\u3088\u3073 Java \u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u4f7f\u7528\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/\">Gudu SQLFlow<\/a> <a href=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/11\/best-data-lineage-tools\/\">\u30c7\u30fc\u30bf\u7cfb\u7d71\u89e3\u6790\u30c4\u30fc\u30eb<\/a><\/strong> \u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u3059\u3070\u3084\u304f\u53d6\u5f97\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u72ec\u81ea\u306e\u30c7\u30fc\u30bf \u30ac\u30d0\u30ca\u30f3\u30b9 \u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u7d71\u5408\u3057\u307e\u3059\u3002<\/span><\/p>\n<h3>\u5c11\u3057\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/h3>\n<p>\u6b21\u306b\u3001\u6b21\u306e\u5c11\u3057\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3001Gudu SQLFlow \u3092\u4f7f\u7528\u3057\u3066\u3055\u307e\u3056\u307e\u306a\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u3059\u3070\u3084\u304f\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002\u3088\u308a\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3084\u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u306f\u3001Gudu SQLFlow \u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u7cfb\u7d71\u5206\u6790\u30c4\u30fc\u30eb\u304c\u3055\u3089\u306b\u7dca\u6025\u306b\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-3953 aligncenter\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1.png\" alt=\"\" width=\"915\" height=\"531\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-200x116.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-300x174.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-400x232.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-600x348.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-768x446.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1-800x464.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/1.png 915w\" sizes=\"(max-width: 915px) 100vw, 915px\" \/><\/p>\n<p>\u79c1\u305f\u3061\u306e\u76ee\u6a19\u306f\u3001\u6700\u4e0a\u4f4d\u306e\u9078\u629e\u30ea\u30b9\u30c8\u306b\u542b\u307e\u308c\u308b\u5217\u3068\u3001\u3053\u308c\u3089\u306e\u5217\u306e\u30bd\u30fc\u30b9 \u30c7\u30fc\u30bf\u304c\u4ed6\u306e\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u5217\u304b\u3089\u306e\u3082\u306e\u304b\u3092\u77e5\u308b\u3053\u3068\u3067\u3059\u3002\u7406\u60f3\u7684\u306a\u7d50\u679c\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<div id=\"attachment_3956\" style=\"width: 436px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3956\" decoding=\"async\" class=\"size-full wp-image-3956 aligncenter\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-top-level-select-list-data-lineage.png\" alt=\"\u6700\u4e0a\u4f4d\u9078\u629e\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\" width=\"426\" height=\"225\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-top-level-select-list-data-lineage-200x106.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-top-level-select-list-data-lineage-300x158.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-top-level-select-list-data-lineage-400x211.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-top-level-select-list-data-lineage.png 426w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><p id=\"caption-attachment-3956\" class=\"wp-caption-text\">\u6700\u4e0a\u4f4d\u9078\u629e\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71<\/p><\/div>\n<p><strong>\u4e0a\u8a18\u306e\u7d50\u679c\u3092\u5f97\u308b\u306b\u306f\u3001\u6b21\u306e\u3053\u3068\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/strong><\/p>\n<ol>\n<li>data.* \u306e * (\u30a2\u30b9\u30bf\u30ea\u30b9\u30af) \u3092\u81ea\u52d5\u7684\u306b\u5c55\u958b\u3057\u3066\u3001\u5bfe\u5fdc\u3059\u308b\u5217\u3092\u898b\u3064\u3051\u307e\u3059\u3002<\/li>\n<li>\u9078\u629e\u30ea\u30b9\u30c8\u306e\u5404\u5217\u306b\u5bfe\u3057\u3066\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9 \u30c8\u30ec\u30fc\u30b9\u3092\u5b9f\u884c\u3057\u3066\u3001\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u5217\u3092\u898b\u3064\u3051\u307e\u3059\u3002\u3053\u306e\u30d7\u30ed\u30bb\u30b9\u3067\u306f\u3001\u6700\u7d42\u7684\u306a\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u304c\u898b\u3064\u304b\u308b\u307e\u3067\u3001\u8907\u6570\u30ec\u30d9\u30eb\u306e\u30bd\u30fc\u30b9 \u30c8\u30ec\u30fc\u30b9\u304c\u5fc5\u8981\u306b\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n<\/ol>\n<h3>\u203b\u306e\u81ea\u52d5\u5c55\u958b\u306b\u3064\u3044\u3066<\/h3>\n<p>\u9078\u629e\u30ea\u30b9\u30c8\u306e * (\u30a2\u30b9\u30bf\u30ea\u30b9\u30af) \u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5185\u306e\u3059\u3079\u3066\u306e\u5217\u3092\u8868\u3057\u3001\u7279\u5b9a\u306e\u5217\u540d\u306b\u5c55\u958b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <span class=\"Y2IQFc\" lang=\"en\">\u3053\u306e\u5834\u5408\u3001Gudu SQLFlow \u306f\u3001SQL \u3067\u63d0\u4f9b\u3055\u308c\u308b\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u60c5\u5831\u306b\u57fa\u3065\u3044\u3066\u81ea\u52d5\u7684\u306b\u62e1\u5f35\u3067\u304d\u307e\u3059\u3002\u00a0<\/span>\u305f\u3060\u3057\u3001SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u81ea\u4f53\u3067\u306f\u3001 * \u306b\u542b\u307e\u308c\u308b\u5217\u3092\u5224\u65ad\u3059\u308b\u306e\u306b\u5341\u5206\u306a\u60c5\u5831\u304c\u5f97\u3089\u308c\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u6642\u70b9\u3067\u3001\u6b21\u306e\u3053\u3068\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/blog\/gsp-sqlenv\/\">\u30e1\u30bf\u30c7\u30fc\u30bf\u60c5\u5831\u3092 Gudu SQLFlow \u306b\u63d0\u4f9b\u3059\u308b<\/a><\/strong> \u30a2\u30b9\u30bf\u30ea\u30b9\u30af\u3092\u6b63\u3057\u304f\u5c55\u958b\u3059\u308b\u305f\u3081\u3002<\/p>\n<p><strong>Gudu SQLFlow<\/strong> \u3092\u3059\u3070\u3084\u304f\u5165\u624b\u3059\u308b\u305f\u3081\u306e 3 \u3064\u306e\u65b9\u6cd5\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002 <strong>\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71<\/strong>\u3001\u3055\u307e\u3056\u307e\u306a\u5834\u9762\u3067\u4f7f\u7528\u3059\u308b\u306e\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n<h4>1.Gudu SQLFlow UI<\/h4>\n<p>\u306b\u76f4\u63a5\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002 <strong><a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\">Gudu SQLFlow \u30af\u30e9\u30a6\u30c9<\/a><\/strong> \u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u305b\u305a\u306b\u4f7f\u7528\u3059\u308b\u30d0\u30fc\u30b8\u30e7\u30f3\u3002\u4f7f\u3044\u65b9\u306f\u3068\u3066\u3082\u7c21\u5358\u3067\u3059\u3002\u51e6\u7406\u3059\u308b SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u5165\u529b\u9818\u57df\u306b\u76f4\u63a5\u8cbc\u308a\u4ed8\u3051\u3066\u3001[\u8996\u899a\u5316] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<div id=\"attachment_3966\" style=\"width: 1326px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3966\" decoding=\"async\" class=\"size-full wp-image-3966\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql.png\" alt=\"Gudu SQLFlow \u30c7\u30fc\u30bf\u7cfb\u7d71\" width=\"1316\" height=\"450\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-200x68.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-300x103.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-400x137.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-600x205.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-768x263.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-800x274.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-1024x350.png 1024w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql-1200x410.png 1200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-paste-sql.png 1316w\" sizes=\"(max-width: 1316px) 100vw, 1316px\" \/><p id=\"caption-attachment-3966\" class=\"wp-caption-text\">Gudu SQLFlow \u30c7\u30fc\u30bf\u7cfb\u7d71<\/p><\/div>\n<p>\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u4e2d\u9593\u51e6\u7406\u30b9\u30c6\u30c3\u30d7\u3068\u8a73\u7d30\u60c5\u5831\u3092\u7121\u8996\u3057\u3066\u3001\u30bd\u30fc\u30b9 \u30c7\u30fc\u30bf\u3068\u30bf\u30fc\u30b2\u30c3\u30c8 \u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u8868\u793a\u3067\u304d\u307e\u3059\u3002\u4e0a\u306e\u56f3\u306b\u793a\u3059\u3088\u3046\u306a\u7c21\u6f54\u306a\u7d50\u679c\u3092\u5f97\u308b\u306b\u306f\u3001\u6b21\u306e\u8a2d\u5b9a\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<div id=\"attachment_3969\" style=\"width: 348px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3969\" decoding=\"async\" class=\"size-full wp-image-3969\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-setting.png\" alt=\"Gudu SQLFlow \u8a2d\u5b9a\" width=\"338\" height=\"285\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-setting-200x169.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-setting-300x253.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-setting.png 338w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><p id=\"caption-attachment-3969\" class=\"wp-caption-text\">Gudu SQLFlow \u8a2d\u5b9a<\/p><\/div>\n<p>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059 <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/sqlflow-ui-generated.json\">JSON \u306e\u7d50\u679c<\/a><\/strong> \u3055\u3089\u306b\u51e6\u7406\u3059\u308b\u305f\u3081\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002 (\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u683c\u7d0d\u30d1\u30b9: data -&gt; sqlflow -&gt; relationship)<\/p>\n<div id=\"attachment_3971\" style=\"width: 742px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3971\" decoding=\"async\" class=\"size-full wp-image-3971\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json.png\" alt=\"JSON \u3067\u306e Gudu SQLFlow \u30c7\u30fc\u30bf\u7cfb\u7d71\" width=\"732\" height=\"620\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json-200x169.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json-300x254.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json-400x339.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json-600x508.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/sqlflow-ui-download-json.png 732w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><p id=\"caption-attachment-3971\" class=\"wp-caption-text\">JSON \u3067\u306e Gudu SQLFlow \u30c7\u30fc\u30bf\u7cfb\u7d71<\/p><\/div>\n<h4>2.Gudu SQLFlow Rest API<\/h4>\n<p>\u30b3\u30fc\u30c9\u3067 Gudu SQLFlow Rest API \u3092\u547c\u3073\u51fa\u3057\u3066\u3001\u51e6\u7406\u304c\u5fc5\u8981\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u81ea\u52d5\u7684\u306b\u9001\u4fe1\u3057\u3001\u51e6\u7406\u7d50\u679c\u3092\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u53d6\u5f97\u3057\u3066\u304b\u3089\u3001\u30d3\u30b8\u30cd\u30b9\u8981\u4ef6\u306b\u5f93\u3063\u3066\u30b3\u30fc\u30c9\u3067\u8fd4\u3055\u308c\u305f\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u51e6\u7406\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>Gudu SQLFlow Rest API \u3092\u4f7f\u7528\u3059\u308b\u306b\u306f\u3001 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/%e8%b3%bc%e5%85%a5%e3%83%97%e3%83%ac%e3%83%9f%e3%82%a2%e3%83%a0%e3%82%a2%e3%82%ab%e3%82%a6%e3%83%b3%e3%83%88\/\">Gudu SQLFlow \u30af\u30e9\u30a6\u30c9 \u30d7\u30ec\u30df\u30a2\u30e0 \u30a2\u30ab\u30a6\u30f3\u30c8<\/a><\/strong>.\u3053\u3061\u3089\u304c <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/tree\/master\/api\">\u8a73\u7d30\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb<\/a><\/strong>.\u307e\u305f\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/sqlflow-%e3%82%aa%e3%83%b3%e3%83%97%e3%83%ac%e3%83%9f%e3%82%b9-%e3%83%90%e3%83%bc%e3%82%b8%e3%83%a7%e3%83%b3\/\">Gudu SQLFlow \u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u7248<\/a><\/strong> \u793e\u5185\u3067Rest API\u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n<ol>\n<li><strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/lineage_on_premise.py\">Python \u30b3\u30fc\u30c9<\/a><\/strong> \u4f01\u696d\u306b\u30c7\u30d7\u30ed\u30a4\u3055\u308c\u305f Gudu SQLFlow \u30b5\u30fc\u30d0\u30fc ( Gudu SQLFlow \u30aa\u30f3\u30d7\u30ec\u30df\u30b9 \u30b5\u30fc\u30d0\u30fc ) \u306b\u63a5\u7d9a\u3057\u3066\u3001\u30c7\u30fc\u30bf\u7cfb\u7d71\u306e\u7d50\u679c\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/li>\n<li><strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/lineage_cloud.py\">Python \u30b3\u30fc\u30c9<\/a><\/strong> SQLFlow \u30af\u30e9\u30a6\u30c9 \u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3057\u3066\u3001\u30c7\u30fc\u30bf\u7cfb\u7d71\u306e\u7d50\u679c\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>\u30af\u30ea\u30c3\u30af <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/data-lineage-json-by-python.json\">\u3053\u3053<\/a><\/strong> \u4e0a\u8a18\u306e Python \u30b3\u30fc\u30c9\u5206\u6790\u306b\u3088\u3063\u3066\u751f\u6210\u3055\u308c\u305f\u30c7\u30fc\u30bf\u7cfb\u7d71\u306e\u7d50\u679c\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<h4>3. Gudu SQLFlow Java \u30e9\u30a4\u30d6\u30e9\u30ea<\/h4>\n<p>\u307e\u305f\u3001 <strong><a href=\"https:\/\/www.gudusoft.com\/jp\/sqlflow-java-library-2\/\">Gudu SQLFlow Java \u30af\u30e9\u30b9 \u30e9\u30a4\u30d6\u30e9\u30ea<\/a><\/strong> SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u5206\u6790\u3057\u307e\u3059\u3002 Gudu SQLFlow Java \u30af\u30e9\u30b9 \u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u7528\u3059\u308b\u5229\u70b9\u306f\u3001Gudu SQLFlow \u30b5\u30fc\u30d0\u30fc \u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u306a\u304f\u3001\u72ec\u81ea\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u7c21\u5358\u306b\u7d71\u5408\u3067\u304d\u308b\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u306e Java \u30af\u30e9\u30b9 \u30e9\u30a4\u30d6\u30e9\u30ea\u306b\u4f9d\u5b58\u305b\u305a\u306b\u72ec\u7acb\u3057\u3066\u5b9f\u884c\u3067\u304d\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n<p>\u79c1\u305f\u3061\u306f\u4f5c\u6210\u3057\u307e\u3057\u305f <strong><a href=\"https:\/\/github.com\/sqlparser\/gsp_demo_java\/tree\/master\/src\/main\/java\/demos\/dlineage\">Java \u30c7\u30e2 \u30d7\u30ed\u30b0\u30e9\u30e0<\/a><\/strong> \u3053\u308c\u3092\u4f7f\u7528\u3057\u3066\u3001\u76f4\u63a5\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u3066\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u306e SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u6700\u4e0a\u4f4d\u306e\u9078\u629e\u30ea\u30b9\u30c8\u306b\u3088\u3063\u3066\u8fd4\u3055\u308c\u308b\u3059\u3079\u3066\u306e\u5217\u3068\u305d\u306e\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3092\u4f7f\u7528\u3057\u3066 Java \u30c7\u30e2\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-3986 aligncenter\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3.png\" alt=\"\" width=\"839\" height=\"75\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-200x18.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-300x27.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-400x36.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-600x54.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-768x69.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3-800x72.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/3.png 839w\" sizes=\"(max-width: 839px) 100vw, 839px\" \/><\/p>\n<p>\u751f\u6210\u3055\u308c\u305f\u30c7\u30fc\u30bf\u7cfb\u5217\u306f XML \u5f62\u5f0f\u3067\u4fdd\u5b58\u3055\u308c\u3001 <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/data-lineage-xml-by-java-dlineage.xml\">\u3053\u3053<\/a><\/strong> \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3053\u306e XML \u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n<h3>\u7d50\u8ad6<\/h3>\n<p>\u3053\u306e\u8a18\u4e8b\u3092\u304a\u8aad\u307f\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002 <strong>\u65b9\u6cd5<\/strong> <strong>\u8907\u96d1\u306a SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u53d6\u5f97\u3059\u308b<\/strong> <strong>1\u5206\u3067<\/strong>.\u30c7\u30fc\u30bf \u30ea\u30cd\u30fc\u30b8\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u77e5\u308a\u305f\u3044\u5834\u5408\u306f\u3001\u6b21\u306e\u30b5\u30a4\u30c8\u3092\u3054\u89a7\u306b\u306a\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002 <strong>Gudu SQLFlow<\/strong> \u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u516c\u5f0f\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4eca\u65e5\u306e\u5e02\u5834\u3067\u6700\u9ad8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u5206\u6790\u30c4\u30fc\u30eb\u306e 1 \u3064\u3068\u3057\u3066\u3001 <strong>Gudu SQLFlow<\/strong> SQL\u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u89e3\u6790\u3057\u3066\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092\u53d6\u5f97\u3057\u3001\u30d3\u30b8\u30e5\u30a2\u30eb\u8868\u793a\u3059\u308b\u3060\u3051\u3067\u306a\u304f\u3001\u30c7\u30fc\u30bf\u7cfb\u7d71\u3092CSV\u5f62\u5f0f\u3067\u63d0\u4f9b\u3057\u3066\u30d3\u30b8\u30e5\u30a2\u30eb\u8868\u793a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002 <strong>(2022 \u5e74 5 \u6708 22 \u65e5\u306b Ryan \u306b\u3088\u308a\u516c\u958b)<\/strong><\/p>\n<\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":27,"featured_media":3978,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,31],"tags":[55,138,131,139,75],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3940"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/comments?post=3940"}],"version-history":[{"count":45,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3940\/revisions"}],"predecessor-version":[{"id":3995,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/posts\/3940\/revisions\/3995"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media\/3978"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media?parent=3940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/categories?post=3940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/tags?post=3940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}