{"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\/ko\/%eb%b3%b5%ec%9e%a1%ed%95%9c-sql-%eb%ac%b8%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%eb%a5%bc-%ec%96%bb%ec%9c%bc%ec%84%b8%ec%9a%94\/","title":{"rendered":"\ubcf5\uc7a1\ud55c SQL \ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c 1\ubd84 \uc548\uc5d0 \uc5bb\ub294 \ubc29\ubc95? | 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>1\ubd84 \uc548\uc5d0 \ubcf5\uc7a1\ud55c SQL \ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uc73c\uc138\uc694<\/h2>\n<p><strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%ec%a7%80%ec%8b%9d-%ea%b8%b0%eb%b0%98\/\">\ub370\uc774\ud130 \uacc4\ubcf4<\/a><\/strong> \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4\uc5d0\uc11c \ub9e4\uc6b0 \uc911\uc694\ud55c \ub9c1\ud06c\uc785\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\uc758 \uc911\uc694\ud55c \uc5ed\ud560\uc5d0 \ub300\ud574\uc11c\ub294 \ub2e4\uc74c\uc744 \ucc38\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em><strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%ec%9d%98-%ec%a4%91%ec%9a%94%ec%84%b1\/\">\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc774\uace0 \uc65c \uc911\uc694\ud55c\uac00\uc694?<\/a><\/strong><\/em>. SQL \uc5b8\uc5b4\ub294 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \ub110\ub9ac \uc0ac\uc6a9\ub418\uace0 \uc788\uc73c\uba70, SQL \ubb38\uc5d0\ub294 \ud48d\ubd80\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc774\uace0 SQL \ubb38\uc5d0 \uc228\uaca8\uc9c4 \uc774\ub7ec\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ubc1c\uacac\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c\ub294 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <em><strong><a href=\"https:\/\/medium.com\/@han.yu_47442\/how-to-discover-data-lineage-in-sql-language-in-5-minutes-406ba357b3d9\">5\ubd84 \uc548\uc5d0 SQL \uc5b8\uc5b4\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ubc1c\uacac\ud558\ub294 \ubc29\ubc95?<\/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=\"\ubcf5\uc7a1\ud55c SQL \uba85\ub839\ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c 1\ubd84 \uc548\uc5d0 \uc5bb\ub294 \ubc29\ubc95\uc740?\" 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\">\ubcf5\uc7a1\ud55c SQL \uba85\ub839\ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c 1\ubd84 \uc548\uc5d0 \uc5bb\ub294 \ubc29\ubc95\uc740?<\/p><\/div>\n<p><span class=\"Y2IQFc\" lang=\"en\">\ubcf8 \ubb38\uc11c\uc5d0\uc11c\ub294 \uc8fc\ub85c UI, Rest API, Java \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/\">Gudu SQLFlow<\/a> <a href=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/11\/best-data-lineage-tools\/\">\ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d \ub3c4\uad6c<\/a><\/strong> \ubcf5\uc7a1\ud55c SQL \uba85\ub839\ubb38\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ube60\ub974\uac8c \uc5bb\uace0 \ud544\uc694\uc5d0 \ub530\ub77c \uc774\ub97c \uc790\uccb4 \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4 \ud50c\ub7ab\ud3fc\uc5d0 \ud1b5\ud569\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3>\uc57d\uac04 \ubcf5\uc7a1\ud55c SQL \ubb38<\/h3>\n<p>\uc774\uc81c Gudu SQLFlow\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \ube60\ub974\uac8c \uc5bb\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc8fc\uae30 \uc704\ud574 \ub2e4\uc74c\uc758 \uc57d\uac04 \ubcf5\uc7a1\ud55c SQL \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ucc98\ub9ac\ud560 \ub354 \ubcf5\uc7a1\ud55c SQL \ubb38\uc774\ub098 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uac00 \uc788\ub294 \uacbd\uc6b0 Gudu SQLFlow\uc640 \uac19\uc740 \ub370\uc774\ud130 \uacc4\ud1b5 \ubd84\uc11d \ub3c4\uad6c\uac00 \ub354\uc6b1 \uc2dc\uae09\ud569\ub2c8\ub2e4.<\/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>\uc6b0\ub9ac\uc758 \ubaa9\ud45c\ub294 \uc5b4\ub5a4 \uc5f4\uc774 \ucd5c\uc0c1\uc704 \uc120\ud0dd \ubaa9\ub85d\uc5d0 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc774\ub7ec\ud55c \uc5f4\uc758 \uc18c\uc2a4 \ub370\uc774\ud130\uac00 \uc5b4\ub5a4 \ub2e4\ub978 \ud14c\uc774\ube14\uacfc \uc5f4\uc5d0\uc11c \uc654\ub294\uc9c0 \uc544\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\uc0c1\uc801\uc778 \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc544\uc57c \ud569\ub2c8\ub2e4.<\/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=\"\ucd5c\uc0c1\uc704 \uc120\ud0dd \ubaa9\ub85d\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\" 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\">\ucd5c\uc0c1\uc704 \uc120\ud0dd \ubaa9\ub85d\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uacc4\ubcf4<\/p><\/div>\n<p><strong>\uc704\uc758 \uacb0\uacfc\ub97c \uc5bb\uc73c\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<\/strong><\/p>\n<ol>\n<li>data.*\uc5d0\uc11c * (\ubcc4\ud45c)\ub97c \uc790\ub3d9\uc73c\ub85c \ud655\uc7a5\ud558\uc5ec \ud574\ub2f9 \uc5f4\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uc120\ud0dd \ubaa9\ub85d\uc758 \uac01 \uc5f4\uc5d0 \ub300\ud574 \ub370\uc774\ud130 \uc18c\uc2a4 \ucd94\uc801\uc744 \uc218\ud589\ud558\uc5ec \uc6d0\ub798 \ud14c\uc774\ube14\uacfc \uc5f4\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uc774 \ud504\ub85c\uc138\uc2a4\ub294 \ucd5c\uc885 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ucc3e\uc744 \ub54c\uae4c\uc9c0 \uc5ec\ub7ec \uc218\uc900\uc758 \uc18c\uc2a4 \ucd94\uc801\uc774 \ud544\uc694\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h3>*\uc758 \uc790\ub3d9 \ud655\uc7a5\uc5d0 \uad00\ud558\uc5ec<\/h3>\n<p>\uc120\ud0dd \ubaa9\ub85d\uc758 * (\ubcc4\ud45c)\ub294 \uad00\uacc4\uc758 \ubaa8\ub4e0 \uc5f4\uc744 \ub098\ud0c0\ub0b4\uba70, \uc774\ub97c \ud2b9\uc815 \uc5f4 \uc774\ub984\uc73c\ub85c \ud655\uc7a5\ud574\uc57c \ud569\ub2c8\ub2e4. <span class=\"Y2IQFc\" lang=\"en\">\uc774 \uacbd\uc6b0 Gudu SQLFlow\ub294 SQL\uc5d0\uc11c \uc81c\uacf5\ub41c \ucee8\ud14d\uc2a4\ud2b8 \uc815\ubcf4\ub97c \uae30\ubc18\uc73c\ub85c \uc790\ub3d9\uc73c\ub85c \ud655\uc7a5\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/span>\ud558\uc9c0\ub9cc \ub54c\ub54c\ub85c SQL \ubb38 \uc790\uccb4\uac00 * \uc5f4\uc5d0 \uc5b4\ub5a4 \uc815\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uae30\uc5d0 \ucda9\ubd84\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub54c \ub2e4\uc74c\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/blog\/gsp-sqlenv\/\">Gudu SQLFlow\uc5d0 \uba54\ud0c0\ub370\uc774\ud130 \uc815\ubcf4 \uc81c\uacf5<\/a><\/strong> \ubcc4\ud45c\ub97c \uc62c\ubc14\ub974\uac8c \ud655\uc7a5\ud558\ub824\uba74<\/p>\n<p><strong>Gudu SQLFlow<\/strong> \ube60\ub974\uac8c \uc5bb\uc744 \uc218 \uc788\ub3c4\ub85d \ub3d5\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <strong>\ubcf5\uc7a1\ud55c SQL \ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4<\/strong>\ub2e4\uc591\ud55c \uacbd\uc6b0\uc5d0 \ud3b8\ub9ac\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4>1. Gudu SQLFlow UI<\/h4>\n<p>\uc9c1\uc811 \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 <strong><a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\">Gudu SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a><\/strong> \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \uc124\uce58\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc84\uc804\uc785\ub2c8\ub2e4. \uc0ac\uc6a9\ud558\uae30 \ub9e4\uc6b0 \uac04\ub2e8\ud569\ub2c8\ub2e4. \ucc98\ub9ac\ud560 SQL \ubb38\uc744 \uc785\ub825 \uc601\uc5ed\uc5d0 \uc9c1\uc811 \ubd99\uc5ec\ub123\uc740 \ub2e4\uc74c Visualize\ub97c \ud074\ub9ad\ud558\uba74 \ub429\ub2c8\ub2e4.<\/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 \ub370\uc774\ud130 \uacc4\ubcf4\" 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 \ub370\uc774\ud130 \uacc4\ubcf4<\/p><\/div>\n<p>\uc911\uac04 \ucc98\ub9ac \ub2e8\uacc4\uc640 \ub370\uc774\ud130 \uacc4\ud1b5\uc758 \uc790\uc138\ud55c \uc815\ubcf4\ub97c \ubb34\uc2dc\ud558\uace0 \uc18c\uc2a4 \ub370\uc774\ud130\uc640 \ub300\uc0c1 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ud45c\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc704 \uadf8\ub9bc\uacfc \uac19\uc774 \uac04\uacb0\ud55c \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c \uc124\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/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 \uc124\uc815\" 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 \uc124\uc815<\/p><\/div>\n<p>\ub2e4\uc6b4\ub85c\ub4dc \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/sqlflow-ui-generated.json\">JSON \uacb0\uacfc<\/a><\/strong> \ucd94\uac00 \ucc98\ub9ac\ub97c \uc704\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. (\ub370\uc774\ud130 \uacc4\ubcf4\uc758 \uc800\uc7a5 \uacbd\ub85c: data -&gt; sqlflow -&gt; relationships)<\/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=\"Gudu SQLFlow \ub370\uc774\ud130 Lineage in JSON\" 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\">Gudu SQLFlow \ub370\uc774\ud130 Lineage in JSON<\/p><\/div>\n<h4>2. Gudu SQLFlow Rest API<\/h4>\n<p>\ucf54\ub4dc\uc5d0\uc11c Gudu SQLFlow Rest API\ub97c \ud638\ucd9c\ud558\uc5ec \ucc98\ub9ac\uac00 \ud544\uc694\ud55c SQL \ubb38\uc744 \uc790\ub3d9\uc73c\ub85c \uc81c\ucd9c\ud558\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c \ucc98\ub9ac \uacb0\uacfc\ub97c \uc5bb\uc740 \ub2e4\uc74c \ube44\uc988\ub2c8\uc2a4 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ucf54\ub4dc\uc5d0\uc11c \ubc18\ud658\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Gudu SQLFlow Rest API\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \ub2e4\uc74c\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/%ed%94%84%eb%a6%ac%eb%af%b8%ec%97%84-%ea%b3%84%ec%a0%95-%ea%b5%ac%eb%a7%a4\/\">Gudu SQLFlow Cloud \ud504\ub9ac\ubbf8\uc5c4 \uacc4\uc815<\/a><\/strong>. \uc5ec\uae30\uc5d0 \uc788\uc2b5\ub2c8\ub2e4 <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/tree\/master\/api\">\uc790\uc138\ud55c \ud29c\ud1a0\ub9ac\uc5bc<\/a><\/strong>. \ub610\ub294 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">Gudu SQLFlow \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804<\/a><\/strong> \ud68c\uc0ac \ub0b4\ubd80\uc5d0\uc11c Rest API\ub97c \ud65c\uc6a9\ud558\uc138\uc694.<\/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\">\ud30c\uc774\uc36c \ucf54\ub4dc<\/a><\/strong> connects to the Gudu SQLFlow server ( Gudu SQLFlow on-premise server ) deployed in the enterprise to obtain data lineage results.<\/li>\n<li><strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/lineage_cloud.py\">\ud30c\uc774\uc36c \ucf54\ub4dc<\/a><\/strong> connects to the SQLFlow cloud server to obtain data lineage results.<\/li>\n<\/ol>\n<p>\ub538\uae4d \ud558\ub294 \uc18c\ub9ac <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/data-lineage-json-by-python.json\">\uc5ec\uae30<\/a><\/strong> \uc704\uc758 Python \ucf54\ub4dc \ubd84\uc11d\uc744 \ud1b5\ud574 \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4 \uacb0\uacfc\ub97c \ubcf4\ub824\uba74 \ub2e4\uc74c\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n<h4>3. Gudu SQLFlow Java \ub77c\uc774\ube0c\ub7ec\ub9ac<\/h4>\n<p>\ub610\ud55c \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-java-%eb%9d%bc%ec%9d%b4%eb%b8%8c%eb%9f%ac%eb%a6%ac-2\/\">Gudu SQLFlow Java \ud074\ub798\uc2a4 \ub77c\uc774\ube0c\ub7ec\ub9ac<\/a><\/strong> SQL \ubb38\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ubd84\uc11d\ud569\ub2c8\ub2e4. Gudu SQLFlow Java \ud074\ub798\uc2a4 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uc774\uc810\uc740 Gudu SQLFlow \uc11c\ubc84 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \uc124\uce58\ud560 \ud544\uc694\uac00 \uc5c6\uace0, \ud0c0\uc0ac Java \ud074\ub798\uc2a4 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc5d0 \uc758\uc874\ud558\uc9c0 \uc54a\uace0 \ub3c5\ub9bd\uc801\uc73c\ub85c \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub294 \uc790\uccb4 \ud504\ub85c\uc81d\ud2b8\uc5d0 \uc27d\uac8c \ud1b5\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc6b0\ub9ac\ub294 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4 <strong><a href=\"https:\/\/github.com\/sqlparser\/gsp_demo_java\/tree\/master\/src\/main\/java\/demos\/dlineage\">\uc790\ubc14 \ub370\ubaa8 \ud504\ub85c\uadf8\ub7a8<\/a><\/strong> \ub2f9\uc2e0\uc744 \uc704\ud574, \uadf8\ub798\uc11c \ub2f9\uc2e0\uc740 \uadf8\uac83\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc9c1\uc811 \ucef4\ud30c\uc77c\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubb38\uc11c\uc758 SQL \ubb38\uc758 \ucd5c\uc0c1\uc704 \uc120\ud0dd \ubaa9\ub85d\uc5d0\uc11c \ubc18\ud658\ub41c \ubaa8\ub4e0 \uc5f4\uacfc \ud574\ub2f9 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc5bb\uc73c\ub824\uba74 \ub2e4\uc74c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec Java \ub370\ubaa8\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/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>\uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub294 XML \ud615\uc2dd\uc73c\ub85c \uc800\uc7a5\ub418\uba70, \ud074\ub9ad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong><a href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/demos\/top-level-select-list\/data-lineage-xml-by-java-dlineage.xml\">\uc5ec\uae30<\/a><\/strong> \uc774 XML \ud30c\uc77c\uc744 \uc5f4\ub824\uba74.<\/p>\n<h3>\uacb0\ub860<\/h3>\n<p>\uc800\ud76c \uae30\uc0ac\ub97c \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc774 \uae30\uc0ac\uac00 \uc5ec\ub7ec\ubd84\uc774 \ub354 \uc798 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. <strong>\uc5b4\ub5bb\uac8c<\/strong> <strong>\ubcf5\uc7a1\ud55c SQL \ubb38\uc758 \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \uc5bb\uc73c\uc138\uc694<\/strong> <strong>1\ubd84 \uc548\uc5d0<\/strong>\ub370\uc774\ud130 \uacc4\ubcf4\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \ub2e4\uc74c\uc744 \ubc29\ubb38\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uacf5\uc2dd \ud648\ud398\uc774\uc9c0\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/p>\n<p>\uc624\ub298\ub0a0 \uc2dc\uc7a5\uc5d0\uc11c \uac00\uc7a5 \ub6f0\uc5b4\ub09c \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d \ub3c4\uad6c \uc911 \ud558\ub098\ub85c\uc11c, <strong>Gudu SQLFlow<\/strong> SQL \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uace0, \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uace0, \uc2dc\uac01\uc801 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \ubfd0\ub9cc \uc544\ub2c8\ub77c, \uc0ac\uc6a9\uc790\uac00 CSV \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc81c\uacf5\ud558\uace0 \uc2dc\uac01\uc801 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. <strong>(2022\ub144 5\uc6d4 22\uc77c Ryan\uc774 \uac8c\uc2dc)<\/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\/ko\/wp-json\/wp\/v2\/posts\/3940"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=3940"}],"version-history":[{"count":45,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3940\/revisions"}],"predecessor-version":[{"id":3995,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3940\/revisions\/3995"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/3978"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=3940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=3940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}