{"id":6746,"date":"2026-07-12T02:05:28","date_gmt":"2026-07-12T10:05:28","guid":{"rendered":"https:\/\/www.gudusoft.com\/column-level-data-lineage\/"},"modified":"2026-07-13T19:02:19","modified_gmt":"2026-07-14T03:02:19","slug":"column-level-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ec%bb%ac%eb%9f%bc-%ec%88%98%ec%a4%80-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"\uceec\ub7fc \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4: \ubb34\uc5c7\uc774\uba70 \ud14c\uc774\ube14 \uc218\uc900\ub9cc\uc73c\ub85c\ub294 \ubd80\uc871\ud55c \uc774\uc720"},"content":{"rendered":"<p><strong>\uceec\ub7fc \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \ucffc\ub9ac, \ubdf0 \ub610\ub294 \ubcf4\uace0\uc11c\uc758 \ubaa8\ub4e0 \ucd9c\ub825 \uc5f4\uc744 \ud574\ub2f9 \ucffc\ub9ac, \ubdf0 \ub610\ub294 \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud55c \uc815\ud655\ud55c \uc18c\uc2a4 \uc5f4\uc5d0 \ub9e4\ud551\ud558\uba70, \uadf8 \uacfc\uc815\uc5d0\uc11c \uc801\uc6a9\ub41c \ubaa8\ub4e0 \ubcc0\ud658(\ud568\uc218, \ud615\ubcc0\ud658, \uc870\uc778, \uc9d1\uacc4 \ubc0f \ud544\ud130)\ub3c4 \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ud14c\uc774\ube14 \uc218\uc900 \uacc4\ubcf4\ub294 &quot;\ud14c\uc774\ube14&quot;\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. <code>\uba85\ub839<\/code> \uc0ac\ub8cc \ud14c\uc774\ube14 <code>\uc218\uc775 \ubcf4\uace0\uc11c<\/code>&quot;, \uceec\ub7fc \uc218\uc900 \uacc4\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.&quot;<code>\uc218\uc775 \ubcf4\uace0\uc11c.\ucd1d\uc561<\/code> ~\uc774\ub2e4 <code>SUM(\uc8fc\ubb38 \uc218\ub7c9)<\/code>\ud544\ud130\ub9c1\ub428 <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code> \uadf8\ub9ac\uace0 \uadf8\ub8f9\ud654\ub428 <code>\uace0\uac1d \uc9c0\uc5ed<\/code>\uc774\ub294 \uc601\ud5a5 \ubd84\uc11d, \ub514\ubc84\uae45 \ubc0f \uac10\uc0ac \ub2f5\ubcc0\uc774 \uadfc\uc0ac\uce58\uac00 \uc544\ub2cc \uc815\ud655\uc131\uc744 \ud655\ubcf4\ud560 \uc218 \uc788\ub294 \uc138\ubd84\uc131\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"gd-stats\">\n<div class=\"gd-stat\"><b>\uceec\ub7fc \ub808\ubca8<\/b><span>\ud14c\uc774\ube14 \uc218\uc900\ubfd0\ub9cc \uc544\ub2c8\ub77c<\/span><\/div>\n<div class=\"gd-stat\"><b>\uc9c1\uc811 + \uac04\uc811<\/b><span>fdd \ubc0f fddi \uacc4\ubcf4<\/span><\/div>\n<div class=\"gd-stat\"><b>39<\/b><span>SQL \ubc29\uc5b8 \ud30c\uc2f1\ub428<\/span><\/div>\n<div class=\"gd-stat\"><b>\uacf5\uc804<\/b><span>SQL\uc744 \uc77d\uc9c0, \uc808\ub300 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n<\/div>\n\n\n\n<p>\uc774 \ud398\uc774\uc9c0\uc5d0\uc11c\ub294 \uc6a9\uc5b4\ub97c \uc815\uc758\ud558\uace0, CTE, \uc870\uc778 \ubc0f \uc9d1\uacc4\ub97c \uc0ac\uc6a9\ud558\ub294 \uc2e4\uc81c \ucffc\ub9ac\ub97c \ud1b5\ud574 \ud558\ub098\uc758 \ucd9c\ub825 \uc5f4\uc744 \uc0b4\ud3b4\ubcf4\uace0, \uc774\ub7ec\ud55c \uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\ub294 \ub370 \ud328\ud134 \ub9e4\uce6d\uc774 \uc544\ub2cc \uc2dc\ub9e8\ud2f1 SQL \uad6c\ubb38 \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uc774\uc720\ub97c \uc124\uba85\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uacc4\ubcf4\ub77c\ub294 \uac1c\ub150\uc774 \uc0dd\uc18c\ud558\ub2e4\uba74 \uc774 \ud398\uc774\uc9c0\ubd80\ud130 \uc2dc\uc791\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80\/\">\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc774\uba70 \uc65c \uc911\uc694\ud55c\uac00<\/a>\uadf8\ub7f0 \ub2e4\uc74c \uc5ec\uae30\ub85c \ub3cc\uc544\uc640\uc11c \uc5f4\ubcc4 \uc138\ubd80 \uc815\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694.<\/p>\n\n\n\n<div class=\"wp-block-group gd-callout is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c1\uc811 SQL\uc5d0\uc11c \ud655\uc778\ud574 \ubcf4\uc138\uc694:<\/strong> \uad81\uae08\ud55c \uc0ac\ud56d\uc744 \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=column-level-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \ucd9c\ub825 \uc5f4\uc744 \ud074\ub9ad\ud558\uba74 \uc804\uccb4 \uc0c1\uc704 \uacbd\ub85c\uac00 \uac15\uc870 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \ubb34\ub8cc \ud2f0\uc5b4\ub9cc\uc73c\ub85c\ub3c4 \uc774 \uacfc\uc815\uc744 \ub530\ub77c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uceec\ub7fc \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\uc5d0\ub294 \uc5b4\ub5a4 \uae30\ub85d\uc774 \uc788\ub098\uc694?<\/h2>\n\n\n\n<p>\ubb38\uc7a5\uc774 \uc4f0\uac70\ub098 \ubc18\ud658\ud558\ub294 \ubaa8\ub4e0 \uc5f4\uc5d0 \ub300\ud574 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \uadf8\ub798\ud504\ub294 \ub2e4\uc74c \uc138 \uac00\uc9c0\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uc6d0\ubcf8 \uc5f4:<\/strong> \ucd9c\ub825\uc73c\ub85c \uc804\ub2ec\ub418\ub294 \ubb3c\ub9ac\uc801 \uc5f4\uc758 \uac12\uc740 CTE, \uc11c\ube0c\ucffc\ub9ac, \ubdf0, \uc784\uc2dc \ud14c\uc774\ube14\uacfc \uac19\uc740 \uc5ec\ub7ec \uc911\uac04 \uacc4\uce35\uc744 \uac70\uccd0 \uacb0\uc815\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcc0\ud658:<\/strong> \uacbd\ub85c\uc5d0 \uc801\uc6a9\ub41c \uc5f0\uc0b0, \uc608: <code>\ud569\uc9d1\ud569()<\/code>, <code>\uae41\uc2a4()<\/code>, <code>\uc0ac\ub840<\/code> \ud45c\ud604\uc2dd, \ubb38\uc790\uc5f4 \ud568\uc218 \ubc0f \uc9d1\ud569 \uc5f0\uc0b0\uc790 \ub4f1 <code>\ub178\ub3d9 \uc870\ud569<\/code>.<\/li>\n<li><strong>\uad00\uacc4 \uc720\ud615:<\/strong> \uc18c\uc2a4 \uc5f4\uc758 \uac12\uc774 \uc2e4\uc81c\ub85c \ucd9c\ub825\uc5d0 \ubc18\uc601\ub418\ub294\uc9c0(\uc9c1\uc811 \uacc4\ubcf4) \uc544\ub2c8\uba74 \ud544\ud130, \uc870\uc778 \ub610\ub294 \uadf8\ub8f9\ud654\ub97c \ud1b5\ud574 \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294\uc9c0(\uac04\uc811 \uacc4\ubcf4)\ub97c \uad6c\ubd84\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ub3c4\uad6c\ub294 \uc774 \ubd80\ubd84\uc744 \uc0dd\ub7b5\ud558\uae30 \ub54c\ubb38\uc5d0 \uc544\ub798\uc5d0\uc11c \uc774 \ucc28\uc774\uc810\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc124\uba85\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\ud14c\uc774\ube14 \uc218\uc900\uc758 \uacc4\ubcf4 \uc815\ubcf4\ub9cc\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc740 \uc774\uc720<\/h2>\n\n\n\n<p>\ud14c\uc774\ube14 \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc0dd\uc131 \ube44\uc6a9\uc774 \uc800\ub834\ud558\uace0 \ucd08\uae30 \ubc29\ud5a5 \uc124\uc815\uc5d0 \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc5b4\ub5a4 \ud14c\uc774\ube14\uacfc \ubdf0\uac00 \uc5b4\ub5a4 \ub370\uc774\ud130\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4 \uc5ed\ud560\uc744 \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ubb38\uc81c\ub294 \ub370\uc774\ud130 \ud300\uc774 \uc2e4\uc81c\ub85c \ub2f5\uc744 \uc5bb\uc5b4\uc57c \ud558\ub294 \uc9c8\ubb38\uc740 \uceec\ub7fc \uc218\uc900\uc758 \uc9c8\ubb38\uc774\ub77c\ub294 \uc810\uc774\uba70, \ud14c\uc774\ube14 \uc218\uc900\uc758 \uc138\ubd84\ud654\ub294 \uc9c0\ub098\uce58\uac8c \uadfc\uc0ac\uce58\ub97c \uc0ac\uc6a9\ud558\uac8c \ub9cc\ub4e0\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc9c8\ubb38<\/th><th>\ud45c \uc218\uc900 \ub2f5\ubcc0<\/th><th>\uceec\ub7fc \uc218\uc900 \ub2f5\ubcc0<\/th><\/tr><\/thead><tbody>\n<tr><td>\uc774\ub984\uc744 \ubc14\uafb8\uba74 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub098\uc694? <code>\uace0\uac1d \uc774\uba54\uc77c<\/code>?<\/td><td>\uc77d\ub294 \ubaa8\ub4e0 \uac1d\uccb4 <code>\uace0\uac1d<\/code> \u2014 \ud754\ud788 \uc218\uc2ed \uac74\uc758 \uc624\ud0d0\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/td><td>\ucc38\uc870\ud558\ub294 \uacac\ud574, \uc808\ucc28 \ubc0f \ubcf4\uace0\uc11c\ub9cc \ud574\ub2f9\ub429\ub2c8\ub2e4. <code>\uc774\uba54\uc77c<\/code> \uad6c\uccb4\uc801\uc73c\ub85c<\/td><\/tr>\n<tr><td>\ub300\uc2dc\ubcf4\ub4dc\uc5d0 \ud45c\uc2dc\ub41c \uc774 \uc798\ubabb\ub41c \ubc88\ud638\ub294 \uc5b4\ub514\uc5d0\uc11c \uc628 \uac83\uc785\ub2c8\uae4c?<\/td><td>\u201c\uc774 \ub124 \uac1c\uc758 \ud14c\uc774\ube14 \uc0c1\ub958 \uc5b4\ub518\uac00\uc5d0\u201d<\/td><td>\ub300\uc2dc\ubcf4\ub4dc \ud544\ub4dc\uc5d0\uc11c \ubb3c\ub9ac\uc801 \uc18c\uc2a4 \uc5f4\uae4c\uc9c0 \uc774\uc5b4\uc9c0\ub294 \uc815\ud655\ud55c \ud45c\ud604\uc2dd \uccb4\uc778<\/td><\/tr>\n<tr><td>\uc5b4\ub5a4 \ucd9c\ub825\ubb3c\uc5d0 \uac1c\uc778 \uc2dd\ubcc4 \uc815\ubcf4(PII)\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\uae4c? <code>ssn<\/code>?<\/td><td>\uc6d0\ubcf8 \ud14c\uc774\ube14 \uc774\ud6c4\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc740 (\uc6d0\ubcf8 \ud14c\uc774\ube14 \uc5ec\ubd80\uc640 \uad00\uacc4\uc5c6\uc774) <code>ssn<\/code> \uc804\ud30c\ud558\ub2e4<\/td><td>\uc815\ud655\ud55c \uc5f4 \uc138\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>ssn<\/code> \uc2e4\uc81c \uac00\uce58\ub294 \ub3c4\ub2ec\ud569\ub2c8\ub2e4<\/td><\/tr>\n<tr><td>\uc774 \uc2a4\ud14c\uc774\uc9d5 \uc5f4\uc744 \uc0ad\uc81c\ud560 \uc218 \uc788\uc744\uae4c\uc694?<\/td><td>\uc54c \uc218 \uc5c6\uc74c \u2014 \ud45c\uac00 \ucc38\uc870\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c, \ucc38\uc870\ub418\uc9c0 \uc54a\uc558\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/td><td>\uc608, \ud558\uc704 \uc5f4\uc5d0\uc11c \uc9c1\uc811 \ub610\ub294 \uac04\uc811\uc801\uc73c\ub85c \ud574\ub2f9 \uac12\uc744 \uc77d\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc785\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p><strong class=\"gd-lead-in\">\uc624\ud0d0\uc73c\ub85c \uc778\ud55c \ube44\uc6a9\uc740 \uc774\ub860\uc801\uc778 \ubb38\uc81c\uac00 \uc544\ub2d9\ub2c8\ub2e4.<\/strong> \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc73c\ub85c \uc778\ud574 \ud14c\uc774\ube14 \uc218\uc900\uc5d0\uc11c 40\uac1c\uc758 \ud558\uc704 \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \ubcc0\uacbd \uc0ac\ud56d\uc774 \ud45c\uc2dc\ub418\uc5c8\uc9c0\ub9cc \uc2e4\uc81c\ub85c \ud574\ub2f9 \uc5f4\uc744 \uc0ac\uc6a9\ud558\ub294 \ub300\uc2dc\ubcf4\ub4dc\uac00 3\uac1c\ubfd0\uc774\ub77c\uba74 \ub098\uba38\uc9c0 37\uac1c\ub294 \ubd88\ud544\uc694\ud558\uac8c \uc7ac\ud14c\uc2a4\ud2b8\ub418\uac70\ub098, \ub354 \ub098\uc05c \uacbd\uc6b0 \ud300\uc774 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\ub97c \ubb34\uc2dc\ud558\uac8c \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\ud655\uc131\uc774 \ub370\uc774\ud130 \uacc4\ubcf4\uc758 \uc2e0\ub8b0\uc131\uc744 \uc88c\uc6b0\ud558\uba70, \uadf8 \uc815\ud655\uc131\uc740 \uc5f4 \uc218\uc900\uc5d0\uc11c \uacb0\uc815\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: CTE, \uc870\uc778 \ubc0f \uc9d1\uacc4\ub97c \ud1b5\ud574 \ud558\ub098\uc758 \uc5f4\uc744 \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uac04\ub2e8\ud558\uc9c0\ub9cc \ud604\uc2e4\uc801\uc778 \uc9c8\ubb38\uc785\ub2c8\ub2e4. \ubaa9\ud45c\ub294 \uc815\ud655\ud788 \uc5b4\ub514\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294\uc9c0 \ucd94\uc801\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. <code>\ucd1d\uc218\uc775<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ucd5c\uadfc \uc8fc\ubb38 \ud14c\uc774\ube14(recent_orders)\uc5d0\uc11c o.order_id, o.customer_id, o.amount, o.status \uac12\uc744 \uc120\ud0dd\ud558\uace0, o.order_date\uac00 &#039;2026-01-01&#039; \uc774\uc0c1\uc778 \uc8fc\ubb38 \ud14c\uc774\ube14(orders)\uc758 c.region\uacfc r.amount\uc758 \ud569\uacc4\ub97c \ucd1d \uc218\uc775(total_revenue)\uc73c\ub85c \uacc4\uc0b0\ud55c \ud6c4, c.customer_id\uc640 r.customer_id\uac00 \uac19\uc740 \uace0\uac1d \ud14c\uc774\ube14(customers c)\uc744 \uc870\uc778\ud569\ub2c8\ub2e4. \uc774\ub54c r.status \uac12\uc774 &#039;COMPLETED&#039;\uc778 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uace0\uac1d \ud14c\uc774\ube14\uc744 c.region\uc73c\ub85c \uadf8\ub8f9\ud654\ud569\ub2c8\ub2e4.<\/code><\/pre>\n\n\n\n<p>\ud574\uacb0 \uc911 <code>\ucd1d\uc218\uc775<\/code> \uc138 \ubc88\uc758 \ud649\uc774 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n\n\n\n<ol><li><code>\ucd1d\uc218\uc775<\/code> \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ub429\ub2c8\ub2e4. <code>\ud569\uacc4(r.amount)<\/code>\uadf8\ub7ec\ubbc0\ub85c \uadf8 \uac12\uc740 \ud574\ub2f9 \uc5f4\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc591<\/code> \ubcc4\uce6d\uc774 \uc9c0\uc815\ub41c \uad00\uacc4 <code>\uc544\ub974 \uc790\ud615<\/code>\uc9d1\uacc4 \ud568\uc218\ub97c \ud1b5\uacfc\ud588\uc2b5\ub2c8\ub2e4.<\/li>\n<li><code>\uc544\ub974 \uc790\ud615<\/code> \uc774\uac83\uc740 \ud45c\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uc774\uac83\uc740 CTE\uc785\ub2c8\ub2e4. <code>\ucd5c\uadfc \uc8fc\ubb38<\/code>\uc758 <code>\uc591<\/code> \uceec\ub7fc\uc740 \ud1b5\uacfc\uc785\ub2c8\ub2e4. <code>\uc8fc\ubb38 \uae08\uc561<\/code>\ubcc4\uce6d, CTE \ubc0f \uc5f4 \ud22c\uc601\uc740 \ubaa8\ub450 \ubb3c\ub9ac\uc801 \uc18c\uc2a4\ub97c \ud30c\uc545\ud558\uae30 \uc804\uc5d0 \ud574\uacb0\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li>\ub530\ub77c\uc11c \uc644\uc804\ud55c \uc9c1\uacc4 \ud608\ud1b5\uc740 \ud558\ub098\uc758 \ubb3c\ub9ac\uc801 \uae30\ub465\uc73c\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4. <code>\uc8fc\ubb38 \uae08\uc561<\/code> \u2192 <code>\ucd5c\uadfc \uc8fc\ubb38 \uae08\uc561<\/code> \u2192 <code>\ud569\uc9d1\ud569()<\/code> \u2192 <code>\ucd1d\uc218\uc775<\/code>.<\/li><\/ol>\n\n\n\n<p>\ud558\uc9c0\ub9cc \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\uba74\uc11c\ub3c4 \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \ub2e4\uc12f \uac1c\uc758 \uc694\uc18c\uac00 \ub354 \uc788\uc2b5\ub2c8\ub2e4. <code>\uc8fc\ubb38.\uc8fc\ubb38_\ub0a0\uc9dc<\/code> CTE \ub0b4\ubd80\uc758 \ud589\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4. <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code> \uc678\ubd80\uc5d0\uc11c \ub2e4\uc2dc \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4. <code>\uc5b4\ub514<\/code>, <code>\uc8fc\ubb38.\uace0\uac1d_ID<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d.\uace0\uac1d_ID<\/code> \uc5b4\ub5a4 \ud589\ub4e4\uc744 \uacb0\ud569\ud560\uc9c0 \uacb0\uc815\ud558\uace0 <code>\uace0\uac1d \uc9c0\uc5ed<\/code> \ud589\uc744 \uc9d1\uacc4 \ubc84\ud0b7\uc73c\ub85c \uadf8\ub8f9\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uacb0\uc815\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud56d\ubaa9 \uc911 \uc5b4\ub290 \ud558\ub098\ub77c\ub3c4 \uc758\ubbf8\ub860\uc744 \ubcc0\uacbd\ud558\uba74 <code>\ucd1d\uc218\uc775<\/code> \uac12\uc774 \ucd9c\ub825 \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub354\ub77c\ub3c4 \ubcc0\uacbd \uc0ac\ud56d\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \ud558\uba74 &quot;\uc774 \ucffc\ub9ac\ub294 \ub2e4\uc74c\uc744 \uac74\ub4dc\ub9bd\ub2c8\ub2e4&quot;\ub77c\ub294 \uacb0\uacfc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <code>\uba85\ub839<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d<\/code>&quot;\uc5f4 \uc218\uc900 \uacc4\ubcf4\ub294 \uc5b4\ub5a4 \uc5f4\uc774 \uac12\uc744 \uac00\uc9c0\uace0 \uc788\ub294\uc9c0, \uadf8\ub9ac\uace0 \uadf8 \uac12\uc744 \uad00\ub9ac\ud558\ub294 \ub2e4\uc12f \uac1c\uc758 \uc5f4\uc774 \ubb34\uc5c7\uc778\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4.&quot;<\/p>\n\n\n\n<div class=\"wp-block-group gd-panel-navy is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uc9c1\uc811 \ud608\ud1b5\uacfc \uac04\uc811 \ud608\ud1b5\uc758 \ucc28\uc774: fdd\/fddi \uad6c\ubd84\ubc95<\/h2>\n\n\n\n<p>\uc774 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uad00\uacc4\ub294 \uac01\uac01 \ub2e4\ub978 \uc774\ub984\uc73c\ub85c \ubd88\ub9b4 \ub9cc\ud569\ub2c8\ub2e4. Gudu SQLFlow\uc758 \uacc4\ubcf4 \ubaa8\ub378\uc5d0\uc11c\ub294, <strong>\uc9c1\uc811 \ub370\uc774\ud130 \ud750\ub984<\/strong> (\ud45c\uc2dc\ub428) <code>fdd<\/code>)\ub294 \uc18c\uc2a4 \uc5f4\uc758 \uac12\uc774 \ud568\uc218, \ud615\ubcc0\ud658 \ub610\ub294 \uc9d1\uacc4\uc5d0 \uc758\ud574 \ubcc0\ud658\ub418\uc5b4 \ub300\uc0c1 \uc5f4\ub85c \uc804\ub2ec\ub428\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. <strong>\uac04\uc811 \ub370\uc774\ud130 \ud750\ub984<\/strong> (\ud45c\uc2dc\ub428) <code>fddi<\/code>)\ub294 \uc18c\uc2a4 \uc5f4\uc774 \uac12\uc744 \uc81c\uacf5\ud558\uc9c0 \uc54a\uace0 \ub300\uc0c1\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc0ac\uc6a9\ub41c \uc5f4 <code>\uc5b4\ub514<\/code> \uc220\uc5b4, <code>\uac00\uc785\ud558\ub2e4<\/code> \uc815\ud669, <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code> \ud0a4 \ubc0f \uc720\uc0ac\ud55c \uc870\ud56d.<\/p>\n\n\n\n<p>SQLFlow\ub294 \uc774\ub7ec\ud55c \uc694\uc18c\ub4e4\uc744 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uac01\uac01 \ubcc4\ub3c4\ub85c \ud1a0\uae00 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc73c\ub85c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. \uac04\uc811 \uacc4\ubcf4\ub97c \ub044\uba74 \uc21c\uc218\ud55c \uac12 \ucd9c\ucc98\ub9cc \ubcfc \uc218 \uc788\ub294\ub370, \uc774\ub294 \uac10\uc0ac\uc790\uac00 \uaddc\uc81c \ubcf4\uace0\uc11c\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4 \ud544\ub4dc\uac00 \ud3ec\ud568\ub418\ub294\uc9c0 \uc785\uc99d\ud560 \ub54c \ud544\uc694\ud55c \ubcf4\uae30\uc785\ub2c8\ub2e4. \ubc18\ub300\ub85c, \uc804\uccb4 \uc601\ud5a5 \ubc94\uc704\ub97c \ubcf4\ub824\uba74 \ucf1c\uc57c \ud569\ub2c8\ub2e4. \uc774\ub294 \uc5d4\uc9c0\ub2c8\uc5b4\uac00 \uc5f4\uc744 \uc218\uc815\ud558\uae30 \uc804\uc5d0 \ud544\uc694\ud55c \ubcf4\uae30\uc778\ub370, \ud544\ud130 \uc5f4\uc744 \uc0ad\uc81c\ud558\uba74 \ubaa8\ub4e0 \ud558\uc704 \uc9d1\uacc4\uac00 \uc790\ub3d9\uc73c\ub85c \ubcc0\uacbd\ub418\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc7c1 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \uc804\ud600 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc9c1\uc811 \ud750\ub984\ub9cc \ubcf4\uace0\ud558\uc5ec \uc2e4\uc81c \uc601\ud5a5\uc744 \ub193\uce58\uac70\ub098, \ubaa8\ub4e0 \uac83\uc744 \ud558\ub098\ub85c \ubb36\uc5b4 \uc5f4 \uc218\uc900\uc73c\ub85c \uc62e\uaca8 \ub193\uc558\ub358 \uc624\ud0d0\uc744 \ub2e4\uc2dc \ubc1c\uc0dd\uc2dc\ud0a4\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc774\uac83\uc774 \uc815\uaddc \ud45c\ud604\uc2dd\uc774 \uc544\ub2cc \uc758\ubbf8\ub860\uc801 \uad6c\ubb38 \ubd84\uc11d\uc744 \ud544\uc694\ub85c \ud558\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>\ud14c\uc774\ube14 \uc774\ub984\uacfc \uceec\ub7fc \uc774\ub984\uc744 SQL \ud14d\uc2a4\ud2b8\uc5d0\uc11c \ud328\ud134 \ub9e4\uce6d\ud558\uc5ec \uacc4\ubcf4\ub97c \ucd94\ucd9c\ud558\ub824\ub294 \uc720\ud639\uc774 \uc788\uc9c0\ub9cc, \uc774\ub7ec\ud55c \uc811\uadfc \ubc29\uc2dd\uc740 \uc2e4\uc81c \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c \ud754\ud788 \ubcfc \uc218 \uc788\ub294 SQL \uad6c\ubb38\uacfc \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \ubb38\uc81c\uc810\uc744 \ub4dc\ub7ec\ub0c5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\ubcc4\uc758 \ud33d\ucc3d.<\/strong> <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc5f4 \uc774\ub984\uc744 \uc804\ud600 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc5b4\ub5a4 \uc5f4\uc774 \uc804\ub2ec\ub418\ub294\uc9c0\ub294 \ubd84\uc11d \uc2dc\uc810\uc758 \uae30\ubcf8 \uad00\uacc4 \uc2a4\ud0a4\ub9c8\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c0\uba70, \uc870\uc778\uc758 \uacbd\uc6b0 \uc870\uc778\ub41c \ubaa8\ub4e0 \uad00\uacc4\uc758 \uacb0\ud569\ub41c \uc2a4\ud0a4\ub9c8\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. \ud574\uacb0 <code>*<\/code> \uba54\ud0c0\ub370\uc774\ud130\uc640 \ubc94\uc704 \uaddc\uce59\uc774 \ud544\uc694\ud558\uba70, \ud14d\uc2a4\ud2b8 \ud328\ud134\uc73c\ub85c\ub294 \uc5f4 \ubaa9\ub85d\uc744 \uc0dd\uc131\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcf4\uae30 \ud574\uc0c1\ub3c4.<\/strong> \ucffc\ub9ac\uac00 \uc77d\ud790 \ub54c <code>v_sales.net_amount<\/code>\uc9c4\uc815\ud55c \uacc4\ubcf4\ub294 \ubdf0\uc758 \uc815\uc758\ub97c \ud1b5\ud574 \uc774\uc5b4\uc9c0\uba70, \ubdf0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub2e4\ub978 \ubdf0 \uc704\uc5d0 \uc313\uc785\ub2c8\ub2e4. \ubd84\uc11d\uae30\ub294 \uac01 \uc815\uc758\ub97c \uc7ac\uadc0\uc801\uc73c\ub85c \ud655\uc7a5\ud558\uace0 \uc5f4 \ub9e4\ud551\uc744 \uc5f0\uacb0\ud574\uc57c \ud558\ub294\ub370, \uc774\ub294 \ubb38\uc790\uc5f4\uc774 \uc544\ub2cc \ud574\uacb0\ub41c \uc758\ubbf8 \ubaa8\ub378\uc5d0 \ub300\ud55c \uc791\uc5c5\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>\ubc94\uc704\uc640 \ubaa8\ud638\uc131.<\/strong> \uc790\uaca9 \ubbf8\ub2ec \uce7c\ub7fc\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>\uc0c1\ud0dc<\/code> \uc138 \ud14c\uc774\ube14\uc744 \uc870\uc778\ud560 \ub54c, \ud574\ub2f9 \ud14c\uc774\ube14\uc740 SQL\uc758 \ubc94\uc704 \uc9c0\uc815 \uaddc\uce59\uacfc \ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8\uc5d0 \ub530\ub77c \uc815\ud655\ud788 \ud558\ub098\uc758 \uad00\uacc4\uc5d0 \uc18d\ud558\uac8c \ub429\ub2c8\ub2e4. \uc798\ubabb \ucd94\uce21\ud558\uba74 \uacc4\ubcf4 \uadf8\ub798\ud504\uac00 \uc870\uc6a9\ud788 \uc190\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ud45c\ud604.<\/strong> <code>COALESCE(ax, by)<\/code>, <code>\uc0ac\ub840<\/code> \ubd84\uae30 \ubc0f \uc708\ub3c4\uc6b0 \ud568\uc218\ub294 \uac01\uac01 \uc11c\ub85c \ub2e4\ub978 \uae30\uc5ec \uc5f4 \uc9d1\ud569\uc744 \uc815\uc758\ud569\ub2c8\ub2e4. \uc624\uc9c1 \uc2e4\uc81c \ud45c\ud604\uc2dd \ud2b8\ub9ac\ub9cc\uc774 \uc774\ub97c \ud3ec\ucc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubc29\uc5b8.<\/strong> \uc624\ub77c\ud074\uc758 <code>\uc5f0\uacb0 \ubc29\ubc95<\/code>T-SQL\uc758 <code>\uc0b0\ucd9c<\/code> \uc870\ud56d, BigQuery\uc758 <code>\uc81c\uc678\ud558\uace0<\/code> \ubcc4\ud45c \ubaa9\ub85d\uc5d0\uc11c \uac01 \ubc29\uc5b8\uc740 \uc77c\ubc18\uc801\uc778 ANSI \ubb38\ubc95\uc774 \uad6c\ubb38 \ubd84\uc11d\uc5d0 \uc2e4\ud328\ud558\ub294 \uad6c\ubb38\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 \ud558\ub098\uc758 \ucd5c\uc18c \uacf5\ud1b5\ubd84\ubaa8 \ubb38\ubc95 \ub300\uc2e0 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \uad6c\ubb38 \ubd84\uc11d\uae30\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc694\ucee8\ub300, \uc815\ud655\ud55c \uceec\ub7fc \uc218\uc900\uc758 \ucf54\ub4dc \uacc4\ubcf4\ub294 \ucef4\ud30c\uc77c\ub7ec \ubb38\uc81c\uc785\ub2c8\ub2e4. SQLFlow\ub294 2000\ub144\ub300 \uc911\ubc18\ubd80\ud130 \uc0c1\uc6a9\ud654\ub418\uc5b4 \uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 SQL \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c \uc644\uc804\ud55c SQL \ucef4\ud30c\uc77c\ub7ec \ud504\ub7f0\ud2b8\uc5d4\ub4dc(\ub809\uc11c, \ud30c\uc11c, \uc758\ubbf8 \ud574\uc11d\uae30, \ub370\uc774\ud130 \ud750\ub984 \ubd84\uc11d\uae30)\uc778 General SQL Parser\ub97c \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uc5d4\uc9c4\uc740 Oracle PL\/SQL \ubc0f SQL Server T-SQL\uc758 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubcf8\ubb38, \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218 \ubc0f \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud55c \ucf54\ub4dc \uacc4\ubcf4, \ud504\ub85c\uc2dc\uc800 \ub0b4\uc5d0\uc11c \uc0dd\uc131\ub418\ub294 \ub3d9\uc801 SQL \ub4f1 \uac00\uc7a5 \uc5b4\ub824\uc6b4 \uc0ac\ub840\uae4c\uc9c0 \ud574\uacb0\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uceec\ub7fc \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uc2e4\uc81c\ub85c \ud655\uc778\ud558\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<p>Gudu SQLFlow\ub294 \uc790\ub3d9\ud654\ub41c \ub3c4\uad6c\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c<\/a> \uc774 \ub3c4\uad6c\ub294 \ubd99\uc5ec\ub123\uc740 \ucffc\ub9ac, \uc5c5\ub85c\ub4dc\ub41c \ud30c\uc77c, JDBC\ub97c \ud1b5\ud55c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uba54\ud0c0\ub370\uc774\ud130, dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8 \ud30c\uc77c, Snowflake \ucffc\ub9ac \uae30\ub85d \ubc0f Redshift \ucffc\ub9ac \ub85c\uadf8 \ub4f1 \uc5b4\ub5a4 SQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub4e0 \uc774 \ud398\uc774\uc9c0\uc5d0 \uc124\uba85\ub41c \uc5f4 \uc218\uc900 \uadf8\ub798\ud504\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ucd9c\ub825\uc740 \uc5f4\ubcc4\ub85c \uc790\uc138\ud788 \uc0b4\ud3b4\ubcfc \uc218 \uc788\ub294 \ub300\ud654\ud615 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uacfc JSON \ub610\ub294 CSV \ud615\uc2dd\uc758 \uad6c\uc870\ud654\ub41c \uacc4\ubcf4 \ub370\uc774\ud130, PNG \ub0b4\ubcf4\ub0b4\uae30, \uadf8\ub9ac\uace0 REST API\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uaddc\ubaa8\uc5d0\uc11c SQLFlow\ub294 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \ud3ec\ud568\ud558\ub294 \ud658\uacbd\uc744 \uc77c\uad04 \uc2a4\uce94\ud558\uace0, \uc601\uad6c\uc801\uc778 \uacc4\ubcf4 \uc800\uc7a5\uc18c\uc5d0 \ub300\ud574 \uc99d\ubd84 \uc2a4\uce94\uc744 \uc2e4\ud589\ud558\uba70, DataHub, Microsoft Purview \ubc0f OpenMetadata\ub85c \ub0b4\ubcf4\ub0b4\ubbc0\ub85c \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uae30\uc874\uc5d0 \uc0ac\uc6a9 \uc911\uc778 \uce74\ud0c8\ub85c\uadf8 \ub0b4\uc5d0\uc11c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubd84\uc11d\uc740 \uc815\uc801\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc5d0 SQLFlow\ub294 SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub9cc \uc77d\uace0 \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc73c\uba70, \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc740 SQL \ud14d\uc2a4\ud2b8\ub97c \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc644\uc804\ud788 \ubcf4\uad00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc704\uc640 \uac19\uc740 \ucd94\uc801 \uc815\ubcf4\ub97c \ub354 \uc790\uc138\ud788 \ubcf4\ub824\uba74, \uc11c\ube0c\ucffc\ub9ac, \ubdf0, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f dbt \ubaa8\ub378 \uc804\ubc18\uc5d0 \uac78\uce5c \ucd94\uc801 \uc815\ubcf4\ub97c \ud655\uc778\ud558\ub824\uba74 \uc800\ud76c \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%ec%98%88%ec%8b%9c\/\">\uc791\uc5c5 \ub370\uc774\ud130 \uacc4\ubcf4 \uc608\uc2dc<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-group gd-panel-navy gd-cta is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uc9c1\uc811 \uc791\uc131\ud55c SQL \ucffc\ub9ac\uc5d0\uc11c \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694.<\/h2>\n\n\n<p>\ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uace0 \ucd9c\ub825 \uc5f4\uc744 \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \ucffc\ub9ac\uac00 \uc18c\uc2a4\uae4c\uc9c0 \uc9c1\uc811 \ubc0f \uac04\uc811\uc801\uc73c\ub85c \uc5f0\uacb0\ub41c \uc804\uccb4 \uacbd\ub85c\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-3\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=column-level-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n\n\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">\uacc4\ubcf4 \ub3c4\uad6c\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ud14c\uc774\ube14 \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\uc640 \uceec\ub7fc \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\uc758 \ucc28\uc774\uc810\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>\ud14c\uc774\ube14 \uc218\uc900 \uacc4\ubcf4\ub294 \uc5b4\ub5a4 \ud14c\uc774\ube14\uacfc \ubdf0\uac00 \uc5b4\ub5a4 \uac1d\uccb4 \uc30d\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uac01 \uac1d\uccb4 \uc30d\ub9c8\ub2e4 \ud558\ub098\uc758 \uc5f0\uacb0\uc120\uc744 \uae30\ub85d\ud569\ub2c8\ub2e4. \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub294 \ubaa8\ub4e0 \ucd9c\ub825 \uc5f4\uc5d0 \ub300\ud574 \ud574\ub2f9 \uc5f4\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294 \uc815\ud655\ud55c \uc18c\uc2a4 \uc5f4\uacfc \uc801\uc6a9\ub41c \ubcc0\ud658\uc744 \uae30\ub85d\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc5f4 \uc218\uc900\uc758 \uc138\ubd84\ud654\ub294 \uc601\ud5a5 \ubd84\uc11d\uc5d0\uc11c \uc624\ud0d0\uc744 \uc81c\uac70\ud558\uace0 \uac10\uc0ac \uacb0\uacfc\ub97c \uc815\ud655\ud558\uac8c \ub9cc\ub4dc\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uac04\uc811\uc801(\uc601\ud5a5) \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>\uac04\uc811 \uacc4\ubcf4\ub294 \uc18c\uc2a4 \uc5f4\uc744 \ud574\ub2f9 \uc5f4\uc758 \uac12\uc5d0\ub294 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uace0 \ucd9c\ub825\uc5d0 \uc5f0\uacb0\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. WHERE \uc808, JOIN \uc870\uac74, GROUP BY \ud0a4 \ubc0f \uc9d1\uacc4 \uc870\uac74\uc2dd\uc5d0 \uc0ac\uc6a9\ub418\ub294 \uc5f4\uc774 \uc774\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub97c \uc9c1\uc811 \ub370\uc774\ud130 \ud750\ub984(fdd)\uacfc \ubcc4\ub3c4\ub85c \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \ud65c\uc131\ud654\/\ube44\ud65c\uc131\ud654\ud560 \uc218 \uc788\ub294 \ubcc4\ub3c4\uc758 \uad00\uacc4 \uc720\ud615(fddi)\uc73c\ub85c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc815\uaddc \ud45c\ud604\uc2dd\uc774\ub098 grep\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \ucd94\ucd9c\ud560 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc2e0\ub8b0\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc2a4\ud0c0 \ud655\uc7a5, \ubdf0 \ud574\uc0c1\ub3c4, \ud55c\uc815\ub418\uc9c0 \uc54a\uc740 \uc5f4 \uc774\ub984, CASE \ub610\ub294 COALESCE\uc640 \uac19\uc740 \ud45c\ud604\uc2dd\uc740 \ubaa8\ub450 SQL\uc758 \uc2e4\uc81c \uad6c\ubb38 \ubd84\uc11d\uacfc \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub41c \uc758\ubbf8 \ubaa8\ub378\uc744 \ud544\uc694\ub85c \ud569\ub2c8\ub2e4. \ud328\ud134 \ub9e4\uce6d\uc740 \ud14c\uc774\ube14 \uc774\ub984\uc740 \ucc3e\uc744 \uc218 \uc788\uc9c0\ub9cc, \uc5b4\ub5a4 \uc5f4\uc774 \uc5b4\ub514\ub85c \ud750\ub974\ub294\uc9c0\ub294 \ud30c\uc545\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubdf0\uc640 SELECT *\ub97c \ud1b5\ud574 \uceec\ub7fc \uc218\uc900\uc758 \uacc4\ubcf4 \ucd94\uc801\uc774 \uac00\ub2a5\ud55c\uac00\uc694?<\/h3>\n\n\n<p>\ub124, \ub3c4\uad6c\uac00 \uc774\ub97c \ud574\uacb0\ud55c\ub2e4\uba74 \uac00\ub2a5\ud569\ub2c8\ub2e4. SQLFlow\ub294 SELECT * \ucffc\ub9ac\ub97c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \ub300\ud574 \ud655\uc7a5\ud558\uace0 \ubdf0, CTE \ubc0f \uc11c\ube0c\ucffc\ub9ac\ub97c \ud1b5\ud574 \uc5f4 \ucc38\uc870\ub97c \uc7ac\uadc0\uc801\uc73c\ub85c \ud574\uacb0\ud558\ubbc0\ub85c, \ucd5c\uc885 \ucd9c\ub825 \uc5f4\ubd80\ud130 \ubb3c\ub9ac\uc801 \uc18c\uc2a4 \uc5f4\uae4c\uc9c0 \ubaa8\ub4e0 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc640 \ub3d9\uc801 SQL\uc5d0\uc11c\ub3c4 \uc791\ub3d9\ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc608. SQLFlow\ub294 Oracle PL\/SQL \ubc0f SQL Server T-SQL\uc744 \uc704\ud55c \uc804\uc6a9 \ud504\ub85c\uc2dc\uc800 \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\uace0, \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218 \ubc0f \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \uacc4\ubcf4\ub97c \ucd94\uc801\ud558\uba70, \ud504\ub85c\uc2dc\uc800 \ub0b4\uc5d0\uc11c \uad6c\uc131\ub41c \ub3d9\uc801 SQL\uc744 \ud574\uc11d\ud558\uace0, \ud504\ub85c\uc2dc\uc800 \uac04 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub0b4 SQL \ucffc\ub9ac\uc5d0 \ub300\ud55c \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub97c \uc5b4\ub5bb\uac8c \uc5bb\uc744 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\uc758 \ubb34\ub8cc \ud2f0\uc5b4\uc5d0 \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacbd\uc6b0 JDBC\ub97c \ud1b5\ud574 \uc5f0\uacb0\ud558\uac70\ub098 dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uaddc\uc81c \ud658\uacbd\uc758 \uacbd\uc6b0 SQLFlow On-Premise\ub294 \uc790\uccb4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc758 Docker \ub610\ub294 Kubernetes\uc5d0\uc11c \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull gd-band gd-band-navy gd-cta is-layout-constrained\" style=\"padding-top:56px;padding-bottom:56px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uccab \ubc88\uc9f8 \uc5f4\uc758 \ucd9c\ucc98\ub97c \ucd94\uc801\ud574 \ubcf4\uc138\uc694.<\/h2>\n\n\n<p>\uc774 \ud398\uc774\uc9c0\uc758 \uc608\uc81c \ucffc\ub9ac \ub610\ub294 \uc2e4\uc81c \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uac00\uc7a5 \ubcf5\uc7a1\ud55c SQL \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uace0, \ucd9c\ub825 \uc5f4\uc744 \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \ucffc\ub9ac\uc758 \uc9c1\uc811 \ubc0f \uac04\uc811\uc801\uc778 \uacc4\ubcf4\ub97c \ubaa8\ub450 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=column-level-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n\n\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"TechArticle\",\n            \"headline\": \"Column-Level Data Lineage: What It Is and Why Table-Level Isn't Enough\",\n            \"description\": \"Column-level data lineage maps every output column back to its exact source columns and transformations. A worked SQL example through a CTE, join, and aggregate, the direct vs indirect (fdd\\\/fddi) distinction, and why star expansion and view resolution require semantic parsing.\",\n            \"author\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            },\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What is the difference between table-level and column-level data lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Table-level lineage records which tables and views feed which, one edge per object pair. Column-level lineage records, for every output column, the exact source columns that feed it and the transformations applied. Column granularity is what removes false positives from impact analysis and makes audit answers exact.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What is indirect (impact) lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Indirect lineage links a source column to an output it influences without contributing its value: columns in WHERE clauses, JOIN conditions, GROUP BY keys, and aggregate predicates. SQLFlow models it as a separate relationship type (fddi) that you can toggle independently of direct dataflow (fdd) in the diagram.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I extract column-level lineage with regex or grep?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Not reliably. Star expansion, view resolution, unqualified column names, and expressions like CASE or COALESCE all require a semantic model built from a real parse of the SQL plus schema metadata. Pattern matching can find table names; it cannot resolve which columns flow where.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does column-level lineage work through views and SELECT *?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes, if the tool resolves them. SQLFlow expands SELECT * against schema metadata and recursively resolves column references through views, CTEs, and subqueries, so lineage runs from the final output column all the way to physical source columns.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does it work on stored procedures and dynamic SQL?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow has dedicated procedural parsers for Oracle PL\\\/SQL and SQL Server T-SQL, traces lineage through procedure parameters and temp tables, resolves dynamic SQL assembled inside procedures, and renders a call graph of procedure-to-procedure invocations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How do I get column-level lineage for my own SQL?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Paste a query into SQLFlow Cloud's free tier and the column-level diagram renders in the browser. For whole databases, connect over JDBC or import a dbt manifest; for regulated environments, SQLFlow On-Premise runs in Docker or Kubernetes inside your own network.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>Column-level data lineage maps every output column of a query, view, or report back to the exact source columns that produce it, together with each transformation applied along the way: functions, casts, joins, aggregations, and filters. Where table-level lineage says &#8220;table orders feeds table revenue_report&#8220;, column-level lineage says &#8220;revenue_report.total is SUM(orders.amount), filtered by orders.status and grouped by customers.region&#8220;. It is the granularity at which impact analysis, debugging, and audit answers become precise instead of approximate. Column-levelnot just table-level Direct + indirectfdd &amp; fddi lineage 39SQL dialects parsed Staticreads SQL, never your data This page defines the term, walks one output\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6746"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=6746"}],"version-history":[{"count":1,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6746\/revisions"}],"predecessor-version":[{"id":6822,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6746\/revisions\/6822"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}