{"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\/jp\/azure-sql-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%aa%e3%83%8d%e3%83%bc%e3%82%b8\/","title":{"rendered":"Azure SQL \u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8: Azure SQL \u304a\u3088\u3073 Synapse SQL \u306e\u5217\u30ea\u30cd\u30fc\u30b8"},"content":{"rendered":"<p><strong>Azure SQL \u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8<\/strong> \u3053\u308c\u306f\u3001Azure SQL Database\u3001Azure SQL Managed Instance\u3001\u304a\u3088\u3073 Synapse SQL \u3067\u5b9f\u884c\u3055\u308c\u308b T-SQL \u30b3\u30fc\u30c9\u5185\u3067\u30c7\u30fc\u30bf\u304c\u3069\u306e\u3088\u3046\u306b\u6d41\u308c\u308b\u304b\u3092\u5217\u3054\u3068\u306b\u793a\u3059\u30de\u30c3\u30d7\u3067\u3059\u3002\u3069\u306e\u30bd\u30fc\u30b9\u5217\u304c\u3069\u306e\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306b\u30c7\u30fc\u30bf\u3092\u4f9b\u7d66\u3059\u308b\u306e\u304b\u3001\u3069\u306e\u30d3\u30e5\u30fc\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3001\u7d50\u5408\u3001\u304a\u3088\u3073\u95a2\u6570\u3092\u7d4c\u7531\u3059\u308b\u306e\u304b\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u3053\u308c\u3092\u6700\u3082\u6b63\u78ba\u306b\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001T-SQL \u81ea\u4f53\u3092\u89e3\u6790\u3059\u308b\u306e\u304c\u6700\u5584\u306e\u65b9\u6cd5\u3067\u3059\u3002 <a href=\"https:\/\/www.gudusoft.com\/jp\/sql-data-lineage-tool\/\">Gudu SQLFlow<\/a> \u5c02\u7528\u306eAzure SQL\u65b9\u8a00\u30d1\u30fc\u30b5\u30fc\u3092\u4f7f\u7528\u3057\u3066\u307e\u3055\u306b\u305d\u308c\u3092\u5b9f\u884c\u3057\u3001\u7d50\u679c\u3068\u3057\u3066\u5f97\u3089\u308c\u308b\u5217\u30ec\u30d9\u30eb\u306e\u30ea\u30cd\u30fc\u30b8\u3092Microsoft Purview\u306b\u30d7\u30c3\u30b7\u30e5\u3057\u3066\u3001Azure\u74b0\u5883\u306e\u4ed6\u306e\u90e8\u5206\u3068\u4e26\u3079\u3066\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/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\u79d2\u3067\u8a66\u3057\u3066\u307f\u307e\u3057\u3087\u3046\uff1a<\/strong> Azure SQL \u30af\u30a8\u30ea\u307e\u305f\u306f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u8cbc\u308a\u4ed8\u3051\u307e\u3059 <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\">\u7121\u6599\u306eSQLFlow\u7cfb\u7d71\u53ef\u8996\u5316\u30c4\u30fc\u30eb<\/a>Azure SQL \u65b9\u8a00\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u5bfe\u8a71\u578b\u306e\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u56f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30af\u30e9\u30a6\u30c9\u7248\u306b\u306f\u7121\u6599\u5229\u7528\u67a0\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Azure SQL\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u304c\u89e3\u6790\u306e\u554f\u984c\u3067\u3042\u308b\u7406\u7531<\/h2>\n\n\n\n<p>Azure \u3067\u306f\u3001\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u3092\u6574\u5f62\u3059\u308b\u5909\u63db\u30ed\u30b8\u30c3\u30af\u306f\u3001\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u5b9a\u7fa9\u306b\u306f\u307b\u3068\u3093\u3069\u5b58\u5728\u3057\u307e\u305b\u3093\u3002\u305d\u308c\u306f T-SQL \u306b\u5b58\u5728\u3057\u307e\u3059\u3002\u30d3\u30e5\u30fc\u306e\u4e0a\u306b\u91cd\u306d\u3089\u308c\u305f\u30d3\u30e5\u30fc\u3001Azure Data Factory \u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u304b\u3089\u547c\u3073\u51fa\u3055\u308c\u308b\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3001 <code>\u30de\u30fc\u30b8<\/code> \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3001\u304a\u3088\u3073\u5b9f\u884c\u6642\u306b\u7d44\u307f\u7acb\u3066\u3089\u308c\u308b\u52d5\u7684SQL\u3002\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u307f\u304b\u3089\u69cb\u7bc9\u3055\u308c\u305f\u7cfb\u7d71\u56f3\u306f\u3001\u30dc\u30c3\u30af\u30b9\u306f\u8a8d\u8b58\u3067\u304d\u308b\u3082\u306e\u306e\u3001\u305d\u306e\u5185\u90e8\u3067\u4f55\u304c\u8d77\u3053\u3063\u3066\u3044\u308b\u304b\u306f\u8a8d\u8b58\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u305d\u308c\u3092\u77e5\u308b\u305f\u3081\u306b <code>\u30ec\u30dd\u30fc\u30c8.\u6708\u6b21\u53ce\u76ca<\/code> \u306f\u6b21\u306e\u3088\u3046\u306b\u8a08\u7b97\u3055\u308c\u307e\u3059 <code>SUM(orders.amount)<\/code> \u30d5\u30a3\u30eb\u30bf\u30fc <code>\u6ce8\u6587\u72b6\u6cc1<\/code>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30a8\u30f3\u30b8\u30f3\u304c\u884c\u3046\u3088\u3046\u306b SQL \u3092\u8aad\u307f\u53d6\u308b\u4f55\u304b\u304c\u5fc5\u8981\u3067\u3059\u3002\u3064\u307e\u308a\u3001CTE\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3001\u30d3\u30e5\u30fc\u3001\u304a\u3088\u3073 <code>\u9078\u629e *<\/code> \u5c55\u958b\u5f8c\u3001\u30bd\u30fc\u30b9\u5217\u304b\u3089\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u3078\u306e\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3092\u8ffd\u8de1\u3057\u307e\u3059\u3002\u3053\u308c\u304c\u9759\u7684SQL\u5206\u6790\u3067\u3042\u308a\u3001SQLFlow\u306f\u307e\u3055\u306b\u3053\u306e\u76ee\u7684\u306e\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002SQLFlow\u306fSQL\u30b3\u30fc\u30c9\u3068\u30b9\u30ad\u30fc\u30de\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u307f\u3092\u8aad\u307f\u53d6\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u306b\u306f\u4e00\u5207\u624b\u3092\u52a0\u3048\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Microsoft Purview\u306e\u7bc4\u56f2\u3068\u3001\u305d\u306e\u30ae\u30e3\u30c3\u30d7\u3092\u89e3\u6790\u304c\u3069\u306e\u3088\u3046\u306b\u57cb\u3081\u308b\u304b<\/h2>\n\n\n\n<p>Microsoft Purview \u306f\u3001\u30ab\u30bf\u30ed\u30b0\u30d5\u30a1\u30fc\u30b9\u30c8\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3068\u3057\u3066\u5f53\u7136\u679c\u305f\u3059\u3079\u304d\u5f79\u5272\u3092\u771f\u306b\u679c\u305f\u3057\u3066\u3044\u307e\u3059\u3002Azure \u74b0\u5883\u5168\u4f53\u306b\u308f\u305f\u308b\u30a2\u30bb\u30c3\u30c8\u306e\u30b9\u30ad\u30e3\u30f3\u3068\u5206\u985e\u3001\u6a5f\u5bc6\u30c7\u30fc\u30bf\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u3001\u305d\u3057\u3066 Azure Data Factory \u3084 Synapse \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u306a\u3069\u3001\u7d71\u5408\u3055\u308c\u305f\u30c7\u30fc\u30bf\u79fb\u52d5\u30c4\u30fc\u30eb\u306e\u30ea\u30cd\u30fc\u30b8\u8868\u793a\u306a\u3069\u304c\u53ef\u80fd\u3067\u3059\u3002Azure \u3092\u3069\u306e\u3088\u3046\u306a\u898f\u6a21\u3067\u904b\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001Purview \u306f\u30ea\u30cd\u30fc\u30b8\u7ba1\u7406\u3092\u884c\u3046\u4e0a\u3067\u9069\u5207\u306a\u9078\u629e\u80a2\u3068\u8a00\u3048\u308b\u3067\u3057\u3087\u3046\u3002 <em>\u8868\u793a<\/em>.<\/p>\n\n\n\n<p>\u30ae\u30e3\u30c3\u30d7\u306f\u3001\u7cfb\u7d71\u304c\u3069\u306e\u3088\u3046\u306b\u4f1d\u308f\u308b\u304b\u306b\u3042\u308b <em>\u8a08\u7b97\u3055\u308c\u305f<\/em>Purview \u306e\u81ea\u52d5 SQL \u7cfb\u7d71\u306b\u306f\u3001\u8907\u96d1\u306a T-SQL \u306b\u95a2\u3059\u308b\u30ae\u30e3\u30c3\u30d7\u304c\u3042\u308a\u307e\u3059\u3002\u5236\u5fa1\u30d5\u30ed\u30fc\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u3001\u52d5\u7684 SQL \u3092\u542b\u3080\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306a\u3069\u3067\u3059\u3002 <code>sp_executesql<\/code> \u307e\u3055\u306b\u305d\u3053\u306f\u3001\u81ea\u52d5\u5316\u3055\u308c\u305f\u30ab\u30d0\u30ec\u30c3\u30b8\u304c\u9014\u5207\u308c\u3001\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u5883\u754c\u304c\u5931\u308f\u308c\u308b\u5834\u6240\u3067\u3042\u308b\u3002\u305d\u3057\u3066\u3001\u6700\u3082\u30ea\u30b9\u30af\u306e\u9ad8\u3044\u5909\u9769\u304c\u767a\u751f\u3059\u308b\u5834\u6240\u3067\u3082\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u52b9\u679c\u7684\u306a\u5206\u696d\u4f53\u5236\uff1aSQLFlow\u306fT-SQL\u3092\u89e3\u6790\u3057\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3084\u52d5\u7684SQL\u3092\u542b\u3080\u5217\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u8a08\u7b97\u3057\u3001Microsoft Purview\u30a2\u30c0\u30d7\u30bf\u3092\u4ecb\u3057\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002SQLFlow\u304c\u8a08\u7b97\u3092\u884c\u3044\u3001Purview\u304c\u30b7\u30b9\u30c6\u30e0\u5168\u4f53\u306e\u8868\u793a\u3092\u62c5\u5f53\u3057\u307e\u3059\u3002\u30ab\u30bf\u30ed\u30b0\u306f1\u3064\u306b\u307e\u3068\u3081\u3089\u308c\u3001SQL\u3092\u591a\u7528\u3059\u308b\u30ab\u30bf\u30ed\u30b0\u306e\u9685\u3005\u307e\u3067\u60c5\u5831\u304c\u57cb\u307e\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\u304cAzure SQL\u30b3\u30fc\u30c9\u304b\u3089\u62bd\u51fa\u3059\u308b\u3082\u306e<\/h2>\n\n\n\n<p>SQLFlow\u306f\u3001\u6c4e\u7528ANSI\u6587\u6cd5\u3067\u306f\u306a\u304f\u300139\u7a2e\u985e\u306e\u7570\u306a\u308b\u65b9\u8a00\u306b\u5bfe\u5fdc\u3057\u305f\u30d1\u30fc\u30b5\u30fc\u3092\u642d\u8f09\u3057\u3066\u304a\u308a\u3001Azure SQL\u3082\u305d\u306e\u4e00\u3064\u3067\u3001SQL Server\u3068\u4e26\u3093\u3067T-SQL\u30d5\u30a1\u30df\u30ea\u30fc\u306b\u5c5e\u3057\u307e\u3059\u3002Synapse\u5c02\u7528SQL\u30d7\u30fc\u30eb\u3082T-SQL\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001Synapse SQL\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3082\u540c\u69d8\u306e\u5206\u6790\u304c\u9069\u7528\u3055\u308c\u307e\u3059\u3002Azure SQL\u30b3\u30fc\u30c9\u306e\u5834\u5408\u3001SQLFlow\u306f\u4ee5\u4e0b\u3092\u751f\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><strong>\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\uff1a<\/strong> \u5404\u51fa\u529b\u5217\u306b\u3064\u3044\u3066\u3001\u305d\u306e\u5217\u306e\u5143\u3068\u306a\u308b\u6b63\u78ba\u306a\u30bd\u30fc\u30b9\u5217\u3001\u304a\u3088\u3073\u305d\u308c\u3089\u306e\u9593\u306e\u95a2\u6570\u3001\u578b\u5909\u63db\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3001\u7d50\u5408\u3001\u96c6\u5408\u6f14\u7b97\u5b50\u304c\u793a\u3055\u308c\u307e\u3059\u3002\u53c2\u7167\u306f\u3001CTE\u3001\u30d3\u30e5\u30fc\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3001\u304a\u3088\u3073\u30b9\u30bf\u30fc\u5c55\u958b\u306b\u3088\u3063\u3066\u89e3\u6c7a\u3055\u308c\u307e\u3059\u3002<\/li>\n<li><strong>\u76f4\u63a5\u7684\u306a\u8840\u7d71\u3068\u9593\u63a5\u7684\u306a\u8840\u7d71\uff1a<\/strong> \u3067\u4f7f\u7528\u3055\u308c\u308b\u5217 <code>\u3069\u3053<\/code> \u53e5\u3001 <code>\u53c2\u52a0\u3059\u308b<\/code> \u72b6\u614b\u3001\u307e\u305f\u306f <code>\u30b0\u30eb\u30fc\u30d7\u5206\u3051<\/code> \u51fa\u529b\u306b\u306f\u53cd\u6620\u3055\u308c\u306a\u3044\u3082\u306e\u306e\u3001\u51fa\u529b\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u3002SQLFlow\u306f\u3053\u308c\u3092\u500b\u5225\u306e\u5207\u308a\u66ff\u3048\u53ef\u80fd\u306a\u95a2\u4fc2\u30bf\u30a4\u30d7\u3068\u3057\u3066\u30e2\u30c7\u30eb\u5316\u3059\u308b\u305f\u3081\u3001\u5f71\u97ff\u5206\u6790\u3067\u306f\u3001\u307b\u3068\u3093\u3069\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u30c4\u30fc\u30eb\u304c\u7121\u8996\u3059\u308b\u30d5\u30a3\u30eb\u30bf\u5217\u3092\u691c\u51fa\u3067\u304d\u308b\u3002<\/li>\n<li><strong>\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u7cfb\u7d71\uff1a<\/strong> T-SQL\u30d5\u30a1\u30df\u30ea\u30fc\u5c02\u7528\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30d1\u30fc\u30b5\u30fc\u306f\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u901a\u3058\u305f\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3092\u8ffd\u8de1\u3057\u3001\u3069\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u3069\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u547c\u3073\u51fa\u3057\u3066\u3044\u308b\u304b\u3092\u793a\u3059\u5bfe\u8a71\u578b\u306e\u547c\u3073\u51fa\u3057\u30b0\u30e9\u30d5\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/li>\n<li><strong>\u52d5\u7684SQL\u89e3\u6c7a\uff1a<\/strong> \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u3067\u7d44\u307f\u7acb\u3066\u3089\u308c\u3001\u5b9f\u884c\u3055\u308c\u308bSQL <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code> \u307e\u305f <code>sp_executesql<\/code> \u30b9\u30ad\u30c3\u30d7\u3055\u308c\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u89e3\u6c7a\u3055\u308c\u5206\u6790\u3055\u308c\u308b\u3002\u3053\u308c\u306f\u3001\u81ea\u52d5\u5316\u3055\u308c\u305f\u7cfb\u7d71\u8ffd\u8de1\u306b\u304a\u3044\u3066\u6700\u3082\u3088\u304f\u3042\u308b\u76f2\u70b9\u3067\u3042\u308b\u3002<\/li>\n<li><strong>DDL\u304b\u3089ER\u56f3\u3092\u4f5c\u6210\u3059\u308b\uff1a<\/strong> \u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u304b\u3089\u63a8\u6e2c\u3055\u308c\u308b\u4e3b\u30ad\u30fc\u3068\u5916\u90e8\u30ad\u30fc\u306e\u95a2\u4fc2\u3092\u3001\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u95a2\u4fc2\u56f3\u3068\u3057\u3066\u56f3\u793a\u3057\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<p>\u5165\u529b\u3068\u3057\u3066\u306f\u3001\u8cbc\u308a\u4ed8\u3051\u305fSQL\u3001\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb\u3001\u307e\u305f\u306fJDBC\u7d4c\u7531\u3067\u53d6\u5f97\u3057\u305f\u30e9\u30a4\u30d6\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001SQLFlow\u3092Azure SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5411\u3051\u3001\u30d3\u30e5\u30fc\u3068\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u5b9a\u7fa9\u3092\u81ea\u52d5\u7684\u306b\u53ce\u96c6\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4f8b\uff1a\u52d5\u7684SQL\u3092\u4f7f\u7528\u3057\u305fT-SQL\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3<\/h2>\n\n\n\n<p>\u3053\u308c\u306f\u3001\u81ea\u52d5\u7cfb\u7d71\u30b9\u30ad\u30e3\u30ca\u30fc\u3092\u7834\u7dbb\u3055\u305b\u308b\u624b\u9806\u306e\u4e00\u4f8b\u3067\u3059\u3002\u30c7\u30fc\u30bf\u3092\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u3057\u3001\u305d\u306e\u5f8c\u6700\u7d42\u7684\u306a <code>\u5165\u308c\u308b<\/code> \u6587\u5b57\u5217\u3068\u3057\u3066\u6271\u3044\u3001\u305d\u308c\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/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>\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5883\u754c\u3067\u505c\u6b62\u3059\u308b\u30b9\u30ad\u30e3\u30ca\u306f\u3001\u3053\u3053\u3067\u306f\u6709\u7528\u306a\u60c5\u5831\u3092\u4f55\u3082\u5831\u544a\u3057\u307e\u305b\u3093\u3002\u30bf\u30fc\u30b2\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306f\u6587\u5b57\u5217\u30ea\u30c6\u30e9\u30eb\u306e\u4e2d\u306b\u3057\u304b\u73fe\u308c\u306a\u3044\u304b\u3089\u3067\u3059\u3002SQLFlow\u306f\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u672c\u4f53\u3092\u89e3\u6790\u3057\u3001\u52d5\u7684SQL\u3092\u89e3\u6c7a\u3057\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u901a\u308b\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3092\u305f\u3069\u3063\u3066\u3001\u6b21\u306e\u7d50\u679c\u3092\u751f\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><code>\u5730\u57df\u5225\u58f2\u4e0a\u5408\u8a08\u91d1\u984d<\/code> \u2190 <code>SUM(orders.amount)<\/code>\u3001 \u7d4c\u7531 <code>#staged.total_amount<\/code> \uff08\u76f4\u7cfb\u306e\u5b50\u5b6b\uff09<\/li>\n<li><code>\u5730\u57df\u8ca9\u58f2\u9867\u5ba2\u540d<\/code> \u2190 <code>\u9867\u5ba2.\u9867\u5ba2\u540d<\/code> \uff08\u76f4\u7cfb\u306e\u5b50\u5b6b\uff09<\/li>\n<li><code>\u6ce8\u6587\u5730\u57df<\/code> \u7d50\u5408\u30ad\u30fc <code>\u9867\u5ba2.\u9867\u5ba2ID<\/code> \/ <code>\u6ce8\u6587\u306e\u9867\u5ba2ID<\/code> \u9593\u63a5\u7684\u306a\u7cfb\u7d71\u3068\u3057\u3066\u30d5\u30e9\u30b0\u4ed8\u3051\u3055\u308c\u308b\uff1a\u305d\u308c\u3089\u306f\u7d50\u679c\u306b\u306f\u73fe\u308c\u305a\u306b\u3001\u7d50\u679c\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u3066\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<p>\u540d\u524d\u3092\u5909\u66f4\u3059\u308b <code>\u6ce8\u6587\u5730\u57df<\/code> \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u89b3\u70b9\u304b\u3089\u898b\u308b\u3068\u3001\u4f55\u3082\u305d\u308c\u306b\u4f9d\u5b58\u3057\u3066\u3044\u306a\u3044\u3088\u3046\u306b\u898b\u3048\u308b\u3002\u4e00\u65b9\u3001\u89e3\u6790\u3055\u308c\u305f\u89b3\u70b9\u304b\u3089\u898b\u308b\u3068\u3001\u3053\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u7a7a\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u66f4\u65b0\u3092\u9759\u304b\u306b\u958b\u59cb\u3059\u308b\u3002\u3053\u308c\u304c\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u60c5\u5831\u304c\u3082\u305f\u3089\u3059\u9055\u3044\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u7cfb\u7d71\u60c5\u5831\u3092Microsoft Purview\u306b\u53d6\u308a\u8fbc\u3080<\/h2>\n\n\n\n<p>\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u5411\u3051 SQLFlow \u306e\u5c55\u958b\u306b\u306f\u3001Microsoft Purview\u3001DataHub\u3001\u304a\u3088\u3073 OpenMetadata \u7528\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8 \u30a2\u30c0\u30d7\u30bf\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002Azure \u74b0\u5883\u306b\u304a\u3051\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u306f\u30b7\u30f3\u30d7\u30eb\u3067\u3059\u3002SQLFlow \u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30d0\u30c3\u30c1 \u30b9\u30ad\u30e3\u30f3\u3057 (100 \u3092\u8d85\u3048\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068 100 \u4e07\u3092\u8d85\u3048\u308b\u5217\u3092\u6301\u3064\u74b0\u5883\u306b\u3082\u5bfe\u5fdc\u3057\u3001\u5897\u5206\u30b9\u30ad\u30e3\u30f3\u3068\u6c38\u7d9a\u7684\u306a\u30ea\u30cd\u30fc\u30b8 \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u5099\u3048\u3066\u3044\u307e\u3059)\u3001\u5b9f\u969b\u306e T-SQL \u304b\u3089\u5217\u30ec\u30d9\u30eb\u306e\u30ea\u30cd\u30fc\u30b8\u3092\u8a08\u7b97\u3057\u3001\u305d\u308c\u3092 Purview \u306b\u516c\u958b\u3057\u307e\u3059\u3002\u30a2\u30ca\u30ea\u30b9\u30c8\u3068\u30b9\u30c1\u30e5\u30ef\u30fc\u30c9\u306f\u3001\u65e2\u306b\u4f7f\u7528\u3057\u3066\u3044\u308b\u30ab\u30bf\u30ed\u30b0\u3067\u4f5c\u696d\u3092\u7d9a\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u3001\u305d\u306e\u80cc\u5f8c\u306b\u3042\u308b\u30ea\u30cd\u30fc\u30b8\u306f\u30d9\u30b9\u30c8 \u30a8\u30d5\u30a9\u30fc\u30c8\u3067\u306f\u306a\u304f\u3001\u30d1\u30fc\u30b5\u30fc \u30b0\u30ec\u30fc\u30c9\u306e\u7cbe\u5ea6\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u72ec\u81ea\u306e\u7d71\u5408\u3092\u69cb\u7bc9\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u540c\u3058\u30c7\u30fc\u30bf\u7cfb\u5217\u3092JSON\u307e\u305f\u306fCSV\u5f62\u5f0f\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u308a\u3001REST API\u7d4c\u7531\u3067\u5229\u7528\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Azure\u74b0\u5883\u306e\u30c7\u30d7\u30ed\u30a4\u30aa\u30d7\u30b7\u30e7\u30f3<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u7248<\/th><th>\u6700\u9069<\/th><th>\u52d5\u4f5c\u65b9\u6cd5<\/th><\/tr><\/thead><tbody>\n<tr><td>SQLFlow \u30af\u30e9\u30a6\u30c9<\/td><td>\u4eca\u65e5\u306f\u5b9f\u969b\u306e\u30af\u30a8\u30ea\u3067\u8a66\u3057\u3066\u307f\u307e\u3059<\/td><td>\u7121\u6599\u30d7\u30e9\u30f3\u306e\u3042\u308bSaaS\u3002\u30d7\u30ec\u30df\u30a2\u30e0\u30d7\u30e9\u30f3\u306f\u6708\u984d$49.99\u3067\u3059\u3002T-SQL\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u304b\u3001\u30d6\u30e9\u30a6\u30b6\u3067\u30bd\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/td><\/tr>\n<tr><td><a href=\"https:\/\/www.gudusoft.com\/jp\/sqlflow-%e3%82%aa%e3%83%b3%e3%83%97%e3%83%ac%e3%83%9f%e3%82%b9-%e3%83%90%e3%83%bc%e3%82%b8%e3%83%a7%e3%83%b3\/\">SQLFlow \u30aa\u30f3\u30d7\u30ec\u30df\u30b9<\/a><\/td><td>SQL\u30c6\u30ad\u30b9\u30c8\u304c\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u5185\u306b\u7559\u307e\u308b\u5fc5\u8981\u304c\u3042\u308b\u898f\u5236\u5bfe\u8c61\u30ef\u30fc\u30af\u30ed\u30fc\u30c9<\/td><td>\u304a\u5ba2\u69d8\u3054\u81ea\u8eab\u306eAzure\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u307e\u305f\u306f\u30c7\u30fc\u30bf\u30bb\u30f3\u30bf\u30fc\u306bDocker\/Kubernetes\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30a8\u30a2\u30ae\u30e3\u30c3\u30d7\u74b0\u5883\u3092\u69cb\u7bc9\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u6599\u91d1\u306f\u3001\u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bf\u30a4\u30d7\u3054\u3068\u306b\u6708\u984d$500\u307e\u305f\u306f1\u56de\u9650\u308a\u306e$4,800\u3067\u3001\u6700\u59272\u53f0\u306e\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002<\/td><\/tr>\n<tr><td>REST API \/ Java\u30e9\u30a4\u30d6\u30e9\u30ea \/ CLI<\/td><td>CI\u307e\u305f\u306f\u30c7\u30fc\u30bf\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u5185\u3067\u306e\u7cfb\u7d71\u60c5\u5831\u306e\u81ea\u52d5\u5316<\/td><td>\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u3084JVM\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u547c\u3073\u51fa\u3057\u53ef\u80fd\u306a\u3001\u540c\u4e00\u306e\u5206\u6790\u30a8\u30f3\u30b8\u30f3\u3002<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\u3069\u306e\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3082\u3001\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u306b\u95a2\u3059\u308b\u65b9\u91dd\u306f\u540c\u3058\u3067\u3059\u3002SQLFlow\u306fSQL\u30b3\u30fc\u30c9\u306e\u9759\u7684\u89e3\u6790\u306e\u307f\u3092\u5b9f\u884c\u3057\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u306f\u6c7a\u3057\u3066\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Azure SQL\u3001SQL Server\u3001\u305d\u308c\u3068\u3082\u4ed6\u306e\u3082\u306e\uff1f<\/h2>\n\n\n\n<p>Azure SQL \u3068\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e SQL Server \u306f T-SQL \u30d5\u30a1\u30df\u30ea\u30fc\u3092\u5171\u6709\u3057\u3066\u3044\u307e\u3059\u304c\u3001SQLFlow \u3067\u306f\u5225\u3005\u306e\u65b9\u8a00\u3067\u3042\u308a\u3001\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u30d1\u30fc\u30b5\u30fc\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u81ea\u793e\u30db\u30b9\u30c8\u306e SQL Server \u3092\u57fa\u76e4\u3068\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001 <a href=\"https:\/\/www.gudusoft.com\/jp\/sql-server%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%aa%e3%83%8d%e3%83%bc%e3%82%b8\/\">SQL Server\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8<\/a> \u3053\u306e\u30da\u30fc\u30b8\u3067\u306f\u305d\u306e\u5074\u9762\u3092\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9\u74b0\u5883\u306f\u30011 \u3064\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u3067\u4e21\u65b9\u3092\u5206\u6790\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u307e\u3060\u30a2\u30d7\u30ed\u30fc\u30c1 (\u30ab\u30bf\u30ed\u30b0\u30cd\u30a4\u30c6\u30a3\u30d6\u306e\u7cfb\u7d71\u3001\u30e9\u30f3\u30bf\u30a4\u30e0\u30ed\u30b0\u30d9\u30fc\u30b9\u306e\u7cfb\u7d71\u3001\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e\u30d1\u30fc\u30b5\u30fc) \u3092\u6bd4\u8f03\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001 <a href=\"https:\/\/www.gudusoft.com\/jp\/%e6%9c%80%e9%ab%98%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e7%b5%b1%e3%83%84%e3%83%bc%e3%83%ab\/\">\u6700\u9ad8\u306e\u30c7\u30fc\u30bf\u7cfb\u7d71\u30c4\u30fc\u30eb<\/a> \u5404\u30ab\u30c6\u30b4\u30ea\u304c\u3069\u3053\u306b\u5f53\u3066\u306f\u307e\u308b\u306e\u304b\u3001\u305d\u3057\u3066SQL\u89e3\u6790\u304c\u9069\u5207\u306a\u89e3\u6c7a\u7b56\u3068\u306a\u308b\u306e\u306f\u3069\u306e\u3088\u3046\u306a\u5834\u5408\u306a\u306e\u304b\u3092\u660e\u78ba\u306b\u793a\u3057\u307e\u3059\u3002<\/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\">\u3088\u304f\u3042\u308b\u8cea\u554f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306fAzure Synapse SQL\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002Synapse\u5c02\u7528SQL\u30d7\u30fc\u30eb\u306fT-SQL\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001SQLFlow\u306eAzure SQL\u65b9\u8a00\u30d1\u30fc\u30b5\u30fc\u306fT-SQL\u30d5\u30a1\u30df\u30ea\u30fc\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002Synapse\u306eSQL\u30b9\u30af\u30ea\u30d7\u30c8\u3001\u30d3\u30e5\u30fc\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u3001Azure SQL Database\u306e\u30b3\u30fc\u30c9\u3068\u540c\u69d8\u306e\u65b9\u6cd5\u3067\u5206\u6790\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u306e\u52d5\u7684SQL\u3092\u901a\u3058\u3066\u30c7\u30fc\u30bf\u306e\u6d41\u308c\u3092\u8ffd\u8de1\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u3067\u7d44\u307f\u7acb\u3066\u3089\u308c\u3001\u5b9f\u884c\u3055\u308c\u308bSQL <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code> \u307e\u305f <code>sp_executesql<\/code> \u51e6\u7406\u306f\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u308b\u3053\u3068\u306a\u304f\u89e3\u6c7a\u304a\u3088\u3073\u5206\u6790\u3055\u308c\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u901a\u3058\u3066\u5c65\u6b74\u304c\u8ffd\u8de1\u3055\u308c\u307e\u3059\u3002SQLFlow \u306f\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u9593\u306e\u547c\u3073\u51fa\u3057\u306e\u547c\u3073\u51fa\u3057\u30b0\u30e9\u30d5\u3082\u63cf\u753b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306e\u7cfb\u7d71\u60c5\u5831\u306f\u3069\u306e\u3088\u3046\u306b\u3057\u3066Microsoft\u306e\u7ba1\u8f44\u4e0b\u306b\u5165\u308b\u306e\u3067\u3057\u3087\u3046\u304b\uff1f<\/h3>\n\n\n<p>\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u5c55\u958b\u3067\u5229\u7528\u53ef\u80fd\u306a\u7d44\u307f\u8fbc\u307f\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a2\u30c0\u30d7\u30bf\u3092\u4ecb\u3057\u3066\u3001SQLFlow\u306fT-SQL\u3092\u89e3\u6790\u3057\u3066\u5217\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u3092\u8a08\u7b97\u3057\u3001\u305d\u308c\u3092Purview\u306b\u516c\u958b\u3057\u3066\u3001Purview\u72ec\u81ea\u306e\u30b9\u30ad\u30e3\u30f3\u7d50\u679c\u3068\u3068\u3082\u306b\u30ab\u30bf\u30ed\u30b0\u306b\u8868\u793a\u3057\u307e\u3059\u3002\u30ab\u30b9\u30bf\u30e0\u7d71\u5408\u306e\u305f\u3081\u306b\u3001JSON\u3001CSV\u3001\u304a\u3088\u3073REST API\u51fa\u529b\u304c\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f\u3001\u79c1\u306eAzure SQL\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u3044\u3044\u3048\u3002SQLFlow\u306fSQL\u30b3\u30fc\u30c9\u306e\u9759\u7684\u89e3\u6790\u3092\u5b9f\u884c\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066JDBC\u7d4c\u7531\u3067\u30b9\u30ad\u30fc\u30de\u30e1\u30bf\u30c7\u30fc\u30bf\uff08\u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u5b9a\u7fa9\uff09\u3092\u8aad\u307f\u53d6\u308a\u307e\u3059\u3002\u884c\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u7248\u3067\u306f\u3001SQL\u30c6\u30ad\u30b9\u30c8\u3082\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u5185\u306b\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Purview\u306e\u8cc7\u7523\u30ec\u30d9\u30eb\u30d3\u30e5\u30fc\u3068\u6bd4\u8f03\u3057\u3066\u3001\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u60c5\u5831\u306f\u3069\u306e\u3088\u3046\u306a\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u7cbe\u5ea6\u3002\u8cc7\u7523\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306f\u3001\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u304c\u30ec\u30dd\u30fc\u30c8\u306b\u3069\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u304b\u3092\u793a\u3057\u307e\u3059\u304c\u3001\u5217\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306f\u3001\u3069\u306e\u5217\u304c\u3069\u306e\u5217\u306b\u3069\u306e\u5909\u63db\u3092\u4ecb\u3057\u3066\u30c7\u30fc\u30bf\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u304b\u3092\u793a\u3057\u3001\u3055\u3089\u306b\u30d5\u30a3\u30eb\u30bf\u30fc\u3084\u7d50\u5408\u306b\u3088\u3063\u3066\u306e\u307f\u7d50\u679c\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u5217\u3092\u7279\u5b9a\u3057\u307e\u3059\u3002\u3053\u308c\u3053\u305d\u304c\u3001\u5f71\u97ff\u5206\u6790\u3084\u76e3\u67fb\u306b\u304a\u3044\u3066\u5b9f\u969b\u306b\u5fc5\u8981\u3068\u3055\u308c\u308b\u7c92\u5ea6\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306e\u6599\u91d1\u306f\u3044\u304f\u3089\u3067\u3059\u304b\uff1f<\/h3>\n\n\n<p>SQLFlow Cloud\u306f\u7121\u6599\u304b\u3089\u30b9\u30bf\u30fc\u30c8\u3002\u30d7\u30ec\u30df\u30a2\u30e0\u30a2\u30ab\u30a6\u30f3\u30c8\u306f\u6708\u984d$49.99\u3002SQLFlow On-Premise\u306f\u6708\u984d$500\u3001\u307e\u305f\u306f\u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bf\u30a4\u30d7\u3054\u3068\u306b1\u56de\u9650\u308a\u306e$4,800\u3002\u8a73\u7d30\u306f\u4ee5\u4e0b\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002 <a href=\"https:\/\/www.gudusoft.com\/jp\/%e4%be%a1%e6%a0%bc%e8%a8%ad%e5%ae%9a\/\">\u4fa1\u683c\u30da\u30fc\u30b8<\/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\">Azure SQL \u306e\u7cfb\u7d71\u3092\u4eca\u3059\u3050\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046<\/h2>\n\n\n<p>\u6700\u3082\u8907\u96d1\u306aT-SQL\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u7121\u6599\u306e\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30b6\u30fc\u306b\u8cbc\u308a\u4ed8\u3051\u308b\u304b\u3001Azure\u74b0\u5883\u306e\u30b9\u30ad\u30e3\u30f3\u3068Purview\u3078\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u306b\u3064\u3044\u3066\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/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\u3092\u7121\u6599\u3067\u304a\u8a66\u3057\u304f\u3060\u3055\u3044<\/a><\/div>\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/jp\/%e3%82%b3%e3%83%b3%e3%82%bf%e3%82%af%e3%83%88\/\">\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u5411\u3051\u30c7\u30e2\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b<\/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\/jp\/wp-json\/wp\/v2\/pages\/6760"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/comments?post=6760"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages\/6760\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media?parent=6760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}