{"id":6747,"date":"2026-07-12T02:05:41","date_gmt":"2026-07-12T10:05:41","guid":{"rendered":"https:\/\/www.gudusoft.com\/what-is-data-lineage\/"},"modified":"2026-07-13T19:01:49","modified_gmt":"2026-07-14T03:01:49","slug":"what-is-data-lineage","status":"publish","type":"page","link":"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\/","title":{"rendered":"\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc778\uac00? \uc815\uc758, \uc608\uc2dc \ubc0f \uc791\ub3d9 \ubc29\uc2dd"},"content":{"rendered":"<p>\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc778\uac00\uc694? <strong>\ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \uc774\ub294 \ub370\uc774\ud130\uac00 \ucd5c\ucd08 \uc18c\uc2a4\uc5d0\uc11c \ucd5c\uc885 \ubaa9\uc801\uc9c0\uae4c\uc9c0 \uc774\ub3d9\ud558\ub294 \uacfc\uc815\uc744 \ubb38\uc11c\ud654\ud55c \uac83\uc73c\ub85c, \uadf8 \uacfc\uc815\uc5d0\uc11c \uac70\uce58\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14, \ubdf0, \uc791\uc5c5 \ubc0f \ubcc0\ud658\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ud300\uc774 \ubb3b\ub294 \ub450 \uac00\uc9c0 \uc9c8\ubb38\uc5d0 \ub300\ud55c \ub2f5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <em>\u201c\uc774 \uac12\uc740 \uc5b4\ub514\uc5d0\uc11c \ub098\uc628 \uac83\uc785\ub2c8\uae4c?\u201d<\/em> (\ucd9c\ucc98) \ubc0f <em>\u201c\ud558\ub958\uc5d0\uc11c \uadf8\uac83\uc5d0 \uc758\uc874\ud558\ub294 \uac83\uc740 \ubb34\uc5c7\uc77c\uae4c\uc694?\u201d<\/em> (\uc601\ud5a5 \ubd84\uc11d). SQL \uae30\ubc18 \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc774\ub3d9\ud558\uace0 \uc7ac\uad6c\uc131\ud558\ub294 SQL \ucf54\ub4dc\ub97c \ud30c\uc2f1\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc790\ub3d9\uc73c\ub85c \ucd94\ucd9c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"gd-stats\"><div class=\"gd-stat\"><b>39<\/b><span>SQL \ubc29\uc5b8, \uac01\uac01 \uc804\uc6a9 \ud30c\uc11c<\/span><\/div><div class=\"gd-stat\"><b>\uceec\ub7fc \ub808\ubca8<\/b><span>\ud14c\uc774\ube14 \uc218\uc900\ubfd0 \uc544\ub2c8\ub77c \ub354 \uc138\ubc00\ud55c \uc218\uc900\uae4c\uc9c0 \uace0\ub824\ud569\ub2c8\ub2e4.<\/span><\/div><div class=\"gd-stat\"><b>\uc9c1\uc811 + \uac04\uc811<\/b><span>\ud608\uc5f0\uad00\uacc4<\/span><\/div><div class=\"gd-stat\"><b>\uacf5\uc804<\/b><span>\ubd84\uc11d\uc740 \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/div><\/div>\n\n\n\n<p>\uc774 \ud398\uc774\uc9c0\ub294 \uc2e4\ubb34\uc790\ub97c \uc704\ud55c \uc815\uc758\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \uc2e4\uc81c\ub85c \uae30\ub85d\ud558\ub294 \ub0b4\uc6a9, \ud14c\uc774\ube14 \uc218\uc900\uacfc \uc5f4 \uc218\uc900\uc758 \uc138\ubd84\uc131 \ucc28\uc774, \uc9c1\uc811 \uad00\uacc4\uc640 \uac04\uc811 \uad00\uacc4, \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95, \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \uc2e4\uc81c\ub85c \ud544\uc694\ud55c \ub300\uc0c1\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \ubcc0\ud658 \ub85c\uc9c1\uc774 SQL\uc5d0 \uae30\ubc18\ud558\uae30 \ub54c\ubb38\uc5d0 \uc608\uc81c\ub294 SQL\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/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>\uae00 \ub300\uc2e0 \uc9c1\uc811 \ud608\ud1b5\uc744 \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/strong> SQL \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=what-is-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \uadf8\ub7ec\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub3c4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uacc4\ubcf4 \ubd84\uc11d\uc774 \ub2f5\ud558\ub294 \ub450 \uac00\uc9c0 \uc9c8\ubb38: \uae30\uc6d0\uacfc \uc601\ud5a5 \ubd84\uc11d<\/h2>\n\n\n\n<p>\ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc591\ubc29\ud5a5\uc73c\ub85c \uc77d\uc744 \uc218 \uc788\ub294 \ud558\ub098\uc758 \uadf8\ub798\ud504\uc785\ub2c8\ub2e4. \uc77d\uc5b4\ubcf4\uc138\uc694. <strong>\uc0c1\ub958<\/strong> \uadf8\ub7ec\uba74 \ucd9c\ucc98\ub97c \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc758 \uc218\uce58\uc5d0\uc11c \uc2dc\uc791\ud558\uc5ec \ubaa8\ub4e0 \ubdf0, \uc870\uc778 \ubc0f \uacc4\uc0b0\uc744 \uac70\uc2ac\ub7ec \uc62c\ub77c\uac00 \ud574\ub2f9 \uc218\uce58\uac00 \ud30c\uc0dd\ub41c \uc6d0\ubcf8 \uc18c\uc2a4 \uc5f4\uc744 \ucc3e\uc544\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uac10\uc0ac\uc790, \uaddc\uc81c \uae30\uad00 \ubc0f \uc798\ubabb\ub41c \uc218\uce58\ub97c \ub514\ubc84\uae45\ud558\ub294 \ubaa8\ub4e0 \uc0ac\ub78c\uc774 \uad00\uc2ec\uc744 \uac16\ub294 \ubc29\ud5a5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc77d\uc5b4\ubcf4\uc138\uc694 <strong>\ud558\ub958<\/strong> \uadf8\ub7ec\uba74 \uc601\ud5a5 \ubd84\uc11d\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \uc774\ub984\uc744 \ubc14\uafb8\uac70\ub098, \ud615\uc2dd\uc744 \ubcc0\uacbd\ud558\uac70\ub098, \uc0ad\uc81c\ud558\ub824\ub294 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \uc601\ud5a5\uc744 \ubc1b\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14, \ubdf0, \ud504\ub85c\uc2dc\uc800 \ubc0f \ubcf4\uace0\uc11c\ub97c \uc5f4\uac70\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc774\ub098 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc218\ud589\ud558\uae30 \uc804\uc5d0 \uc5d4\uc9c0\ub2c8\uc5b4\ub4e4\uc774 \uc911\uc694\ud558\uac8c \uc0dd\uac01\ud558\ub294 \ubd80\ubd84\uc774 \ubc14\ub85c \uc774 \uc601\ud5a5 \ubd84\uc11d\uc785\ub2c8\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc218\ucc9c \uac1c\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc77c\uc77c\uc774 \uac80\uc0c9\ud558\uace0 \uacb0\uacfc\ub97c \uae30\ub2e4\ub9ac\ub294 \uc218\ubc16\uc5d0 \uc5c6\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc6a9\uc5b4\ub4e4\uc740 \ub54c\ub54c\ub85c \ub290\uc2a8\ud558\uac8c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc5c4\ubc00\ud788 \ub9d0\ud558\uba74, <em>\uae30\uc6d0<\/em> \uc5ed\ucd94\uc801\uc785\ub2c8\ub2e4. <em>\uc601\ud5a5 \ubd84\uc11d<\/em> \uc774\ub294 \uc21c\ubc29\ud5a5 \ucd94\uc801\uc774\uba70, <em>\ub370\uc774\ud130 \uacc4\ubcf4<\/em> \uc774\ub294 \ub450 \uac00\uc9c0 \ud0d0\uc0c9 \ubaa8\ub450\ub97c \uac00\ub2a5\ud558\uac8c \ud558\ub294 \uae30\ubcf8 \uc885\uc18d\uc131 \uadf8\ub798\ud504\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uad6c\uccb4\uc801\uc778 \uc608<\/h2>\n\n\n\n<p>\uc77c\ubc18\uc801\uc778 \ucc3d\uace0 \uba85\uc138\uc11c\ub97c \uc0dd\uac01\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO monthly_revenue (month, total) SELECT DATE_TRUNC(&#039;month&#039;, o.order_date) AS month, SUM(o.amount) AS total FROM orders o JOIN customers c ON o.customer_id = c.id WHERE c.region = &#039;EMEA&#039; GROUP BY DATE_TRUNC(&#039;month&#039;, o.order_date);<\/code><\/pre>\n\n\n\n<p>\uc774 \ud55c \ubb38\uc7a5\uc5d0\uc11c \ucd94\ucd9c\ub41c \uacc4\ubcf4\ub294 \uc774\ubbf8 \ub450 \uac00\uc9c0 \ub69c\ub837\ud55c \uc720\ud615\uc758 \uad00\uacc4\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uc9c1\uacc4 \ud608\ud1b5<\/strong> \u2014 \ub370\uc774\ud130\ub294 \uc2e4\uc81c\ub85c \ucd9c\ub825\uc73c\ub85c \ud758\ub7ec\uac11\ub2c8\ub2e4. <code>\uc8fc\ubb38.\uc8fc\ubb38_\ub0a0\uc9dc<\/code> \uc0ac\ub8cc <code>\uc6d4\ubcc4 \uc218\uc775.\uc6d4<\/code> ~\uc744 \ud1b5\ud574 <code>\ub0a0\uc9dc_\ud2b8\ub801\ud06c<\/code>, \uadf8\ub9ac\uace0 <code>\uc8fc\ubb38 \uae08\uc561<\/code> \uc0ac\ub8cc <code>\uc6d4\ubcc4 \ub9e4\ucd9c \ucd1d\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569<\/code>.<\/li>\n<li><strong>\uac04\uc811 \ud608\ud1b5<\/strong> \u2014 \ucd9c\ub825 \uacb0\uacfc\uc5d0\ub294 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc \ucd9c\ub825 \uacb0\uacfc\ub97c \ud615\uc131\ud558\ub294 \uc5f4: <code>\uace0\uac1d \uc9c0\uc5ed<\/code> \ud589\uc744 \ud544\ud130\ub9c1\ud558\uace0 <code>\uc8fc\ubb38.\uace0\uac1d_ID<\/code> ~\uc5d0 \ud569\ub958\ud588\uc2b5\ub2c8\ub2e4 <code>\uace0\uac1d ID<\/code> \uc5b4\ub5a4 \ud589\uc774 \uc77c\uce58\ud558\ub294\uc9c0 \uacb0\uc815\ud569\ub2c8\ub2e4. \ubc29\uc2dd\uc744 \ubcc0\uacbd\ud558\uc138\uc694. <code>\uc9c0\uc5ed<\/code> \ub294 \ucc44\uc6cc\uc838 \uc788\uace0 \ubaa8\ub4e0 \uc22b\uc790\ub294 <code>\uc6d4\ubcc4 \uc218\uc775<\/code> \ubcc0\ud654\ub294 \ube44\ub85d ~\uc77c\uc9c0\ub77c\ub3c4 <code>\uc9c0\uc5ed<\/code> \uacb0\uacfc\uc5d0\ub294 \uc804\ud600 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc2e4\uc81c \ud30c\uc774\ud504\ub77c\uc778\uc740 \ubdf0, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, dbt \ubaa8\ub378\uc744 \ud1b5\ud574 \uacc4\uce35\uc801\uc73c\ub85c \uc5f0\uacb0\ub41c \uc218\ucc9c \uac1c\uc758 \uc774\uc640 \uac19\uc740 \uad6c\ubb38\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. \uc0ac\ub78c\uc774 \uc774\ub7ec\ud55c \uad6c\uc870\ub97c \uba38\ub9bf\uc18d\uc5d0 \ubaa8\ub450 \uae30\uc5b5\ud560 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \ucf54\ub4dc \uacc4\ubcf4 \ucd94\uc801 \ub3c4\uad6c\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4. \ub2e4\uc911 \ud649 \ubc0f \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \uacc4\ubcf4 \ucd94\uc801\uc744 \ud3ec\ud568\ud55c \ub354 \ub9ce\uc740 \uc608\uc2dc\ub294 \uc800\ud76c \uc6f9\uc0ac\uc774\ud2b8\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\/\">\ub370\uc774\ud130 \uacc4\ubcf4 \uc608\uc2dc<\/a> \ub2e8\uacc4\ubcc4 \uc548\ub0b4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud14c\uc774\ube14 \uc218\uc900 \uacc4\ubcf4 vs \uc5f4 \uc218\uc900 \uacc4\ubcf4<\/h2>\n\n\n\n<p>\uacc4\ubcf4\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc73c\ub85c \ub098\ub258\uba70, \uadf8 \ucc28\uc774\uc5d0 \ub530\ub77c \uc2e4\uc81c\ub85c \uacc4\ubcf4\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uacb0\uc815\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><\/th><th>\ud14c\uc774\ube14 \uc218\uc900 \uacc4\ubcf4<\/th><th>\uceec\ub7fc \ub808\ubca8 \uacc4\ubcf4<\/th><\/tr><\/thead><tbody>\n<tr><td>\uae30\ub85d\ub418\ub294 \ub0b4\uc6a9<\/td><td><code>\uc6d4\ubcc4 \uc218\uc775<\/code> \ub2e4\uc74c\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. <code>\uba85\ub839<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d<\/code><\/td><td><code>\uc6d4\ubcc4 \ub9e4\ucd9c \ucd1d\uc561<\/code> = <code>SUM(\uc8fc\ubb38 \uc218\ub7c9)<\/code>\ud544\ud130\ub9c1\ub428 <code>\uace0\uac1d \uc9c0\uc5ed<\/code>\uc5d0 \ud569\ub958\ud588\uc2b5\ub2c8\ub2e4. <code>\uace0\uac1d ID = ID<\/code><\/td><\/tr>\n<tr><td>\uc601\ud5a5 \ubd84\uc11d<\/td><td>\uadfc\uc0ac\uce58: \ubcc0\uacbd\ub41c \uc5f4\uc774 \uc804\ud600 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\ub294 \ud56d\ubaa9\uc744 \ud3ec\ud568\ud558\uc5ec \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud56d\ubaa9\uc5d0 \ud50c\ub798\uadf8\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/td><td>\uc815\ud655\ud568: \ud574\ub2f9 \uc5f4\uc774 \uc2e4\uc81c\ub85c \uacf5\uae09\ud558\ub294 \uc18c\ube44\uc790\ub9cc \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uac10\uc0ac \ub2f5\ubcc0<\/td><td>\uc774 \ubcf4\uace0\uc11c\ub294 \ub2e4\uc74c \ud45c\ub4e4\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/td><td>\u201c\uc774 \uc218\uce58\ub294 \ubc14\ub85c \uc774\ub7ec\ud55c \uc6d0\ubcf8 \ub370\uc774\ud130\ub4e4\uc744 \ubc14\ud0d5\uc73c\ub85c \uc774\ub7ec\ud55c \ubcc0\ud658 \uacfc\uc815\uc744 \uac70\uccd0 \uacc4\uc0b0\ub41c \uac83\uc785\ub2c8\ub2e4.\u201d<\/td><\/tr>\n<tr><td>\uc77c\ubc18\uc801\uc778 \ucd9c\ucc98<\/td><td>Job Orchestrator \uba54\ud0c0\ub370\uc774\ud130, \ucffc\ub9ac \ub85c\uadf8<\/td><td>SQL \uc790\uccb4\ub97c \ud30c\uc2f1\ud558\ub294 \uac83<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\ud14c\uc774\ube14 \uc218\uc900\uc758 \uacc4\ubcf4\ub294 \uc218\uc9d1 \ube44\uc6a9\uc774 \uc800\ub834\ud558\uace0 \ud30c\uc774\ud504\ub77c\uc778\uc758 \ucd08\uae30 \uad6c\uc870\ub97c \ud30c\uc545\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub300\ubd80\ubd84\uc758 \uc2e4\uc81c \uc9c8\ubb38\uc740 \uceec\ub7fc\uc5d0 \uad00\ud55c \uc9c8\ubb38\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \ubcf4\uace0\uc11c\uac00 \uc774 \uc815\ubcf4\ub97c \uc0ac\uc6a9\ud558\ub294\uc9c0\uc640 \uac19\uc740 \uc9c8\ubb38\uc785\ub2c8\ub2e4. <code>\uc774\uba54\uc77c<\/code>\uaddc\uc81c \ub300\uc0c1 \uc218\uce58\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \uc18c\uc2a4 \ud544\ub4dc\ub294 \uc0ad\uc81c\ud558\ub824\ub294 \uc5f4\uc744 \uc77d\ub294 \ud558\uc704 \ub2e8\uacc4\uc758 \ubaa8\ub4e0 \uac83\uc785\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c\ub294 \uc870\uc778, \uc11c\ube0c\ucffc\ub9ac, CTE, \ubdf0 \ub4f1\uc744 \ud1b5\ud574 \uac01 \ucd9c\ub825 \uc5f4\uc744 \ud574\uacb0\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5: \ub85c\uadf8 \uc2a4\ud06c\ub798\ud551\uc774 \uc544\ub2cc \ud30c\uc11c \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc791\ub3d9 \ubc29\uc2dd\uc740 \uc800\ud76c \uac00\uc774\ub4dc\uc5d0\uc11c \uc790\uc138\ud788 \ub2e4\ub8e8\uace0 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"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\/\">\uceec\ub7fc \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4<\/a>.<\/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\">\ub370\uc774\ud130 \uacc4\ubcf4 \uad6c\ucd95 \ubc29\ubc95: \uc138 \uac00\uc9c0 \uc811\uadfc \ubc29\uc2dd<\/h2>\n\n\n\n<p>\uc2dc\uc911\uc5d0 \ub098\uc640 \uc788\ub294 \ubaa8\ub4e0 \uacc4\ubcf4 \ubd84\uc11d \ub3c4\uad6c\ub294 \uc138 \uac00\uc9c0 \uae30\uc220\uc744 \uc870\ud569\ud558\uc5ec \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc811\uadfc\ud558\ub2e4<\/th><th>\uc791\ub3d9 \ubc29\uc2dd<\/th><th>\uac15\uc810<\/th><th>\uc57d\uc810<\/th><\/tr><\/thead><tbody>\n<tr><td>\uc815\uc801 SQL \ubd84\uc11d<\/td><td>SQL \ucf54\ub4dc(\ubdf0, \ud504\ub85c\uc2dc\uc800, ETL \uc2a4\ud06c\ub9bd\ud2b8, dbt \ubaa8\ub378)\ub97c \ud30c\uc2f1\ud558\uace0 \uad6c\ubb38 \ubc0f \uc758\ubbf8\ub860\uc73c\ub85c\ubd80\ud130 \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \ub3c4\ucd9c\ud569\ub2c8\ub2e4.<\/td><td>\uceec\ub7fc \uc218\uc900\uc758 \uc815\ubc00\ub3c4\ub97c \uc81c\uacf5\ud558\uba70, \ucd5c\uadfc \uc2e4\ud589\ub418\uc9c0 \uc54a\uc740 \ucf54\ub4dc \uacbd\ub85c\ub97c \ud3ec\ud568\ud558\uc5ec \ubaa8\ub4e0 \ucf54\ub4dc \uacbd\ub85c\ub97c \ud3ec\uad04\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/td><td>\uac01 SQL \ubc29\uc5b8\uc744 \uc9c4\uc815\uc73c\ub85c \uc774\ud574\ud558\ub294 \ud30c\uc11c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. SQL \uc774\uc678\uc758 \ubcc0\ud658(Python, Spark DataFrame)\uc740 \ubc94\uc704\uc5d0\uc11c \uc81c\uc678\ub429\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\ub7f0\ud0c0\uc784\/\ucffc\ub9ac \ub85c\uadf8 \uae30\ubc18<\/td><td>\uc2e4\uc81c\ub85c \uc2e4\ud589\ub41c \ub0b4\uc6a9\uc744 \uad00\ucc30\ud558\uc138\uc694. \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ucffc\ub9ac \uae30\ub85d, \uc624\ucf00\uc2a4\ud2b8\ub808\uc774\ud130 \uc774\ubca4\ud2b8(OpenLineage\/Marquez \ubaa8\ub378) \ub4f1\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><td>SQL \uc774\uc678\uc758 \uc791\uc5c5\uc744 \ud3ec\ud568\ud55c \ub2e4\uc591\ud55c \uc791\uc5c5\uc758 \uc2e4\uc81c \uc2e4\ud589 \uae30\ub85d\uc744 \ucea1\ucc98\ud558\uc5ec &quot;\uc5b8\uc81c \ubb34\uc5c7\uc774 \uc2e4\ud589\ub418\uc5c8\ub294\uc9c0&quot;\uc5d0 \ub300\ud55c \uc815\ub2f5 \ub370\uc774\ud130\ub97c \ud655\ubcf4\ud569\ub2c8\ub2e4.<\/td><td>\uad00\ucc30 \uae30\uac04 \ub3d9\uc548 \uc2e4\ud589\ub41c \uacbd\ub85c\ub9cc \ud45c\uc2dc\ub418\uba70, \uc138\ubd80 \uc815\ubcf4\ub294 \ud14c\uc774\ube14 \uc218\uc900\uc778 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \ub85c\uadf8\uc5d0\ub294 \uc5f4 \uc138\ubd80 \uc815\ubcf4\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574 \uad6c\ubb38 \ubd84\uc11d\ud574\uc57c \ud558\ub294 SQL\uc774 \uc5ec\uc804\ud788 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uc218\ub3d9 \ubb38\uc11c\ud654<\/td><td>\ubd84\uc11d\uac00\ub4e4\uc740 \ub9e4\ud551 \uc815\ubcf4\ub97c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub098 \uce74\ud0c8\ub85c\uadf8\uc5d0 \uc218\uc791\uc5c5\uc73c\ub85c \uae30\ub85d\ud569\ub2c8\ub2e4.<\/td><td>\uad6c\ubb38 \ubd84\uc11d\uae30\uac00 \ucd94\ub860\ud560 \uc218 \uc5c6\ub294 \ube44\uc988\ub2c8\uc2a4 \ub9e5\ub77d \ubc0f \uc815\uc758<\/td><td>\uc791\uc131\ub41c \uc9c0 \ud558\ub8e8\ub9cc \uc9c0\ub098\ub3c4 \uc9c4\ubd80\ud574\uc9c0\uace0, \uc2e4\uc81c \uaddc\ubaa8\ub85c \ud655\uc7a5\ud560 \uacbd\uc6b0 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc774\uac83\ub4e4\uc740 \uacbd\uc7c1 \uad00\uacc4\uac00 \uc544\ub2c8\ub77c \uc0c1\ud638 \ubcf4\uc644\uc801\uc778 \uad00\uacc4\uc785\ub2c8\ub2e4. \ub7f0\ud0c0\uc784 \uacc4\ubcf4\ub294 \uc5b4\ub5a4 \uc791\uc5c5\uc774 \uc2e4\ud589\ub418\uc5c8\ub294\uc9c0 \uc54c\ub824\uc8fc\uace0, \uc218\ub3d9 \ud050\ub808\uc774\uc158\uc740 \ube44\uc988\ub2c8\uc2a4 \uc758\ubbf8\ub97c \ubd80\uc5ec\ud558\uba70, \uc815\uc801 SQL \ubd84\uc11d\uc740 \uc5f4 \uc218\uc900\uc758 \ub17c\ub9ac \ub9f5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ubcc0\ud658 \ub85c\uc9c1\uc774 SQL\uc774\uae30 \ub54c\ubb38\uc5d0 \uc815\uc801 \ubd84\uc11d\uc774 \uac00\uc7a5 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\uba70, \uadf8 \ud488\uc9c8\uc740 \ud30c\uc11c\uc758 \ud488\uc9c8\uc5d0 \uc9c1\uacb0\ub429\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\/\">Gudu SQLFlow<\/a> \uc774 \uc194\ub8e8\uc158\uc740 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud30c\uc11c(Snowflake, BigQuery, Oracle, SQL Server, Teradata \ub4f1 34\uac1c \ucd94\uac00)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774\ub7ec\ud55c \uc811\uadfc \ubc29\uc2dd\uc744 \ucde8\ud569\ub2c8\ub2e4. \uc774 \ud30c\uc11c\ub4e4\uc740 2000\ub144\ub300 \uc911\ubc18\ubd80\ud130 \uac1c\ubc1c\ub418\uc5b4 \uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c SQL \ucef4\ud30c\uc77c\ub7ec \ud504\ub7f0\ud2b8\uc5d4\ub4dc\ub97c \uae30\ubc18\uc73c\ub85c \ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc2ec\uce35\uc801\uc778 \uac1c\ubc1c \ub355\ubd84\uc5d0 \uc77c\ubc18 \ud30c\uc11c\uc5d0\uc11c\ub294 \ucc98\ub9ac\ud558\uae30 \uc5b4\ub824\uc6b4 SQL, \uc989 Oracle PL\/SQL \ubc0f T-SQL \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, \ub7f0\ud0c0\uc784\uc5d0 \uc0dd\uc131\ub418\ub294 \ub3d9\uc801 SQL, \uc784\uc2dc \ud14c\uc774\ube14 \ubc0f \ubdf0 \uc2a4\ud0dd \ub4f1\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ubb34\uc5c7\uc5d0 \uc0ac\uc6a9\ub418\ub098\uc694?<\/h2>\n\n\n\n<p>\uc2e4\uc81c\ub85c \uacc4\ubcf4 \ucd94\uc801 \uae30\ub2a5\uc774 \ub3c4\uc785\ub418\ub294 \uac70\uc758 \ubaa8\ub4e0 \uacbd\uc6b0\ub294 \ub2e4\uc74c \ub124 \uac00\uc9c0 \uc0ac\uc6a9 \uc0ac\ub840\ub85c \uc124\uba85\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uaddc\uc815 \uc900\uc218.<\/strong> BCBS 239\ub294 \uc740\ud589\uc774 \uc6d0\ucc9c \ub370\uc774\ud130\uc5d0\uc11c \uc704\ud5d8 \uc218\uce58\ub97c \uc9d1\uacc4\ud558\ub294 \ubc29\ubc95\uc744 \uc785\uc99d\ud558\ub3c4\ub85d \uc694\uad6c\ud558\uba70, GDPR\uc758 \ub370\uc774\ud130 \ub9e4\ud551 \uc758\ubb34\ub294 \uac1c\uc778 \ub370\uc774\ud130\uac00 \uc5b4\ub5a4 \uc2dc\uc2a4\ud15c\uacfc \ud30c\uc0dd \ud14c\uc774\ube14\ub85c \ud750\ub974\ub294\uc9c0 \ud30c\uc545\ud558\ub3c4\ub85d \uc694\uad6c\ud569\ub2c8\ub2e4. \uceec\ub7fc \uc218\uc900\uc758 \ucd9c\ucc98 \uc815\ubcf4\ub294 &quot;\uc774\ub7ec\ud55c \ubcc0\ud658 \uacfc\uc815\uc744 \ud1b5\ud574 \uc815\ud655\ud55c \uc6d0\ucc9c \ud544\ub4dc\uc5d0 \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub428&quot;\uc774\ub77c\ub294 \ub450 \uac00\uc9c0 \uc694\uad6c \uc0ac\ud56d\uc744 \ubaa8\ub450 \ucda9\uc871\ud558\ub294 \uacb0\uacfc\ubb3c\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4.<\/strong> \ucf54\ub4dc \uacc4\ubcf4\ub97c \uc218\ub3d9\uc73c\ub85c \uad00\ub9ac\ud558\uba74 \uce74\ud0c8\ub85c\uadf8\uc640 \uc6a9\uc5b4\uc9d1\uc774 \ucd5c\uc2e0 \uc0c1\ud0dc\ub97c \uc720\uc9c0\ud558\uc9c0 \ubabb\ud558\uac8c \ub429\ub2c8\ub2e4. \uc790\ub3d9\uc73c\ub85c \ucd94\ucd9c\ub418\ub294 \uacc4\ubcf4\ub294 \ucf54\ub4dc \ubcc0\uacbd \uc2dc \uc885\uc18d\uc131 \ub9f5\uc744 \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud558\uace0 \uce74\ud0c8\ub85c\uadf8 \ud50c\ub7ab\ud3fc\uc5d0 \uc9c1\uc811 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 SQLFlow\ub294 DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub514\ubc84\uae45 \ubc0f \uadfc\ubcf8 \uc6d0\uc778 \ubd84\uc11d.<\/strong> \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \uc798\ubabb\ub41c \uc22b\uc790\uac00 \ud45c\uc2dc\ub418\uba74, \ub9ac\ub2c8\uc9c0\ub294 &quot;\uc774 \ud14c\uc774\ube14\uc744 \uc5b8\uae09\ud558\ub294 \ubaa8\ub4e0 \uc2a4\ud06c\ub9bd\ud2b8 \uac80\uc0c9&quot;\uc744 &quot;\uc774 \ud2b9\uc815 \uc5f4\ubd80\ud130 \uc5ed\ucd94\uc801&quot;\uc73c\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uadf8\ub7ec\uba74 \uba70\uce60\uc774 \uc544\ub2cc \uba87 \uc2dc\uac04 \ub9cc\uc5d0 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uc774\uc8fc\uc640 \uadfc\ub300\ud654.<\/strong> Oracle\uc774\ub098 Teradata\uc5d0\uc11c Snowflake, BigQuery \ub610\ub294 Databricks\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\uae30 \uc804\uc5d0 \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \ud1b5\ud574 \uc5b4\ub5a4 \uac1d\uccb4\ub97c \uc5b4\ub5a4 \uc21c\uc11c\ub85c \ud568\uaed8 \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud574\uc57c \ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \ub354 \uc774\uc0c1 \uc77d\uc9c0 \uc54a\ub294 \uac1d\uccb4\ub294 \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ub300\uc2e0 \uc0ad\uc81c\ud574\ub3c4 \ub418\ub294\uc9c0 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p><strong class=\"gd-lead-in\">\uc720\uc6a9\ud55c \ubc1c\uacac\uc801 \ubc29\ubc95:<\/strong> \ub9cc\uc57d \ud300\uc5d0\uc11c \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc73c\ub85c \uc778\ud574 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560\uc9c0 \ud655\uc2e0\ud560 \uc218 \uc5c6\uc5b4\uc11c \ubcc0\uacbd\uc744 \ubbf8\ub904\ubcf8 \uc801\uc774 \uc788\ub2e4\uba74, \uc774\ubbf8 \uacc4\ubcf4 \uc815\ubcf4\uac00 \ud544\uc694\ud55c \uac83\uc785\ub2c8\ub2e4. \ub2e4\ub9cc \uc9c0\uae08\uc740 \uc218\ub3d9\uc73c\ub85c, \ub290\ub9ac\uac8c, \uadf8\ub9ac\uace0 \uc624\ub958\ub97c \ud3ec\ud568\ud558\uc5ec \uacc4\uc0b0\ud558\uace0 \uc788\uc744 \ubfd0\uc785\ub2c8\ub2e4.<\/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\">\uc608\uc81c SQL \ucffc\ub9ac\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc9c1\uc811 \uc791\uc131\ud55c SQL \ucffc\ub9ac\ub3c4 \ucd94\uc801\ud574 \ubcf4\uc138\uc694.<\/h2>\n\n\n<p>\ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900\uc758 \ub300\ud654\ud615 \uacc4\ubcf4\ub3c4\ub97c \uc5bb\uc744 \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=what-is-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\">\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>\uc774\ub294 \ub370\uc774\ud130\uc758 \ucd9c\ucc98\uc640 \uc774\ub3d9 \uacbd\ub85c\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc989, \uac01 \ud14c\uc774\ube14\uc774\ub098 \ubcf4\uace0\uc11c\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4\uc758 \ub370\uc774\ud130\uac00 \uc0ac\uc6a9\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uadf8 \uacfc\uc815\uc5d0\uc11c \uc5b4\ub5a4 \ubcc0\ud658\uc774 \uc77c\uc5b4\ub098\ub294\uc9c0\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ub370\uc774\ud130\uc758 \uc758\uc874\uc131 \uadf8\ub798\ud504\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \ub418\uba70, \uc5ed\ucd94\uc801(\ucd9c\ucc98 \ud655\uc778)\uacfc \uc21c\ucd94\uc801(\uc601\ud5a5 \ubd84\uc11d)\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uacc4\ubcf4\uc640 \ub370\uc774\ud130 \ucd9c\ucc98\uc758 \ucc28\uc774\uc810\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>\ucd9c\ucc98(Provenance)\ub294 \ud558\ub098\uc758 \uacb0\uacfc\ubb3c\uc5d0\uc11c \uadf8 \uae30\uc6d0\uae4c\uc9c0 \uac70\uc2ac\ub7ec \uc62c\ub77c\uac00\ub294 \uc5ed\ucd94\uc801 \uacbd\ub85c\uc785\ub2c8\ub2e4. \uacc4\ubcf4(Lineage)\ub294 \uc804\uccb4 \uc758\uc874\uc131 \uadf8\ub798\ud504\ub85c, \ud55c \ubc29\ud5a5\uc73c\ub85c\ub294 \ucd9c\ucc98 \ucd94\uc801\uc744, \ub2e4\ub978 \ubc29\ud5a5\uc73c\ub85c\ub294 \uc601\ud5a5 \ubd84\uc11d\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc77c\uc0c1\uc801\uc778 \uc0ac\uc6a9\uc5d0\uc11c \ub450 \uc6a9\uc5b4\ub294 \ud63c\uc6a9\ub418\uc9c0\ub9cc, \uadf8\ub798\ud504\uc640 \uc21c\ud68c\ub77c\ub294 \ub450 \uac1c\ub150\uc758 \uc815\ud655\ud55c \uad6c\ubd84\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uac04\uc811 \ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>\uac04\uc811 \uacc4\ubcf4\ub294 \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\uba74\uc11c \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \uc5f4\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc989, \ub2e4\uc74c\uacfc \uac19\uc740 \uc5f4\uc774 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <code>\uc5b4\ub514<\/code> \ud544\ud130, <code>\uac00\uc785\ud558\ub2e4<\/code> \uc870\uac74 \ubc0f <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code> \uc808(sections)\uc740 \ubaa8\ub4e0 \ucd9c\ub825\uac12\uc744 \ubcc0\uacbd\ud558\ubbc0\ub85c, \uc774\ub97c \ubb34\uc2dc\ud558\ub294 \uc601\ud5a5 \ubd84\uc11d\uc740 \ubd88\uc644\uc804\ud569\ub2c8\ub2e4. SQLFlow\ub294 \uac04\uc811 \uacc4\ubcf4\ub97c \ubcc4\ub3c4\uc758 \uc804\ud658 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc73c\ub85c \ubaa8\ub378\ub9c1\ud558\uc9c0\ub9cc, \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">GDPR \ub610\ub294 BCBS 239 \uaddc\uc815 \uc900\uc218\ub97c \uc704\ud574 \ub370\uc774\ud130 \uacc4\ubcf4 \ucd94\uc801\uc774 \ud544\uc218\uc801\uc778\uac00\uc694?<\/h3>\n\n\n<p>\ub450 \ud504\ub808\uc784\uc6cc\ud06c \ubaa8\ub450 &quot;\ub370\uc774\ud130 \uacc4\ubcf4&quot;\ub97c \ud544\uc218 \uae30\uc220\ub85c \uba85\uc2dc\ud558\uc9c0\ub294 \uc54a\uc9c0\ub9cc, \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \uc81c\uacf5\ud558\ub294 \uc815\ubcf4\ub97c \uc694\uad6c\ud569\ub2c8\ub2e4. BCBS 239\ub294 \uc740\ud589\uc774 \uc704\ud5d8 \ub370\uc774\ud130\uac00 \ucd9c\ucc98\ubcc4\ub85c \uc5b4\ub5bb\uac8c \uc9d1\uacc4\ub418\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub3c4\ub85d \uc694\uad6c\ud558\uace0, GDPR \ub370\uc774\ud130 \ub9e4\ud551\uc740 \uac1c\uc778 \ub370\uc774\ud130\uc758 \ud750\ub984\uc744 \ud30c\uc545\ud558\ub3c4\ub85d \uc694\uad6c\ud569\ub2c8\ub2e4. \uceec\ub7fc \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc774\ub7ec\ud55c \uc99d\uac70\ub97c \ub300\uaddc\ubaa8\ub85c \uc0dd\uc131\ud558\ub294 \ud45c\uc900\uc801\uc778 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow\ub97c \uc0ac\uc6a9\ud558\uba74 \uc815\uc801 \ubd84\uc11d \uacc4\ubcf4 \ub3c4\uad6c\uc5d0 SQL \ucf54\ub4dc\ub97c \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQLFlow\ub97c \uc0ac\uc6a9\ud558\uba74 SQL \ucf54\ub4dc\ub97c \ubd99\uc5ec\ub123\uac70\ub098, \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uac70\ub098, JDBC\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uac70\ub098, dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8\ub97c \uac00\uc838\uc624\uac70\ub098, Snowflake \ucffc\ub9ac \uae30\ub85d \ub610\ub294 Redshift \ucffc\ub9ac \ub85c\uadf8\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 \ucf54\ub4dc\ub97c \ud30c\uc2f1\ud558\uc5ec \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc0dd\uc131\ud558\uace0 JSON\/CSV \ub0b4\ubcf4\ub0b4\uae30 \ubc0f REST API\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ud658\uacbd\uc5d0\uc11c\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 \ub300\uaddc\ubaa8 \ud658\uacbd\uc744 \uc77c\uad04 \uc2a4\uce94\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub824\uba74 \uc2e4\uc81c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc815\uc801 \ubd84\uc11d\uc73c\ub85c\ub294 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4. SQL \ud30c\uc2f1\uc5d0\ub294 \ucf54\ub4dc\uc640 \uc120\ud0dd\uc801\uc73c\ub85c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130(\ud14c\uc774\ube14 \ubc0f \uc5f4 \uc815\uc758)\uac00 \ud544\uc694\ud558\uba70, \ud14c\uc774\ube14\uc758 \ud589 \uc790\uccb4\ub294 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. SQLFlow \uc628\ud504\ub808\ubbf8\uc2a4 \uc5d0\ub514\uc158\uc740 SQL \ud14d\uc2a4\ud2b8 \uc790\uccb4\ub97c \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \ubcf4\uad00\ud558\ubbc0\ub85c \uc740\ud589 \ubc0f \uae30\ud0c0 \uaddc\uc81c \ud658\uacbd\uc5d0 \uc801\ud569\ud569\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\">SQL\uc5d0 \uc228\uaca8\uc9c4 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694<\/h2>\n\n\n<p>\ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub3c4\ub97c \uc989\uc2dc \uc5bb\uc744 \uc218 \uc788\uc73c\uba70, \uc804\uccb4 \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcfc \uc218\ub3c4 \uc788\uc2b5\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> \uc804\uccb4 \ubd80\ub3d9\uc0b0 \uc2a4\uce94\uc6a9\uc785\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=what-is-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\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\": \"What Is Data Lineage? Definition, Examples, and How It Works\",\n            \"description\": \"A practitioner's definition of data lineage: provenance vs impact analysis, table-level vs column-level granularity, direct vs indirect lineage, and the three ways lineage is built (static SQL analysis, runtime logs, manual documentation).\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/what-is-data-lineage\\\/\",\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 data lineage in simple terms?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"It is the map of where your data comes from and where it goes: which sources feed each table or report, and what transformations happen in between. Think of it as a dependency graph for data, traversable backward (provenance) and forward (impact analysis).\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What is the difference between data lineage and data provenance?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Provenance is the backward trace from one output to its origins. Lineage is the whole dependency graph, which supports provenance in one direction and impact analysis in the other. In everyday usage the terms overlap, but the graph-versus-traversal distinction is the precise one.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What is indirect data lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Indirect lineage covers columns that influence a result without appearing in it, such as columns used in WHERE filters, JOIN conditions, and GROUP BY clauses. They change every output value, so impact analysis that ignores them is incomplete. Gudu SQLFlow models indirect lineage as a separate, toggleable relationship type; most lineage tools do not make the distinction.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is data lineage required for GDPR or BCBS 239 compliance?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Neither framework names lineage as a mandatory technology, but both require what lineage provides: BCBS 239 asks banks to show how risk data is aggregated from its sources, and GDPR data mapping requires knowing where personal data flows. Column-level lineage is the standard way to produce that evidence at scale.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How do you create data lineage automatically?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Feed your SQL to a static-analysis lineage tool. With Gudu SQLFlow you can paste SQL, upload files, connect a database over JDBC, import a dbt manifest, or ingest Snowflake query history or Redshift query logs; it parses the code and produces interactive column-level diagrams plus JSON\\\/CSV exports and a REST API. Enterprise deployments batch-scan estates of 100+ databases and over a million columns.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does building lineage require access to my actual data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Not with static analysis. Parsing SQL requires the code and, optionally, schema metadata (table and column definitions), never the rows in your tables. SQLFlow's On-Premise edition additionally keeps the SQL text itself inside your network, which is why it fits banks and other regulated environments.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \uacc4\ubcf4\ub780 \ubb34\uc5c7\uc77c\uae4c\uc694? \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ub370\uc774\ud130\uac00 \ucd5c\ucd08 \uc18c\uc2a4\uc5d0\uc11c \ucd5c\uc885 \ubaa9\uc801\uc9c0\uae4c\uc9c0 \uc774\ub3d9\ud558\ub294 \uacbd\ub85c\ub97c \ubb38\uc11c\ud654\ud55c \uac83\uc73c\ub85c, \uadf8 \uacfc\uc815\uc5d0\uc11c \uac70\uce58\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14, \ubdf0, \uc791\uc5c5 \ubc0f \ubcc0\ud658\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \ub370\uc774\ud130 \ud300\uc774 \ubb3b\ub294 \ub450 \uac00\uc9c0 \uc9c8\ubb38, \uc989 &quot;\uc774 \uac12\uc740 \uc5b4\ub514\uc5d0\uc11c \uc654\ub294\uac00?&quot;(\ucd9c\ucc98)\uc640 &quot;\ud558\uc704 \ub2e8\uacc4\uc5d0\uc11c \uc774 \uac12\uc5d0 \uc758\uc874\ud558\ub294 \uac83\uc740 \ubb34\uc5c7\uc778\uac00?&quot;(\uc601\ud5a5 \ubd84\uc11d)\uc5d0 \ub300\ud55c \ub2f5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. SQL \uae30\ubc18 \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc774\ub3d9\ud558\uace0 \uc7ac\uad6c\uc131\ud558\ub294 SQL \ucf54\ub4dc\ub97c \ud30c\uc2f1\ud558\uc5ec \uacc4\ubcf4\ub97c \uc790\ub3d9\uc73c\ub85c \ucd94\ucd9c\ud569\ub2c8\ub2e4. 39\uac00\uc9c0 SQL \ubc29\uc5b8\uc774 \uc788\uc73c\uba70, \uac01 \ubc29\uc5b8\ub9c8\ub2e4 \uc804\uc6a9 \ud30c\uc11c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \uc218\uc900\ubfd0 \uc544\ub2c8\ub77c \uc5f4 \uc218\uc900\uc758 \uc138\ubd84\uc131\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc9c1\uc811 \ubc0f \uac04\uc811 \uacc4\ubcf4 \uad00\uacc4\ub97c \ubaa8\ub450 \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\uc801 \ubd84\uc11d\uc740 \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774 \ud398\uc774\uc9c0\ub294 \uc791\uc5c5 \uc911\uc778 \uc815\uc758\uc785\ub2c8\ub2e4\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\/6747"}],"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=6747"}],"version-history":[{"count":1,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6747\/revisions"}],"predecessor-version":[{"id":6821,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6747\/revisions\/6821"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}