{"id":6760,"date":"2026-07-12T02:07:29","date_gmt":"2026-07-12T10:07:29","guid":{"rendered":"https:\/\/www.gudusoft.com\/azure-sql-data-lineage\/"},"modified":"2026-07-12T02:07:29","modified_gmt":"2026-07-12T10:07:29","slug":"azure-sql-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/azure-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"Azure SQL \ub370\uc774\ud130 \uacc4\ubcf4: Azure SQL \ubc0f Synapse SQL\uc6a9 \uc5f4 \uacc4\ubcf4"},"content":{"rendered":"<p><strong>Azure SQL \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> Azure SQL Database, Azure SQL Managed Instance \ubc0f Synapse SQL\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 T-SQL \ucf54\ub4dc\ub97c \ud1b5\ud574 \ub370\uc774\ud130\uac00 \ud750\ub974\ub294 \ubc29\uc2dd\uc744 \uc5f4\ubcc4\ub85c \ubcf4\uc5ec\uc8fc\ub294 \ub9f5\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc5b4\ub5a4 \ubdf0, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, \uc870\uc778 \ubc0f \ud568\uc218\ub97c \uac70\uccd0 \uac01 \ub300\uc0c1 \uc5f4\uc5d0 \ub370\uc774\ud130\ub97c \uc804\ub2ec\ud558\ub294\uc9c0 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774 \ub9f5\uc744 \uac00\uc7a5 \uc815\ud655\ud558\uac8c \uad6c\ucd95\ud558\ub294 \ubc29\ubc95\uc740 T-SQL \ucf54\ub4dc \uc790\uccb4\ub97c \uad6c\ubb38 \ubd84\uc11d\ud558\ub294 \uac83\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\/\">Gudu SQLFlow<\/a> \uc774 \uae30\ub2a5\uc740 \uc804\uc6a9 Azure SQL \ubc29\uc5b8 \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc815\ud655\ud788 \uadf8 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uba70, \uacb0\uacfc\ub85c \uc0dd\uc131\ub41c \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub97c Microsoft Purview\ub85c \ud478\uc2dc\ud558\uc5ec \ub098\uba38\uc9c0 Azure \ud658\uacbd\uacfc \ud568\uaed8 \ud45c\uc2dc\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:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>30\ucd08 \uc548\uc5d0 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> Azure SQL \ucffc\ub9ac \ub610\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \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=azure-sql-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>Azure SQL \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \uc5d0\ub514\uc158\uc740 \ubb34\ub8cc \ud2f0\uc5b4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Azure SQL \ub370\uc774\ud130 \uacc4\ubcf4\uc5d0\uc11c \uad6c\ubb38 \ubd84\uc11d \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>Azure\uc5d0\uc11c \uc2e4\uc81c\ub85c \ub370\uc774\ud130\ub97c \ubcc0\ud615\ud558\ub294 \ubcc0\ud658 \ub85c\uc9c1\uc740 \ud30c\uc774\ud504\ub77c\uc778 \uc815\uc758\uc5d0 \uc788\ub294 \uacbd\uc6b0\uac00 \ub4dc\ubb45\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub85c\uc9c1\uc740 T-SQL\uc5d0 \uc788\uc73c\uba70, \ubdf0 \uc704\uc5d0 \ubdf0\ub97c \uacc4\uce35\ud654\ud558\uac70\ub098 Azure Data Factory \ud65c\ub3d9\uc5d0\uc11c \ud638\ucd9c\ub418\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ub4f1\uc5d0 \uc874\uc7ac\ud569\ub2c8\ub2e4. <code>\ubcd1\ud569<\/code> \uc2e4\ud589 \uc911\uc5d0 \uc0dd\uc131\ub418\ub294 \ubb38\uc7a5, \uc784\uc2dc \ud14c\uc774\ube14 \ubc0f \ub3d9\uc801 SQL. \ud30c\uc774\ud504\ub77c\uc778 \uba54\ud0c0\ub370\uc774\ud130\ub9cc\uc73c\ub85c \uad6c\ucd95\ub41c \uacc4\ubcf4 \uadf8\ub9bc\uc740 \uc0c1\uc790\ub9cc \ubcf4\uc5ec\uc904 \ubfd0 \uadf8 \uc548\uc5d0\uc11c \ubb34\uc2a8 \uc77c\uc774 \uc77c\uc5b4\ub098\ub294\uc9c0\ub294 \ubcf4\uc5ec\uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\uac83\uc744 \uc54c\uae30 \uc704\ud574 <code>\ubcf4\uace0\uc11c.\uc6d4\uac04_\uc218\uc775<\/code> \ub2e4\uc74c\uacfc \uac19\uc774 \uacc4\uc0b0\ub429\ub2c8\ub2e4. <code>SUM(\uc8fc\ubb38 \uc218\ub7c9)<\/code> \ud544\ud130\ub9c1\ub428 <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\ucc98\ub7fc SQL\uc744 \uc77d\ub294 \ubb34\uc5b8\uac00\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uc989, CTE, \uc11c\ube0c\ucffc\ub9ac, \ubdf0 \ub4f1\uc744 \ud1b5\ud574 \ubaa8\ub4e0 \uc5f4 \ucc38\uc870\ub97c \ud574\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5\uc744 \uc218\ud589\ud55c \ub2e4\uc74c \uc18c\uc2a4 \uc5f4\uc5d0\uc11c \ub300\uc0c1 \uc5f4\ub85c\uc758 \ub370\uc774\ud130 \ud750\ub984\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4. \uc774\uac83\uc774 \uc815\uc801 SQL \ubd84\uc11d\uc774\uba70, SQLFlow\uac00 \uc124\uacc4\ub41c \ubaa9\uc801\uc785\ub2c8\ub2e4. SQLFlow\ub294 SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub9cc \uc77d\uace0 \ud14c\uc774\ube14\uc758 \ud589\uc5d0\ub294 \uc808\ub300 \uc811\uadfc\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Microsoft Purview\uac00 \ud55c\uacc4\ub97c \ub4dc\ub7ec\ub0b4\ub294 \uc9c0\uc810\uacfc \ud30c\uc2f1\uc774 \uadf8 \uacf5\ubc31\uc744 \uba54\uc6b0\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<p>Microsoft Purview\ub294 \uce74\ud0c8\ub85c\uadf8 \uc911\uc2ec \ud50c\ub7ab\ud3fc\uc774 \ud574\uc57c \ud560 \uc77c\uc744 \uc815\ub9d0 \uc798 \ud574\ub0c5\ub2c8\ub2e4. Azure \ud658\uacbd \uc804\uccb4\uc758 \uc790\uc0b0\uc744 \uc2a4\uce94\ud558\uace0 \ubd84\ub958\ud558\uace0, \ubbfc\uac10\ud55c \ub370\uc774\ud130\ub97c \ub9e4\ud551\ud558\uace0, Azure Data Factory \ubc0f Synapse \ud30c\uc774\ud504\ub77c\uc778\uacfc \uac19\uc740 \ud1b5\ud569\ub41c \ub370\uc774\ud130 \uc774\ub3d9 \ub3c4\uad6c\uc758 \uacc4\ubcf4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. Azure\ub97c \uc5b4\ub5a4 \uaddc\ubaa8\ub85c \uc6b4\uc601\ud558\ub4e0 Purview\ub294 \uacc4\ubcf4\ub97c \uad00\ub9ac\ud558\uae30\uc5d0 \uc801\ud569\ud55c \uacf3\uc785\ub2c8\ub2e4. <em>\ud45c\uc2dc\ub41c<\/em>.<\/p>\n\n\n\n<p>\uaca9\ucc28\ub294 \ud608\ud1b5\uc774 \ud615\uc131\ub418\ub294 \ubc29\uc2dd\uc5d0 \uc788\ub2e4. <em>\uacc4\uc0b0\ub41c<\/em>Purview\uc758 \uc790\ub3d9\ud654\ub41c SQL \uacc4\ubcf4\uc5d0\ub294 \ubcf5\uc7a1\ud55c T-SQL, \uc989 \uc81c\uc5b4 \ud750\ub984\uc774 \uc788\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, \uc784\uc2dc \ud14c\uc774\ube14 \uc2a4\ud14c\uc774\uc9d5 \ubc0f \ub3d9\uc801 SQL\uc5d0 \ub300\ud55c \uae30\ub2a5\uc774 \ubd80\uc871\ud569\ub2c8\ub2e4. <code>sp_executesql<\/code> \uc790\ub3d9\ud654\ub41c \ubd84\uc11d \ubc94\uc704\uac00 \ubd80\uc871\ud558\uace0 \uacc4\ud1b5 \uc815\ubcf4\uc758 \uac00\uc7a5\uc790\ub9ac\uac00 \uc0ac\ub77c\uc9c0\ub294 \uacf3\uc774 \ubc14\ub85c \uadf8\ub7f0 \uacf3\uc785\ub2c8\ub2e4. \ub610\ud55c \uac00\uc7a5 \uc704\ud5d8\ud55c \ubcc0\uc774\uac00 \ubc1c\uc0dd\ud558\ub294 \uacf3\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud6a8\uc728\uc801\uc778 \uc5c5\ubb34 \ubd84\ub2f4 \ubc29\uc2dd: SQLFlow\ub294 T-SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uace0 \ud504\ub85c\uc2dc\uc800 \ubc0f \ub3d9\uc801 SQL\uc744 \ud3ec\ud568\ud558\uc5ec \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uacc4\uc0b0\ud55c \ub2e4\uc74c Microsoft Purview \uc5b4\ub311\ud130\ub97c \ud1b5\ud574 \ub0b4\ubcf4\ub0c5\ub2c8\ub2e4. SQLFlow\ub294 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uace0 Purview\ub294 \uc804\uccb4 \uc2dc\uc2a4\ud15c\uc5d0 \ub300\ud55c \ud45c\uc2dc\ub97c \ub2f4\ub2f9\ud569\ub2c8\ub2e4. \ud558\ub098\uc758 \uce74\ud0c8\ub85c\uadf8\ub9cc \uc720\uc9c0\ud558\uba74 SQL \uad00\ub828 \ubd80\ubd84\uc774 \ub354 \uc774\uc0c1 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\uac00 Azure SQL \ucf54\ub4dc\uc5d0\uc11c \ucd94\ucd9c\ud558\ub294 \ub0b4\uc6a9<\/h2>\n\n\n\n<p>SQLFlow\ub294 \ud558\ub098\uc758 \uc77c\ubc18\uc801\uc778 ANSI \ubb38\ubc95 \ub300\uc2e0 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\uba70, Azure SQL\uc740 SQL Server\uc640 \ud568\uaed8 T-SQL \uacc4\uc5f4\uc5d0 \uc18d\ud569\ub2c8\ub2e4. Synapse \uc804\uc6a9 SQL \ud480\ub3c4 T-SQL\uc744 \uc0ac\uc6a9\ud558\ubbc0\ub85c Synapse SQL \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\ub3c4 \ub3d9\uc77c\ud55c \ubd84\uc11d\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4. Azure SQL \ucf54\ub4dc\uc758 \uacbd\uc6b0 SQLFlow\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uceec\ub7fc \uc218\uc900 \uacc4\ubcf4:<\/strong> \uac01 \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 \uadf8 \uc0ac\uc774\uc5d0 \uc0ac\uc6a9\ub41c \ud568\uc218, \ud615\ubcc0\ud658, \uc11c\ube0c\ucffc\ub9ac, \uc870\uc778 \ubc0f \uc9d1\ud569 \uc5f0\uc0b0\uc790\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4. \ucc38\uc870\ub294 CTE, \ubdf0, \uc11c\ube0c\ucffc\ub9ac \ubc0f \uc2a4\ud0c0 \ud655\uc7a5\uc744 \ud1b5\ud574 \ud574\uacb0\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\uc9c1\uc811 \ud608\ud1b5 vs \uac04\uc811 \ud608\ud1b5:<\/strong> \uc0ac\uc6a9\ub418\ub294 \uc5f4 <code>\uc5b4\ub514<\/code> \uc808, <code>\uac00\uc785\ud558\ub2e4<\/code> \uc0c1\ud0dc, \ub610\ub294 <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code> \ucd9c\ub825 \uacb0\uacfc\uc5d0\ub294 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc \ucd9c\ub825 \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub97c \ubcc4\ub3c4\uc758 \ud1a0\uae00 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc73c\ub85c \ubaa8\ub378\ub9c1\ud558\ubbc0\ub85c \uc601\ud5a5 \ubd84\uc11d\uc5d0\uc11c \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ub3c4\uad6c\uac00 \ubb34\uc2dc\ud558\ub294 \ud544\ud130 \uc5f4\uc744 \ud3ec\ucc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \uacc4\ubcf4:<\/strong> T-SQL \uacc4\uc5f4 \uc804\uc6a9 \uc808\ucc28 \ud30c\uc11c\ub294 \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218\uc640 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud55c \ub370\uc774\ud130 \ud750\ub984\uc744 \ucd94\uc801\ud558\uace0 \uc5b4\ub5a4 \ud504\ub85c\uc2dc\uc800\uac00 \uc5b4\ub5a4 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \ub300\ud654\ud615 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub3d9\uc801 SQL \ud574\uacb0:<\/strong> \ud504\ub85c\uc2dc\uc800 \ub0b4\uc5d0\uc11c SQL\uc774 \uad6c\uc131\ub418\uace0 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>\uc784\uc6d0<\/code> \ub610\ub294 <code>sp_executesql<\/code> \uac74\ub108\ub6f0\ub294 \ub300\uc2e0 \ud574\uacb0\ud558\uace0 \ubd84\uc11d\ud569\ub2c8\ub2e4. \uc774\ub294 \uc790\ub3d9\ud654\ub41c \uacc4\ubcf4 \ubd84\uc11d\uc5d0\uc11c \uac00\uc7a5 \ud754\ud55c \uc0ac\uac01\uc9c0\ub300\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>DDL\uc5d0\uc11c \uc0dd\uc131\ub41c ER \ub2e4\uc774\uc5b4\uadf8\ub7a8:<\/strong> \ud14c\uc774\ube14 \uc815\uc758\uc5d0\uc11c \ucd94\ub860\ub41c \uae30\ubcf8 \ud0a4 \ubc0f \uc678\ub798 \ud0a4 \uad00\uacc4\ub97c \uc5d4\ud2f0\ud2f0-\uad00\uacc4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc73c\ub85c \ub098\ud0c0\ub0b8 \uac83\uc785\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc785\ub825\uc740 \ubd99\uc5ec\ub123\uc740 SQL, \uc5c5\ub85c\ub4dc\ub41c \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c \ub610\ub294 JDBC\ub97c \ud1b5\ud574 \uac00\uc838\uc628 \uc2e4\uc2dc\uac04 \uba54\ud0c0\ub370\uc774\ud130\uc77c \uc218 \uc788\uc73c\ubbc0\ub85c SQLFlow\ub97c Azure SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uc5ec \ubdf0 \ubc0f \ud504\ub85c\uc2dc\uc800 \uc815\uc758\ub97c \uc9c1\uc811 \uc218\uc9d1\ud558\ub3c4\ub85d \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: \ub3d9\uc801 SQL\uc744 \uc0ac\uc6a9\ud558\ub294 T-SQL \ud504\ub85c\uc2dc\uc800<\/h2>\n\n\n\n<p>\uc790\ub3d9\ud654\ub41c \uacc4\ubcf4 \uc2a4\uce90\ub108\ub97c \ubb34\ub825\ud654\uc2dc\ud0a4\ub294 \uc808\ucc28\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ub97c \uc784\uc2dc \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c \ub2e4\uc74c \ucd5c\uc885 \ud14c\uc774\ube14\uc744 \uad6c\ucd95\ud569\ub2c8\ub2e4. <code>\ub07c\uc6cc \ub123\ub2e4<\/code> \ubb38\uc790\uc5f4\ub85c \uc778\uc2dd\ud558\uc5ec \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PROCEDURE dbo.usp_refresh_regional_sales @region NVARCHAR(50) AS BEGIN SELECT o.customer_id, SUM(o.amount) AS total_amount INTO #staged FROM dbo.orders AS o WHERE o.region = @region GROUP BY o.customer_id; DECLARE @sql NVARCHAR(MAX) = N&#039; INSERT INTO dbo.regional_sales (customer_id, customer_name, total_amount) SELECT s.customer_id, c.customer_name, s.total_amount FROM #staged AS s JOIN dbo.customers AS c ON c.customer_id = s.customer_id;&#039;; EXEC sp_executesql @sql; END<\/code><\/pre>\n\n\n\n<p>\ud504\ub85c\uc2dc\uc800 \uacbd\uacc4\uc5d0\uc11c \uba48\ucd94\ub294 \uc2a4\uce90\ub108\ub294 \uc5ec\uae30\uc11c \uc720\uc6a9\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub300\uc0c1 \ud14c\uc774\ube14\uc740 \ubb38\uc790\uc5f4 \ub9ac\ud130\ub7f4 \ub0b4\ubd80\uc5d0\ub9cc \ub098\ud0c0\ub098\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SQLFlow\ub294 \ud504\ub85c\uc2dc\uc800 \ubcf8\ubb38\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uace0 \ub3d9\uc801 SQL\uc744 \ud574\uc11d\ud55c \ud6c4 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud55c \ub370\uc774\ud130 \ud750\ub984\uc744 \ub530\ub77c\uac00\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><code>\uc9c0\uc5ed\ubcc4 \ub9e4\ucd9c \ucd1d\uc561<\/code> \u2190 <code>SUM(\uc8fc\ubb38 \uc218\ub7c9)<\/code>, \uc744 \ud1b5\ud574 <code>#staged.total_amount<\/code> (\uc9c1\uacc4 \ud608\ud1b5).<\/li>\n<li><code>\uc9c0\uc5ed \ud310\ub9e4.\uace0\uac1d \uc774\ub984<\/code> \u2190 <code>\uace0\uac1d.\uace0\uac1d_\uc774\ub984<\/code> (\uc9c1\uacc4 \ud608\ud1b5).<\/li>\n<li><code>\uc8fc\ubb38.\uc9c0\uc5ed<\/code> \uadf8\ub9ac\uace0 \uc870\uc778 \ud0a4 <code>\uace0\uac1d.\uace0\uac1d_ID<\/code> \/ <code>\uc8fc\ubb38.\uace0\uac1d_ID<\/code> \uac04\uc811 \uacc4\ubcf4\ub85c \ud45c\uc2dc\ub428: \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uace0 \uacb0\uacfc\ub97c \ud544\ud130\ub9c1\ud558\uace0 \uc5f0\uacb0\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc774\ub984 \ubcc0\uacbd <code>\uc8fc\ubb38.\uc9c0\uc5ed<\/code> \ud30c\uc774\ud504\ub77c\uc778 \uba54\ud0c0\ub370\uc774\ud130 \uad00\uc810\uc5d0\uc11c \ubcf4\uba74 \uc544\ubb34\uac83\ub3c4 \uadf8\uac83\uc5d0 \uc758\uc874\ud558\uc9c0 \uc54a\ub294 \uac83\ucc98\ub7fc \ubcf4\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud30c\uc2f1\ub41c \uad00\uc810\uc5d0\uc11c \ubcf4\uba74 \uc774 \ud504\ub85c\uc2dc\uc800\ub294 \uc544\ubb34\ub7f0 \uacbd\uace0 \uc5c6\uc774 \ube48 \ud14c\uc774\ube14\uc744 \uc0c8\ub85c \uace0\uce58\uae30 \uc2dc\uc791\ud569\ub2c8\ub2e4. \uc774\uac83\uc774 \ubc14\ub85c \uceec\ub7fc \uc218\uc900\uc758 \uacc4\ubcf4\uac00 \ub9cc\ub4e4\uc5b4\ub0b4\ub294 \ucc28\uc774\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Microsoft Purview\uc5d0 \uacc4\ubcf4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/h2>\n\n\n\n<p>\uc5d4\ud130\ud504\ub77c\uc774\uc988 SQLFlow \ubc30\ud3ec\uc5d0\ub294 Microsoft Purview, DataHub \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. Azure \ud658\uacbd\uc5d0\uc11c\uc758 \uc6cc\ud06c\ud50c\ub85c\ub294 \uac04\ub2e8\ud569\ub2c8\ub2e4. SQLFlow\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc77c\uad04 \uc2a4\uce94\ud558\uace0(\uc99d\ubd84 \uc2a4\uce94 \ubc0f \uc601\uad6c \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \ud1b5\ud574 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \uac00\uc9c4 \ud658\uacbd\uae4c\uc9c0 \ud655\uc7a5 \uac00\ub2a5), \uc2e4\uc81c T-SQL\uc5d0\uc11c \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub97c \uacc4\uc0b0\ud55c \ub2e4\uc74c Purview\uc5d0 \uac8c\uc2dc\ud569\ub2c8\ub2e4. \ubd84\uc11d\uac00\uc640 \uad00\ub9ac\uc790\ub294 \uae30\uc874\uc5d0 \uc0ac\uc6a9\ud558\ub358 \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uacc4\uc18d \uc791\uc5c5\ud560 \uc218 \uc788\uc73c\uba70, \uadf8 \uae30\ubc18\uc774 \ub418\ub294 \uacc4\ubcf4\ub294 \ucd5c\uc120 \ub178\ub825 \ubc29\uc2dd\uc774 \uc544\ub2cc \ud30c\uc11c \uc218\uc900\uc758 \uc815\ud655\ub3c4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc9c1\uc811 \ud1b5\ud569\uc744 \uad6c\ucd95\ud558\ub824\ub294 \uacbd\uc6b0, \ub3d9\uc77c\ud55c \uacc4\ubcf4 \uc815\ubcf4\ub97c JSON \ub610\ub294 CSV \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uac70\ub098 REST API\ub97c \ud1b5\ud574 \uc774\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Azure \ud658\uacbd\uc744 \uc704\ud55c \ubc30\ud3ec \uc635\uc158<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\ud310<\/th><th>~\uc5d0 \uac00\uc7a5 \uc801\ud569\ud568<\/th><th>\uc791\ub3d9 \ubc29\uc2dd<\/th><\/tr><\/thead><tbody>\n<tr><td>SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/td><td>\uc624\ub298 \uc2e4\uc81c \ucffc\ub9ac\uc5d0 \uc801\uc6a9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/td><td>\ubb34\ub8cc \ud2f0\uc5b4\uac00 \uc788\ub294 SaaS\uc774\uba70, \ud504\ub9ac\ubbf8\uc5c4\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. T-SQL \ucf54\ub4dc\ub97c \ubd99\uc5ec\ub123\uac70\ub098 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uc18c\uc2a4\ub97c \uc5f0\uacb0\ud558\uc138\uc694.<\/td><\/tr>\n<tr><td><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a><\/td><td>SQL \ud14d\uc2a4\ud2b8\uac00 \ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 \uc720\uc9c0\ub418\uc5b4\uc57c \ud558\ub294 \uaddc\uc81c\ub41c \uc6cc\ud06c\ub85c\ub4dc<\/td><td>Docker\/Kubernetes\ub97c \uc790\uccb4 Azure \uad6c\ub3c5 \ub610\ub294 \ub370\uc774\ud130 \uc13c\ud130\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud558\uba70, \ud544\uc694\ud55c \uacbd\uc6b0 \uc5d0\uc5b4\uac2d \ud658\uacbd\uc73c\ub85c \uaca9\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ubcc4\ub85c \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800 \uc694\uae08\uc81c\ub85c \uc81c\uacf5\ub418\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>REST API \/ \uc790\ubc14 \ub77c\uc774\ube0c\ub7ec\ub9ac \/ CLI<\/td><td>CI \ub610\ub294 \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc \ub0b4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4 \uc790\ub3d9\ud654<\/td><td>\ud30c\uc774\ud504\ub77c\uc778\uacfc JVM \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ud638\ucd9c \uac00\ub2a5\ud55c \ub3d9\uc77c\ud55c \ubd84\uc11d \uc5d4\uc9c4\uc785\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc5b4\ub5a4 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub4e0 \uac1c\uc778 \uc815\ubcf4 \ubcf4\ud638 \uc815\ucc45\uc740 \ub3d9\uc77c\ud569\ub2c8\ub2e4. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\ub9cc \uc218\ud589\ud558\uba70 \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Azure SQL, SQL Server, \uc544\ub2c8\uba74 \ub2e4\ub978 \uac74\uac00\uc694?<\/h2>\n\n\n\n<p>Azure SQL\uacfc \uc628\ud504\ub808\ubbf8\uc2a4 SQL Server\ub294 T-SQL \uacc4\uc5f4\uc744 \uacf5\uc720\ud558\uc9c0\ub9cc SQLFlow\uc5d0\uc11c\ub294 \uac01\uac01 \uace0\uc720\ud55c \ud30c\uc11c\ub97c \uac00\uc9c4 \ubcc4\uac1c\uc758 \ubc29\uc5b8\uc73c\ub85c \ucde8\uae09\ub429\ub2c8\ub2e4. \ud658\uacbd\uc774 \uc790\uccb4 \ud638\uc2a4\ud305 SQL Server\uc5d0 \uae30\ubc18\uc744 \ub450\uace0 \uc788\ub294 \uacbd\uc6b0, <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%ec%84%9c%eb%b2%84-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">SQL Server \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \ud574\ub2f9 \ud398\uc774\uc9c0\ub294 \uadf8 \uce21\uba74\uc744 \uc790\uc138\ud788 \ub2e4\ub8f9\ub2c8\ub2e4. \ud558\uc774\ube0c\ub9ac\ub4dc \ud658\uacbd\uc740 \ud558\ub098\uc758 \uc800\uc7a5\uc18c\uc5d0\uc11c \ub450 \uac00\uc9c0 \ubaa8\ub450\ub97c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc5ec\uc804\ud788 \uc811\uadfc \ubc29\uc2dd(\uce74\ud0c8\ub85c\uadf8 \uae30\ubc18 \uacc4\ubcf4, \ub7f0\ud0c0\uc784 \ub85c\uadf8 \uae30\ubc18 \uacc4\ubcf4, \uc624\ud508 \uc18c\uc2a4 \ud30c\uc11c)\uc744 \ube44\uad50\ud558\uace0 \uc788\ub2e4\uba74, \ub2e4\uc74c \uc124\ubb38 \uc870\uc0ac\uac00 \ub3c4\uc6c0\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%b5%9c%ea%b3%a0%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">\ucd5c\uace0\uc758 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c<\/a> \uac01 \ubc94\uc8fc\uac00 \uc5b4\ub514\uc5d0 \ud574\ub2f9\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 SQL \uad6c\ubb38 \ubd84\uc11d\uc774 \uc801\uc808\ud55c \ud574\uacb0\ucc45\uc778 \uacbd\uc6b0\ub97c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Under the hood, all of this runs on the General SQL Parser engine, developed commercially since the mid-2000s and validated against roughly 13,600 per-dialect SQL test fixtures. Depth on hard SQL is the product.<\/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\">SQLFlow\ub294 Azure Synapse SQL\uc744 \uc9c0\uc6d0\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. Synapse \uc804\uc6a9 SQL \ud480\uc740 T-SQL\uc744 \uc0ac\uc6a9\ud558\uba70, SQLFlow\uc758 Azure SQL \ubc29\uc5b8 \ud30c\uc11c\ub294 T-SQL \uacc4\uc5f4\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c Synapse SQL \uc2a4\ud06c\ub9bd\ud2b8, \ubdf0 \ubc0f \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c Azure SQL Database \ucf54\ub4dc\uc640 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ub0b4\uc758 \ub3d9\uc801 SQL\uc5d0 \ub300\ud55c \ucd94\uc801 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. \ud504\ub85c\uc2dc\uc800 \ub0b4\uc5d0\uc11c SQL\uc774 \uad6c\uc131\ub418\uace0 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>\uc784\uc6d0<\/code> \ub610\ub294 <code>sp_executesql<\/code> \uac74\ub108\ub6f0\ub294 \ub300\uc2e0 \ud574\uacb0 \ubc0f \ubd84\uc11d\ub418\uba70, \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218\uc640 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \uacc4\ubcf4\uac00 \ucd94\uc801\ub429\ub2c8\ub2e4. SQLFlow\ub294 \ub610\ud55c \ud504\ub85c\uc2dc\uc800 \uac04 \ud638\ucd9c\uc5d0 \ub300\ud55c \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uadf8\ub9bd\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow \uacc4\ubcf4\ub294 \uc5b4\ub5bb\uac8c Microsoft Purview\uc5d0 \ud3ec\ud568\ub418\ub098\uc694?<\/h3>\n\n\n<p>\uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec \ud658\uacbd\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ub0b4\uc7a5 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \ud1b5\ud574 SQLFlow\ub294 T-SQL \uad6c\ubb38\uc744 \ubd84\uc11d\ud558\uc5ec \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uacc4\uc0b0\ud55c \ub2e4\uc74c, \uc774\ub97c Purview\uc5d0 \uac8c\uc2dc\ud558\uc5ec Purview \uc790\uccb4 \uc2a4\uce94 \uacb0\uacfc\uc640 \ud568\uaed8 \uce74\ud0c8\ub85c\uadf8\uc5d0 \ud45c\uc2dc\ub418\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud1b5\ud569\uc744 \uc704\ud574 JSON, CSV \ubc0f REST API \ucd9c\ub825\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Azure SQL \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud55c\uac00\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c JDBC\ub97c \ud1b5\ud574 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130(\ud14c\uc774\ube14, \ubdf0 \ubc0f \ud504\ub85c\uc2dc\uc800 \uc815\uc758)\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud589\uc744 \uc9c1\uc811 \uc77d\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc740 SQL \ud14d\uc2a4\ud2b8\uae4c\uc9c0\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \ubcf4\uad00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uceec\ub7fc \uc218\uc900 \uacc4\ubcf4 \uc815\ubcf4\ub294 Purview\uc758 \uc790\uc0b0 \uc218\uc900 \ubcf4\uae30\uc640 \ube44\uad50\ud588\uc744 \ub54c \uc5b4\ub5a4 \ucd94\uac00\uc801\uc778 \uc774\uc810\uc744 \uc81c\uacf5\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc815\ud655\uc131. \uc790\uc0b0 \uc218\uc900 \uacc4\ubcf4\ub294 \ud14c\uc774\ube14\uc774 \ubcf4\uace0\uc11c\uc5d0 \uc5b4\ub5bb\uac8c \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \ubc18\uba74, \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub294 \uc5b4\ub5a4 \ud2b9\uc815 \uc5f4\uc774 \uc5b4\ub5a4 \ubcc0\ud658\uc744 \ud1b5\ud574 \uc5b4\ub5a4 \ub370\uc774\ud130\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\uace0, \ud544\ud130\uc640 \uc870\uc778\uc744 \ud1b5\ud574\uc11c\ub9cc \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \uc5f4\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4. \uc774\uac83\uc774 \ubc14\ub85c \uc601\ud5a5 \ubd84\uc11d \ubc0f \uac10\uc0ac \uc9c8\ubb38\uc5d0 \uc2e4\uc81c\ub85c \ud544\uc694\ud55c \uc138\ubd84\uc131\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow \uac00\uaca9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\ub294 \ubb34\ub8cc\ub85c \uc2dc\uc791\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \uacc4\uc815\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\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 \uc6f9\uc0ac\uc774\ud2b8\ub97c \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9 \ud398\uc774\uc9c0<\/a>.<\/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 Azure SQL \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694<\/h2>\n\n\n<p>\uac00\uc7a5 \ubcf5\uc7a1\ud55c T-SQL \ud504\ub85c\uc2dc\uc800\ub97c \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, Azure \ud658\uacbd\uc744 \uc2a4\uce94\ud558\uc5ec Purview\ub85c \ub0b4\ubcf4\ub0b4\ub294 \uac83\uc5d0 \ub300\ud574 \ubb38\uc758\ud574 \uc8fc\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=azure-sql-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\"><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\\\/azure-sql-data-lineage\\\/\",\n            \"description\": \"SQL data lineage tool for Azure SQL and Synapse SQL that parses T-SQL, including stored procedures and dynamic SQL, to produce column-level lineage and export it to Microsoft Purview.\",\n            \"featureList\": \"Azure SQL dialect parser, column-level lineage, direct and indirect lineage, T-SQL stored procedure call graphs, dynamic SQL analysis, ER diagram generation, Microsoft Purview export, REST API\",\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 SQLFlow support Azure Synapse SQL?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Synapse dedicated SQL pools use T-SQL, and SQLFlow's Azure SQL dialect parser covers the T-SQL family. You can analyze Synapse SQL scripts, views, and stored procedures the same way as Azure SQL Database code.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through dynamic SQL in stored procedures?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQL assembled inside a procedure and executed with EXEC or sp_executesql is resolved and analyzed rather than skipped, and lineage is traced through procedure parameters and temp tables. SQLFlow also draws a call graph of procedure-to-procedure invocations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How does SQLFlow lineage get into Microsoft Purview?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Through a built-in export adapter available in enterprise deployments. SQLFlow computes column-level lineage by parsing your T-SQL, then publishes it to Purview so it appears in the catalog alongside Purview's own scans. JSON, CSV, and REST API outputs are available for custom integrations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to the data in my Azure SQL tables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata (table, view, and procedure definitions) over JDBC. It never reads rows. The On-Premise edition keeps even the SQL text inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does column-level lineage add over Purview's asset-level view?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Precision. Asset-level lineage says a table feeds a report; column-level lineage says which specific columns feed which, through which transformations, and additionally flags columns that influence results only through filters and joins. That is the granularity impact analysis and audit questions actually require.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How much does SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium accounts are $49.99\\\/month. SQLFlow On-Premise is $500\\\/month or $4,800 one-time per selected database type.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>Azure SQL data lineage is the column-by-column map of how data flows through the T-SQL code running in Azure SQL Database, Azure SQL Managed Instance, and Synapse SQL: which source columns feed each target column, through which views, stored procedures, joins, and functions. The most accurate way to build it is to parse the T-SQL itself. Gudu SQLFlow does exactly that with a dedicated Azure SQL dialect parser, and can push the resulting column-level lineage into Microsoft Purview so it appears alongside the rest of your Azure estate. Try it in 30 seconds: paste any Azure SQL query or stored\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\/6760"}],"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=6760"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6760\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}