{"id":6757,"date":"2026-07-12T02:07:05","date_gmt":"2026-07-12T10:07:05","guid":{"rendered":"https:\/\/www.gudusoft.com\/mysql-data-lineage\/"},"modified":"2026-07-12T02:07:05","modified_gmt":"2026-07-12T10:07:05","slug":"mysql-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/mysql-data-lineage\/","title":{"rendered":"MySQL \ub370\uc774\ud130 \uacc4\ubcf4: \ubdf0 \ubc0f ETL SQL\uc744 \ud1b5\ud55c \uc5f4 \uacc4\ubcf4 \ucd94\uc801"},"content":{"rendered":"<p><strong>MySQL \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> MySQL \ubdf0\ub97c \ud1b5\ud574 \ub370\uc774\ud130\uac00 \ud750\ub974\ub294 \ubc29\uc2dd\uc744 \uc5f4\ubcc4\ub85c \ubcf4\uc5ec\uc8fc\ub294 \ub9f5\uc785\ub2c8\ub2e4. <code>\uc0bd\uc785 ... \uc120\ud0dd<\/code> \uc791\uc5c5 \ubc0f ETL \uc2a4\ud06c\ub9bd\ud2b8: \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uac01 \ub300\uc0c1 \uc5f4\uc5d0 \uc804\ub2ec\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uc870\uc778, \ud544\ud130 \ubc0f \uc9d1\uacc4\ub97c \ud1b5\ud574 \uc804\ub2ec\ub418\ub294\uc9c0. MySQL \uc790\uccb4\ub294 \uc774\ub97c \ubcf4\uc5ec\uc904 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. <code>\uc815\ubcf4 \uc2a4\ud0a4\ub9c8<\/code> \ub370\uc774\ud130 \ud750\ub984\uc774 \uc544\ub2cc \uad6c\uc870\ub97c \uc124\uba85\ud569\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 \ud504\ub85c\uadf8\ub7a8\uc740 \uc804\uc6a9 MySQL \ubc29\uc5b8 \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud558\uc5ec MySQL SQL\uc744 \ubd84\uc11d\ud568\uc73c\ub85c\uc368 \uc790\ub3d9\uc73c\ub85c \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\uace0, \uac1c\ubcc4 \uc5f4\uae4c\uc9c0 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcfc \uc218 \uc788\ub294 \ub300\ud654\ud615 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c1\uc811 SQL\uc5d0\uc11c \ud655\uc778\ud574 \ubcf4\uc138\uc694:<\/strong> MySQL \ubdf0\ub97c \ubd99\uc5ec\ub123\uac70\ub098 <code>\uc0bd\uc785 ... \uc120\ud0dd<\/code> \uc548\uc73c\ub85c <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=mysql-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>MySQL \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900\uc758 \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\">information_schema\ub97c \uc0ac\uc6a9\ud574\ub3c4 MySQL \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc5c6\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>MySQL\uc758 <code>\uc815\ubcf4 \uc2a4\ud0a4\ub9c8<\/code> \uad6c\uc870 \uce74\ud0c8\ub85c\uadf8\uc785\ub2c8\ub2e4. \uadf8\uac83\uc740 \ub2f9\uc2e0\uc5d0\uac8c \ub2e4\uc74c\uc744 \uc54c\ub824\uc904 \uac83\uc785\ub2c8\ub2e4. <code>\uc77c\uc77c \uc218\uc775<\/code> \ub2e4\uc12f \uac1c\uc758 \uc5f4\uc774 \uc788\uace0, \uac01 \uc5f4\uc758 \uc720\ud615\uc774 \ubb34\uc5c7\uc774\uba70 (via) <code>\ud0a4 \uc5f4 \uc0ac\uc6a9\ub7c9<\/code>\uc5b4\ub5a4 \uc678\ub798 \ud0a4\uac00 \uc5b4\ub514\ub97c \uac00\ub9ac\ud0a4\ub294\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc808\ub300 \uc54c\ub824\uc8fc\uc9c0 \uc54a\ub294 \uac83\uc740 \ubc14\ub85c \uc774\uac83\uc785\ub2c8\ub2e4. <code>\uc77c\uc77c \ub9e4\ucd9c.\uc21c\ub9e4\ucd9c<\/code> \ub294 \ub2e4\uc74c\uc73c\ub85c\ubd80\ud130 \uacc4\uc0b0\ub429\ub2c8\ub2e4. <code>\uc8fc\ubb38 \uae08\uc561<\/code> \ub9c8\uc774\ub108\uc2a4 <code>\uc8fc\ubb38 \ud560\uc778<\/code>\ud544\ud130\ub9c1\ub428 <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code>\uadf8\ub9ac\uace0 \uadf8\ub8f9\ud654\ub428 <code>\uace0\uac1d \uc9c0\uc5ed<\/code>.<\/p>\n\n\n\n<p>\ub370\uc774\ud130 \ud750\ub984\uc5d0 \ub300\ud55c \uc815\ubcf4\ub294 \uc624\uc9c1 \ud55c \uacf3, \uc989 SQL \ud14d\uc2a4\ud2b8 \uc790\uccb4\uc5d0\ub9cc \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 MySQL \ud658\uacbd\uc5d0\uc11c\ub294 \ubdf0 \uc815\uc758(<code>\uc815\ubcf4 \uc2a4\ud0a4\ub9c8.\ubdf0<\/code> \ud14d\uc2a4\ud2b8\ub97c \uc800\uc7a5\ud558\uc9c0\ub9cc, \uc544\ubb34\uac83\ub3c4 \uadf8\uac83\uc744 \ud574\uc11d\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <code>\uc0bd\uc785 ... \uc120\ud0dd<\/code> \uadf8\ub9ac\uace0 <code>\uc911\ubcf5 \ud0a4 \uc5c5\ub370\uc774\ud2b8 \uc2dc<\/code> ETL \uc791\uc5c5\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 SQL \ubb38, DDL\uc5d0\uc11c \uc0dd\uc131\ub41c \uc5f4 \ud45c\ud604\uc2dd, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uce21 \ucffc\ub9ac \ud30c\uc77c \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc694\uc18c\ub4e4\uc744 SQL \uacc4\ubcf4\ub85c \ubcc0\ud658\ud558\ub824\uba74 \uc2e4\uc81c\ub85c SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uace0 \uc758\ubbf8\ub860\uc801\uc73c\ub85c \ud574\uc11d\ud558\ub294 \uc791\uc5c5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code>\uc870\uc778, \uc11c\ube0c\ucffc\ub9ac \ubc0f \ubdf0 \uc2a4\ud0dd\uc744 \ud1b5\ud574 \uc5f4\uc744 \ucd94\uc801\ud558\ub294 \uac83. \uc774\uac83\uc774 SQLFlow\uc758 \uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: INSERT-SELECT \ubb38\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uac00 \uc785\ub825\ub418\ub294 \ubcf4\uace0 \ud14c\uc774\ube14<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uc218\ucc9c \uac1c\uc758 MySQL \uae30\ubc18 \ubcf4\uace0 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub9e4\uc77c \ubc24 \uc2e4\ud589\ub418\ub294 \uba85\ub839\ubb38\uc758 \uc608\uc785\ub2c8\ub2e4. \uc774 \uba85\ub839\ubb38\uc740 \uc8fc\ubb38\uc744 \uc9d1\uacc4\ud558\uc5ec \uc694\uc57d \ud14c\uc774\ube14\uc5d0 \ucd94\uac00\ud558\ub294 \uc5c5\uc11c\ud2b8(upsert) \uc791\uc5c5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO daily_revenue (report_date, region, order_count, gross_revenue, net_revenue) SELECT o.order_date, c.region, COUNT(*), SUM(o.amount), SUM(o.amount - o.discount) FROM orders o JOIN customers c ON c.id = o.customer_id WHERE o.status = &#039;completed&#039; GROUP BY o.order_date, c.region ON DUPLICATE KEY UPDATE order_count = VALUES(order_count), gross_revenue = VALUES(gross_revenue), net_revenue = VALUES(net_revenue);<\/code><\/pre>\n\n\n\n<p>SQLFlow\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uba74 \ub300\uc0c1 \uc5f4\ubcc4\ub85c \ud574\ub2f9 \uac12\uc5d0 \uc9c1\uc811 \uac12\uc744 \uc81c\uacf5\ud558\ub294 \uc5f4\uacfc \uacb0\uacfc\uc5d0 \uc9c1\uc811 \ud3ec\ud568\ub418\uc9c0\ub294 \uc54a\uc9c0\ub9cc \uacb0\uacfc\ub97c \ubcc0\ud615\ud558\ub294 \uc5f4\uc744 \ubaa8\ub450 \ucd94\ucd9c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\ub300\uc0c1 \uc5f4<\/th><th>\uc9c1\uc811 \ucd9c\ucc98<\/th><th>\uac04\uc811\uc801 \uc601\ud5a5<\/th><\/tr><\/thead><tbody>\n<tr><td><code>\uc77c\uc77c \ub9e4\ucd9c \ubcf4\uace0\uc11c \ub0a0\uc9dc<\/code><\/td><td><code>\uc8fc\ubb38.\uc8fc\ubb38_\ub0a0\uc9dc<\/code><\/td><td><code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code><\/td><\/tr>\n<tr><td><code>\uc77c\uc77c \uc218\uc775.\uc9c0\uc5ed<\/code><\/td><td><code>\uace0\uac1d \uc9c0\uc5ed<\/code><\/td><td><code>\uace0\uac1d ID<\/code>, <code>\uc8fc\ubb38.\uace0\uac1d_ID<\/code>, <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code><\/td><\/tr>\n<tr><td><code>\uc77c\uc77c \ub9e4\ucd9c.\ucd1d \ub9e4\ucd9c<\/code><\/td><td><code>\uc8fc\ubb38 \uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569()<\/code><\/td><td><code>\uc8fc\ubb38.\uc8fc\ubb38_\ub0a0\uc9dc<\/code>, <code>\uace0\uac1d \uc9c0\uc5ed<\/code> (\uadf8\ub8f9\ud654 \uae30\uc900), \uc870\uc778 \ud0a4, <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code><\/td><\/tr>\n<tr><td><code>\uc77c\uc77c \ub9e4\ucd9c.\uc21c\ub9e4\ucd9c<\/code><\/td><td><code>\uc8fc\ubb38 \uae08\uc561<\/code>, <code>\uc8fc\ubb38 \ud560\uc778<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569()<\/code><\/td><td>\uc704\uc640 \ub3d9\uc77c<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc138 \ubc88\uc9f8 \uc5f4\uc758 \ucc28\uc774\uc810\uc740 \uc911\uc694\ud569\ub2c8\ub2e4. <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code> \uc808\ub300 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc74c <code>\uc77c\uc77c \uc218\uc775<\/code>\ud558\uc9c0\ub9cc \ub370\uc774\ud130 \uc785\ub825 \ubc29\uc2dd\uc744 \ubcc0\uacbd\ud558\uba74 \ubcf4\uace0\uc11c\uc758 \ubaa8\ub4e0 \uc218\uce58\uac00 \ubc14\ub01d\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub97c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. <strong>\uac04\uc811 \ud608\ud1b5<\/strong> (\uc5f4\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ub429\ub2c8\ub2e4) <code>\uc5b4\ub514<\/code>, <code>\uac00\uc785\ud558\ub2e4<\/code>, \uadf8\ub9ac\uace0 <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code>\ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \ubcc4\ub3c4\uc758 \ud1a0\uae00 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc73c\ub85c \ud45c\uc2dc\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \uc804\ud600 \ud558\uc9c0 \uc54a\ub294\ub370, \uc774\ub294 \uc815\ud655\ud55c \uc601\ud5a5 \ubd84\uc11d\uc744 \uc704\ud574 \ubc18\ub4dc\uc2dc \ud544\uc694\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2a4\ud0dd\ud615 \ubdf0\ub97c \ud3ec\ud568\ud55c MySQL \ubdf0\ub97c \ud1b5\ud55c \ubdf0 \uacc4\ubcf4<\/h2>\n\n\n\n<p>\ubdf0\ub294 \ud14c\uc774\ube14 \uc218\uc900\uc758 \uacc4\ubcf4 \ub3c4\uad6c\uac00 \uc870\uc6a9\ud788 \uae30\ub2a5\uc744 \ud3ec\uae30\ud558\ub294 \uc9c0\uc810\uc785\ub2c8\ub2e4. BI \ub300\uc2dc\ubcf4\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <code>v_\uc9c0\uc5ed_kpis<\/code>\ub2e4\uc74c \uc911\uc5d0\uc11c \uc120\ud0dd\ud569\ub2c8\ub2e4. <code>v_\uc644\ub8cc\ub41c_\uc8fc\ubb38<\/code>\ub2e4\uc74c \uc911\uc5d0\uc11c \uc120\ud0dd\ud569\ub2c8\ub2e4. <code>\uba85\ub839<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d<\/code>&quot;\uc774 \ub300\uc2dc\ubcf4\ub4dc \uc5f4\uc5d0 \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc785\ub825\ub418\ub294\uac00?&quot;\ub77c\ub294 \uc9c8\ubb38\uc5d0 \ub2f5\ud558\ub824\uba74, \ub370\uc774\ud130 \uacc4\ubcf4 \uc5d4\uc9c4\uc740 \ubdf0 \uc2a4\ud0dd\uc758 \ubaa8\ub4e0 \uacc4\uce35\uc744 \ud1b5\ud574 \uc5f4 \ucc38\uc870\ub97c \ud655\uc778\ud558\uace0, \ud544\uc694\ud55c \uacbd\uc6b0 \ub370\uc774\ud130\ub97c \ud655\uc7a5\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uae30\ubcf8 \uc815\uc758\uc5d0 \ubc18\ud558\uc5ec \ubcc0\ud658\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQLFlow\ub294 \uc758\ubbf8 \ubd84\uc11d\uc758 \uc77c\ud658\uc73c\ub85c \ubdf0, CTE, \uc11c\ube0c\ucffc\ub9ac \ubc0f \uc2a4\ud0c0 \ud655\uc7a5\uc744 \ud1b5\ud574 \uc5f4 \ucc38\uc870\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4. JDBC\ub97c \ud1b5\ud574 \uc2a4\ud0a4\ub9c8\ub97c \uc9c0\uc815\ud558\uba74 DDL\uacfc \ubdf0 \uc815\uc758\ub97c \uc9c1\uc811 \uac00\uc838\uc624\ubbc0\ub85c, \uacc4\ubcf4 \uadf8\ub798\ud504\ub294 \uc624\ub798\ub41c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud3f4\ub354\uc5d0 \uc788\ub294 \ubdf0\uac00 \uc544\ub2cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc2e4\uc81c\ub85c \uc874\uc7ac\ud558\ub294 \ubdf0\ub97c \ubc18\uc601\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc0dd\uc131\ub41c \uc5f4: \ub2e8\uc77c \ud14c\uc774\ube14 \ub0b4\uc758 \uacc4\ubcf4<\/h2>\n\n\n\n<p>MySQL\uc5d0\uc11c \uc0dd\uc131\ub41c \uc5f4\uc740 \ub370\uc774\ud130 \ud750\ub984\uc744 DDL\uc5d0 \uc9c1\uc811 \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE order_items ( quantity INT, unit_price DECIMAL(10,2), line_total DECIMAL(12,2) AS (quantity * unit_price) STORED );<\/code><\/pre>\n\n\n\n<p><code>\ub77c\uc778 \ud569\uacc4<\/code> \ud574\ub2f9 \uc5f4\uc740 \uc5b4\ub5a4 INSERT \ubb38\uc5d0 \uc758\ud574\uc11c\ub3c4 \uae30\ub85d\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c, DML\ub9cc \uac10\uc2dc\ud558\ub294 \uc811\uadfc \ubc29\uc2dd\uc740 \uadf8 \ucd9c\ucc98\ub97c \uc644\uc804\ud788 \ud30c\uc545\ud558\uc9c0 \ubabb\ud569\ub2c8\ub2e4. SQLFlow\ub294 \uc0dd\uc131\ub41c \uc5f4 \ud45c\ud604\uc2dd\uc744 SQL\ub85c \ud30c\uc2f1\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. <code>\ub77c\uc778 \ud569\uacc4<\/code> \uc801\uc808\ud55c \uacc4\ubcf4 \uc5e3\uc9c0\ub97c \uc5bb\uc2b5\ub2c8\ub2e4. <code>\uc218\ub7c9<\/code> \uadf8\ub9ac\uace0 <code>\ub2e8\uac00<\/code>\uadf8\ub9ac\uace0 \uadf8 \ud558\ub958\uc5d0\uc11c \uc77d\ub294 \ubaa8\ub4e0 \uac83 <code>\ub77c\uc778 \ud569\uacc4<\/code> \ubaa8\ub4e0 \ucd94\uc801\uc740 \uadf8 \ub450 \uac1c\uc758 \ubb3c\ub9ac\uc801 \uae30\ub465\uae4c\uc9c0 \uac70\uc2ac\ub7ec \uc62c\ub77c\uac11\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\ub97c \uc0ac\uc6a9\ud558\uc5ec MySQL \ub9ac\ub2c8\uc9c0\ub97c \uad6c\ucd95\ud558\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<ol><li><strong>SQL\uc744 \uc218\uc9d1\ud558\uc138\uc694.<\/strong> \uba85\ub839\ubb38\uc744 \ubd99\uc5ec\ub123\uac70\ub098 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-%ed%81%b4%eb%9d%bc%ec%9a%b0%eb%93%9c\/\">SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a>\ub610\ub294 JDBC\ub97c \ud1b5\ud574 MySQL \uc778\uc2a4\ud134\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uc5ec SQLFlow\uac00 DDL \ubc0f \ubdf0 \uc815\uc758\ub97c \uc9c1\uc811 \uc77d\ub3c4\ub85d \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. dbt \uc0ac\uc6a9\uc790\ub294 dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>MySQL \ubc29\uc5b8\uc744 \uc0ac\uc6a9\ud558\uc5ec \uad6c\ubb38 \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/strong> SQLFlow\ub294 \ubc29\uc5b8\ubcc4 MySQL \ud30c\uc11c(\uc77c\ubc18\uc801\uc778 ANSI \ubb38\ubc95\uc774 \uc544\ub2cc 39\uac1c \ubc29\uc5b8 \ud30c\uc11c \uc911 \ud558\ub098)\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c MySQL \uad00\ub828 \uad6c\ubb38(\uc608: <code>\uc911\ubcf5 \ud0a4 \uc5c5\ub370\uc774\ud2b8 \uc2dc<\/code>\ubc31\ud2f1\uc73c\ub85c \ubb36\uc778 \uc2dd\ubcc4\uc790\uc640 \uc0dd\uc131\ub41c \uc5f4\uc740 \uac74\ub108\ub6f0\uc9c0 \uc54a\uace0 \uc62c\ubc14\ub974\uac8c \ubd84\uc11d\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ud0d0\uc0c9\ud558\uace0 \ub0b4\ubcf4\ub0b4\uae30.<\/strong> \ub300\ud654\ud615 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \ubaa8\ub4e0 \uc5f4\uc758 \uc0c1\uc704 \ub610\ub294 \ud558\uc704 \uacbd\ub85c\ub97c \ucd94\uc801\ud558\uace0, \uac04\uc811 \uacc4\ubcf4 \uae30\ub2a5\uc744 \ucf1c\uac70\ub098 \ub04c \uc218 \uc788\uc73c\uba70, \uadf8\ub798\ud504\ub97c JSON, CSV \ub610\ub294 PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uac70\ub098 REST API\ub97c \ud1b5\ud574 \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\uc2dd\uc73c\ub85c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc84\uc804 8.2.3\ubd80\ud130\ub294 &quot;\uc5b4\ub5a4 \ubcf4\uace0\uc11c\uac00 \ub2e4\uc74c\uc5d0 \uc758\uc874\ud558\ub098\uc694?&quot;\uc640 \uac19\uc740 \uc77c\ubc18\uc801\uc778 \uc9c8\ubb38\ub3c4 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\uace0\uac1d \uc9c0\uc5ed<\/code>AI\uac00 \uc778\uc6a9\ud558\ub294 \ubaa8\ub4e0 \ud45c\uc640 \uc5f4\uc740 \ud45c\uc2dc\ud558\uae30 \uc804\uc5d0 \ubd84\uc11d\ub41c \uadf8\ub798\ud504\uc640 \ube44\uad50\ud558\uc5ec \uc720\ud6a8\uc131\uc744 \uac80\uc0ac\ud569\ub2c8\ub2e4.<\/li><\/ol>\n\n\n\n<p>\uc544\ub798\ucabd\uc5d0 \uc788\ub294 \uc5d4\uc9c4\uc740 <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c<\/a>, a commercial SQL compiler front-end developed since the mid-2000s and validated against roughly 13,600 per-dialect SQL test fixtures. Lineage quality is a parsing problem before it is anything else, and that regression corpus is what keeps real-world MySQL \u2014 with all its dialect quirks \u2014 from silently falling out of the graph.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc624\ud508\uc18c\uc2a4 MySQL \ub9ac\ub2c8\uc9c0 \uc635\uc158\uc740 \uc5b4\ub5a4\uac00\uc694?<\/h2>\n\n\n\n<p>\uc624\ud508\uc18c\uc2a4 \ud30c\uc11c(\uc608: ...) <code>sqllineage<\/code> \uadf8\ub9ac\uace0 <code>sqlglot<\/code> MySQL\uc758 \uac1c\ubcc4 SELECT \ubc0f INSERT \ubb38\uc744 \uc798 \ucc98\ub9ac\ud558\uba70, Python \ud30c\uc774\ud504\ub77c\uc778 \ub0b4\uc5d0\uc11c \uba87 \uac1c\uc758 \uac04\ub2e8\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 \uc2dc\uc791\ud558\uae30\uc5d0 \uc801\ud569\ud55c \ud50c\ub7ab\ud3fc\uc785\ub2c8\ub2e4. DataHub \ubc0f OpenMetadata\uc640 \uac19\uc740 \uce74\ud0c8\ub85c\uadf8 \ud50c\ub7ab\ud3fc\uc740 \uc77c\ub2e8 \ub370\uc774\ud130 \uacc4\ubcf4\uac00 \uc0dd\uc131\ub418\uba74 \uc774\ub97c \uad6c\uc131\ud558\uace0 \ud45c\uc2dc\ud558\ub294 \ub370 \ud0c1\uc6d4\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub300\uaddc\ubaa8 \ud658\uacbd\uc5d0\uc11c \ud558\ub4dc SQL \ucffc\ub9ac\ub85c\ubd80\ud130 \uc815\ud655\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc0dd\uc131\ud558\ub294 \ub370\uc5d0\ub294 \ud55c\uacc4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \uc2e4\uc2dc\uac04 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\ub294 \uc2a4\ud0dd\ud615 \ubdf0\ub97c \ud1b5\ud574 \uc5f4\uc744 \ud574\uc11d\ud558\uace0, \uc9c1\uc811 \uacc4\ubcf4\uc640 \uac04\uc811 \uacc4\ubcf4\ub97c \uad6c\ubd84\ud558\uba70, \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud655\uc7a5\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc218\ucc9c \uac1c\uc758 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \uac78\uccd0 \uc815\ud655\ud558\uac8c \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub7ec\ud55c \ucd94\ucd9c \ubb38\uc81c\uc5d0 \uc9d1\uc911\ud55c \ub2e4\uc74c DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \ud1b5\ud574 \uacb0\uacfc\ub97c \uce74\ud0c8\ub85c\uadf8\uc5d0 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL\uc774 \uc804\uccb4 \uadf8\ub9bc\uc758 \uc77c\ubd80\uc77c \ubfd0\uc77c \ub54c<\/h2>\n\n\n\n<p>MySQL\uc740 \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \uacbd\uc6b0\ub294 \ub4dc\ubb45\ub2c8\ub2e4. \uc885\uc885 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uad6c\ucd95\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 OLTP \uc18c\uc2a4\uc774\uac70\ub098, ETL \ub808\uc774\uc5b4\uc5d0\uc11c \uc5ec\ub7ec \uc5d4\uc9c4 \uc911 \ud558\ub098\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. SQLFlow\ub294 \ub3d9\uc77c\ud55c \uc5f4 \uc218\uc900 \ubd84\uc11d\uc744 \ud1b5\ud574 39\uac00\uc9c0 SQL \ubc29\uc5b8\uc744 \ubd84\uc11d\ud558\ubbc0\ub85c MySQL\uc5d0\uc11c \uc2dc\uc791\ud558\uc5ec Snowflake, BigQuery \ub610\ub294 \uae30\ud0c0 \uc5d4\uc9c4\uc73c\ub85c \ub05d\ub098\ub294 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ed%8f%ac%ec%8a%a4%ed%8a%b8%ea%b7%b8%eb%a0%88%ec%8a%a4-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">\ud3ec\uc2a4\ud2b8\uadf8\ub808\uc2a4 SQL<\/a> \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \ud558\ub098\uc758 \uadf8\ub798\ud504\uc5d0 \uc800\uc7a5\ub429\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\ud558\uace0, \uc99d\ubd84 \uc2a4\uce94 \ubc0f \uc601\uad6c\uc801\uc778 \ub370\uc774\ud130 \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4. SQL \ud14d\uc2a4\ud2b8\uac00 \ub124\ud2b8\uc6cc\ud06c \uc678\ubd80\ub85c \uc720\ucd9c\ub418\ub294 \uac83\uc744 \ud5c8\uc6a9\ud560 \uc218 \uc5c6\ub294 \ud300\uc5d0\uac8c \uc801\ud569\ud569\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a> Docker \ub610\ub294 Kubernetes\uc5d0\uc11c \uc644\uc804\ud788 \uaca9\ub9ac\ub41c \uc0c1\ud0dc\ub85c \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2e4\uc81c \uad6c\ubb38(\ub2e4\uc911 \uc870\uc778 \uc0bd\uc785, \ubdf0 \uc2a4\ud0dd, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ub4f1)\uc5d0\uc11c \ucd9c\ub825 \uacb0\uacfc\uac00 \uc5b4\ub5bb\uac8c \ub098\ud0c0\ub098\ub294\uc9c0 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <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>.<\/p>\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\">MySQL \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub824\uba74 \ub0b4 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uba70, \uc120\ud0dd\uc801\uc73c\ub85c \ud14c\uc774\ube14 \ubc0f \ubdf0 \uc815\uc758\uc640 \uac19\uc740 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub3c4 \ubd84\uc11d\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 INSERT, SELECT, ON DUPLICATE KEY UPDATE \uad6c\ubb38\uc744 \ud1b5\ud574 \ucd94\uc801 \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. MySQL \ubc29\uc5b8 \ud30c\uc11c\ub294 \uc804\uccb4 \ubb38\uc7a5\uc744 \ubd84\uc11d\ud569\ub2c8\ub2e4. \uac01 \ub300\uc0c1 \uc5f4\uc740 SELECT \ubb38\uc758 \uc18c\uc2a4 \uc5f4\uacfc \uc5f0\uacb0\ub418\uba70, \uc9d1\uacc4 \ud568\uc218 \ub0b4\uc758 \ud45c\ud604\uc2dd\ub3c4 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ub610\ud55c upsert \uc808\uc740 \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ud750\ub984\uc758 \uc77c\ubd80\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">information_schema\uc5d0 \uacc4\ubcf4 \uc815\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. <code>\uc815\ubcf4 \uc2a4\ud0a4\ub9c8<\/code> \ud14c\uc774\ube14, \uc5f4, \uc720\ud615, \ud0a4 \ubc0f \ubdf0 \uc815\uc758\uc758 \uc6d0\uc2dc \ud14d\uc2a4\ud2b8\uc640 \uac19\uc740 \uad6c\uc870\ub97c \uc124\uba85\ud569\ub2c8\ub2e4. SQL\uc744 \ud574\uc11d\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ud2b9\uc815 \ub300\uc0c1 \uc5f4\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc0ac\uc6a9\ub418\uc5c8\ub294\uc9c0 \uc54c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ubdf0 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\ub824\uba74 \ubdf0\uc640 DML SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud574\uc57c \ud558\uba70, SQLFlow\uac00 \ubc14\ub85c \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 MySQL \ubdf0\uc5d0\uc11c SELECT *\ub97c \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\ub098\uc694?<\/h3>\n\n\n<p>SQLFlow \ud655\uc7a5 <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc2e4\uc81c \uc2a4\ud0a4\ub9c8(JDBC\uc5d0\uc11c \uac00\uc838\uc624\uac70\ub098 DDL\ub85c \uc81c\uacf5\ub428)\ub97c \uae30\uc900\uc73c\ub85c \ud558\ubbc0\ub85c \uc2a4\ud0c0 \uad6c\uc870\ub97c \ud1b5\uacfc\ud558\ub294 \ubaa8\ub4e0 \uc5f4\uc740 \ubaa8\ud638\ud55c \ud14c\uc774\ube14 \uac04 \ud654\uc0b4\ud45c \ub300\uc2e0 \uace0\uc720\ud55c \uacc4\ubcf4\ub97c \uac16\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ubb34\ub8cc\ub85c \uccb4\ud5d8\ud574 \ubcfc \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uc788\uc744\uae4c\uc694?<\/h3>\n\n\n<p>\ub124. SQLFlow Cloud\ub294 \ubb34\ub8cc \ud2f0\uc5b4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ube0c\ub77c\uc6b0\uc800\uc5d0 MySQL SQL\uc744 \ubd99\uc5ec\ub123\uc73c\uba74 \uc989\uc2dc \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud504\ub9ac\ubbf8\uc5c4\uc740 \uc6d4 $49.99\uc774\uba70, \uc628\ud504\ub808\ubbf8\uc2a4\ub294 \uc6d4 $500 \ub610\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 1\ud68c $4,800\uc785\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. JSON, CSV \ub610\ub294 PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uac70\ub098, REST API\ub97c \ucffc\ub9ac\ud558\uac70\ub098, \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ud658\uacbd\uc5d0\uc11c DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\uc7a5 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uc9c0\uae08 \ubc14\ub85c MySQL \ub370\uc774\ud130 \ud750\ub984\uc744 \ub9e4\ud551\ud558\uc138\uc694<\/h2>\n\n\n<p>\ubdf0 \ub610\ub294 INSERT-SELECT \ubb38\uc744 \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, \uc804\uccb4 MySQL \ud658\uacbd\uc744 \ubd84\uc11d\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uc800\ud76c\uc640 \uc0c1\ub2f4\ud574 \ubcf4\uc138\uc694.<\/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=mysql-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n<\/div>\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:\/\/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\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/mysql-data-lineage\\\/\",\n            \"description\": \"Automated MySQL data lineage: SQLFlow parses MySQL views, INSERT-SELECT ETL, and generated columns with a dedicated MySQL dialect parser to produce interactive column-level lineage diagrams.\",\n            \"featureList\": \"MySQL dialect parser, column-level lineage, indirect\\\/impact lineage, view resolution, SELECT * expansion, generated column lineage, JDBC metadata import, REST API, DataHub\\\/Purview\\\/OpenMetadata export\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\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\": \"Does building MySQL lineage require access to my data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and, optionally, schema metadata such as table and view definitions. It never reads table row data. With the On-Premise edition, even the SQL text stays inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through INSERT ... SELECT ... ON DUPLICATE KEY UPDATE?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. The MySQL dialect parser analyzes the full statement: each target column is linked to the source columns in the SELECT, including expressions inside aggregates, and the upsert clause is handled as part of the same dataflow.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does information_schema contain lineage information?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. information_schema describes structure: tables, columns, types, keys, and the raw text of view definitions. It does not interpret any SQL, so it cannot tell you which source columns feed a given target column. Lineage requires parsing the view and DML SQL, which is what SQLFlow does.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How does SQLFlow handle SELECT * in MySQL views?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow expands SELECT * against the actual schema, pulled over JDBC or supplied as DDL, so every column that flows through the star gets its own lineage edge instead of one vague table-to-table arrow.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is there a free way to try MySQL data lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow Cloud has a free tier: paste MySQL SQL in the browser and get the column-level diagram immediately. Premium is $49.99\\\/month; On-Premise is $500\\\/month or $4,800 one-time per selected database type.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I export the MySQL lineage into my data catalog?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Export as JSON, CSV, or PNG, query the REST API, or use the built-in export adapters for DataHub, Microsoft Purview, and OpenMetadata in enterprise deployments.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>MySQL data lineage is the column-by-column map of how data flows through your MySQL views, INSERT &#8230; SELECT jobs, and ETL scripts: which source columns feed each target column, and through which joins, filters, and aggregations. MySQL itself cannot show you this \u2014 information_schema describes structure, not dataflow. Gudu SQLFlow builds the lineage automatically by parsing your MySQL SQL with a dedicated MySQL dialect parser, producing an interactive, drillable diagram down to individual columns. See it on your own SQL: paste any MySQL view or INSERT &#8230; SELECT into the free SQLFlow lineage visualizer, pick the MySQL dialect, and get\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\/6757"}],"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=6757"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6757\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}