{"id":1840,"date":"2020-11-28T06:54:37","date_gmt":"2020-11-28T06:54:37","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=1840"},"modified":"2026-07-14T02:14:23","modified_gmt":"2026-07-14T10:14:23","slug":"get-started-with-data-lineage-example","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-%ec%98%88%ec%a0%9c%eb%a1%9c-%ec%8b%9c%ec%9e%91%ed%95%98%ea%b8%b0\/","title":{"rendered":"\uc2dc\uc791\ud558\uae30"},"content":{"rendered":"<p>\ucc98\uc74c \uc654\uc2b5\ub2c8\ub2e4 <strong>Gudu SQLFlow<\/strong>\uc5ec\uae30\uc11c \uc2dc\uc791\ud558\uc138\uc694. \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc5d0\ub294 \uc608\uc2dc\uc640 SQLFlow\ub97c \uc0ac\uc6a9\ud558\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95, \uadf8\ub9ac\uace0 \ub2e4\uc74c \ub2e8\uacc4\uc5d0 \ub300\ud55c \uc124\uba85\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc778 SQL \uc9c0\uc2dd\ub9cc \uc788\uc73c\uba74 \ub418\uba70, \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d \uacbd\ud5d8\uc740 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"gd-stats\">\n<div class=\"gd-stat\"><b>\ubb34\ub8cc<\/b><span>\uc628\ub77c\uc778 \uc2dc\uac01\ud654 \ub3c4\uad6c - \uc608\uc2dc\ub97c \ubcf4\ub824\uba74 \uac00\uc785\ud560 \ud544\uc694 \uc5c6\uc74c<\/span><\/div>\n<div class=\"gd-stat\"><b>39<\/b><span>\uc9c0\uc6d0\ub418\ub294 SQL \ubc29\uc5b8<\/span><\/div>\n<div class=\"gd-stat\"><b>3<\/b><span>\uc0ac\uc6a9 \ubc29\ubc95 \u2014 UI, REST API, \uc628\ud504\ub808\ubbf8\uc2a4<\/span><\/div>\n<div class=\"gd-stat\"><b>\uceec\ub7fc \ub808\ubca8<\/b><span>\ud608\ud1b5, \uc9c1\uacc4 \ubc0f \uac04\uc811<\/span><\/div>\n<\/div>\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>\uc9c0\uae08 \ubc14\ub85c \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> \uc5f4\uc5b4\ubcf4\uc138\uc694 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=get-started\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>\uc544\ub798 SQL\uc744 \ubd99\uc5ec\ub123\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c \ub2e4\uc74c \ud074\ub9ad\ud558\uc138\uc694. <em>\uc2dc\uac01\ud654<\/em>.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: \ud558\ub098\uc758 \ucffc\ub9ac\uc5d0\uc11c \uc5f4 \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \ub450 \uac1c\uc758 \uc18c\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c \uc694\uc57d \ud14c\uc774\ube14\uc744 \ubd88\ub7ec\uc624\ub294 \uba85\ub839\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO deptsal (dept_no, dept_name, salary) SELECT d.deptno, d.dname, SUM(e.sal + NVL(e.comm, 0)) AS sal FROM dept d LEFT JOIN (SELECT * FROM emp WHERE hiredate &gt; DATE &#039;1980-01-01&#039;) e ON e.deptno = d.deptno GROUP BY d.deptno, d.dname;<\/code><\/pre>\n\n\n\n<p>\ub370\uc774\ud130\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>\ubd80\uc11c<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>\ubd80\uc11c<\/code> \uadf8\ub9ac\uace0 <code>\uc9c1\uc6d0<\/code>SQLFlow\ub294 \uc815\ud655\ud55c \uac12\uc744 \ucd94\ub860\ud569\ub2c8\ub2e4. <strong>\uceec\ub7fc \ub808\ubca8<\/strong> \uad00\uacc4:<\/p>\n\n\n\n<ul>\n<li><code>\ubd80\uc11c.\ubd80\uc11c_\ubc88\ud638<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>\ubd80\uc11c \ubd80\uc11c \ubc88\ud638<\/code><\/li>\n<li><code>\ubd80\uc11c\uba85<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>\ubd80\uc11c\uba85<\/code><\/li>\n<li><code>\ubd80\uc11c \uae09\uc5ec<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>\uc5e0\ud504.\uc0b4<\/code> \uadf8\ub9ac\uace0 <code>emp.comm<\/code>\uacb0\ud569\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569(...)<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ub610\ud55c \ub2e4\uc74c\uc744 \ud3ec\ucc29\ud569\ub2c8\ub2e4. <strong>\uac04\uc811 \ud608\ud1b5<\/strong> \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\uba74\uc11c \uacb0\uacfc\ub97c \ud615\uc131\ud558\ub294 \uac83: <code>\uace0\uc6a9\uc77c<\/code> \uc5d0\uc11c <code>\uc5b4\ub514<\/code> \ud544\ud130 \ubc0f <code>\ubd80\uc11c \ubd80\uc11c \ubc88\ud638<\/code>\/<code>\uc9c1\uc6d0\ubd80\uc11c\ubc88\ud638<\/code> \uc5d0\uc11c <code>\uac00\uc785\ud558\ub2e4<\/code>SQLFlow\ub294 \uc774 \ubaa8\ub4e0 \uac83\uc744 \ud0d0\uc0c9\ud558\uace0, \uc0c1\uc704 \ubc0f \ud558\uc704 \uacbd\ub85c\ub97c \ucd94\uc801\ud558\uace0, \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub294 \ub300\ud654\ud615 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc73c\ub85c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/11\/tutorial_diagram_panel.jpg\" alt=\"SQLFlow \uc778\ud130\ud398\uc774\uc2a4\uc5d0\uc11c \uc5f4 \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\ub3c4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\ub97c \uc0ac\uc6a9\ud558\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95<\/h2>\n\n\n\n<div class=\"gd-linkgrid\">\n<a class=\"gd-linkcard\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=get-started\" target=\"_blank\" rel=\"noreferrer noopener\"><b>\uc628\ub77c\uc778 \uc6f9 UI<\/b><span>SQL \ucffc\ub9ac \ubd99\uc5ec\ub123\uae30, \ud30c\uc77c \uc5c5\ub85c\ub4dc \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \ub4f1 \ubaa8\ub4e0 \uae30\ub2a5\uc744 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ubb34\ub8cc\ub85c \uc774\uc6a9\ud574 \ubcf4\uc138\uc694.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-restful-api\/\"><b>REST API<\/b><span>\ud30c\uc774\ud504\ub77c\uc778 \ubc0f \ub3c4\uad6c\uc5d0 \ud65c\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d HTTP\ub97c \ud1b5\ud574 SQL \ucffc\ub9ac\ub97c \uc804\uc1a1\ud558\uace0 JSON \ud615\uc2dd\uc758 \ub370\uc774\ud130 \uacc4\ubcf4 \uadf8\ub798\ud504\ub97c \uc218\uc2e0\ud569\ub2c8\ub2e4.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\"><b>\uc628\ud504\ub808\ubbf8\uc2a4<\/b><span>\ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 \uc5d4\uc9c4 \uc804\uccb4\ub97c \uc790\uccb4 \ud638\uc2a4\ud305\ud558\uace0, \uc678\ubd80\uc640 \uc644\uc804\ud788 \ubd84\ub9ac\ud558\uc5ec SQL\uc774 \uc808\ub300 \uc678\ubd80\ub85c \uc720\ucd9c\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/span><\/a>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\ub2e4\uc74c \ub2e8\uacc4<\/h2>\n\n\n\n<div class=\"gd-linkgrid\">\n<a class=\"gd-linkcard\" href=\"https:\/\/sqlflow.gudusoft.com\/\"><b>\ubb34\ub8cc \uacc4\uc815\uc744 \ub4f1\ub85d\ud558\uc138\uc694<\/b><span>\ub354 \ud070 \uc785\ub825\uac12\uacfc \uc808\uc57d\ub41c \uc791\uc5c5\ub7c9<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/docs.gudusoft.com\/1.-introduction\/getting-started\/\"><b>\uc2dc\uc791 \uac00\uc774\ub4dc<\/b><span>\uc790\uc138\ud55c \uc548\ub0b4\ub294 \ubb38\uc11c\uc5d0\uc11c \ud655\uc778\ud558\uc138\uc694.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/docs.gudusoft.com\/1.-introduction\/getting-started\/how-to-use-sqlflow\/\"><b>SQLFlow \uc0ac\uc6a9 \ubc29\ubc95<\/b><span>UI, API \ubc0f \uc628\ud504\ub808\ubbf8\uc2a4\uc5d0 \ub300\ud55c \uc124\uba85<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-restful-api\/\"><b>REST API<\/b><span>HTTP\ub97c \ud1b5\ud55c \uacc4\ud1b5 \uc815\ubcf4 \ucd94\ucd9c \uc790\ub3d9\ud654<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8b%a4%ec%9a%b4%eb%a1%9c%eb%93%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%ec%9e%90%eb%b0%94-%eb%9d%bc%ec%9d%b4%eb%b8%8c%eb%9f%ac%eb%a6%ac\/\"><b>\uc790\ubc14 \ub77c\uc774\ube0c\ub7ec\ub9ac<\/b><span>JVM \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uacc4\ubcf4 \uc5d4\uc9c4\uc744 \ub0b4\uc7a5\ud569\ub2c8\ub2e4.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b7%b8%eb%9e%98%eb%b9%97\/\"><b>SQLFlow \uc778\uc81c\uc2a4\ud130<\/b><span>\ub370\uc774\ud130\ubca0\uc774\uc2a4, Git \ubc0f \ud30c\uc77c\uc5d0\uc11c SQL\uc744 \uc218\uc9d1\ud569\ub2c8\ub2e4.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%9e%90%ec%9b%90\/\"><b>\uc790\ub8cc \ud5c8\ube0c<\/b><span>\uac00\uc774\ub4dc, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ubcc4 \uacc4\ubcf4 \ubc0f \ubb38\uc11c<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-faq\/\"><b>\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/b><span>\uc81c\ud488, \ub370\uc774\ud130, \uac00\uaca9 \ubc0f \uacc4\uc815 \uad00\ub828 \uc9c8\ubb38<\/span><\/a>\n<\/div>\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\">\uc9c1\uc811 \uc791\uc131\ud55c SQL \ucffc\ub9ac\ub97c \ud655\uc778\ud574 \ubcfc \uc900\ube44\uac00 \ub418\uc168\ub098\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\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-2\">\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=get-started\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n\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 \uc0b4\ud3b4\ubcf4\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>New to Gudu SQLFlow? Start here. Paste a query and get column-level data lineage in seconds. Below is a worked example, the three ways to use SQLFlow, and where to go next. You only need basic SQL knowledge \u2014 no prior data lineage experience required. Freeonline visualizer \u2014 no signup for examples 39SQL dialects supported 3ways to use it \u2014 UI, REST API, on-premise Column-levellineage, direct and indirect Try it now: open the free SQLFlow visualizer, paste the SQL below, pick the database, and click Visualize. A worked example: column-level lineage from one query Consider this statement, which loads a\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\/1840"}],"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=1840"}],"version-history":[{"count":40,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/1840\/revisions"}],"predecessor-version":[{"id":6837,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/1840\/revisions\/6837"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=1840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}