{"id":6753,"date":"2026-07-12T02:06:31","date_gmt":"2026-07-12T10:06:31","guid":{"rendered":"https:\/\/www.gudusoft.com\/databricks-data-lineage\/"},"modified":"2026-07-12T02:06:31","modified_gmt":"2026-07-12T10:06:31","slug":"databricks-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/jp\/%e3%83%87%e3%83%bc%e3%82%bf%e3%83%96%e3%83%aa%e3%83%83%e3%82%af%e3%82%b9%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%aa%e3%83%8d%e3%83%bc%e3%82%b8\/","title":{"rendered":"Databricks Data Lineage: Spark SQL\u3068Delta\u306e\u5217\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8"},"content":{"rendered":"<p><strong>Databricks\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8<\/strong> \u3053\u308c\u306f\u3001\u30c7\u30fc\u30bf\u304c Spark SQL \u304a\u3088\u3073 Delta Lake \u30b3\u30fc\u30c9\u3092\u4ecb\u3057\u3066\u3069\u306e\u3088\u3046\u306b\u6d41\u308c\u308b\u304b\u3092\u793a\u3059\u5217\u30ec\u30d9\u30eb\u306e\u30de\u30c3\u30d7\u3067\u3059\u3002\u30d6\u30ed\u30f3\u30ba\u3001\u30b7\u30eb\u30d0\u30fc\u3001\u30b4\u30fc\u30eb\u30c9\u306e\u5404\u30ec\u30a4\u30e4\u30fc\u3067\u3001\u3069\u306e\u30bd\u30fc\u30b9\u5217\u304c\u5404\u30bf\u30fc\u30b2\u30c3\u30c8 \u30c6\u30fc\u30d6\u30eb\u306b\u30d5\u30a3\u30fc\u30c9\u3059\u308b\u304b\u3001\u307e\u305f\u3001\u3069\u306e\u5909\u63db (\u7d50\u5408\u3001\u96c6\u8a08\u3001 <code>\u30de\u30fc\u30b8<\/code> \u30ed\u30b8\u30c3\u30af\u306f\u9014\u4e2d\u3067\u767a\u751f\u3057\u307e\u3059\u3002Unity Catalog \u306f\u3001\u305d\u308c\u3092\u901a\u3057\u3066\u5b9f\u884c\u3055\u308c\u308b\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306e\u5c65\u6b74\u3092\u81ea\u52d5\u7684\u306b\u30ad\u30e3\u30d7\u30c1\u30e3\u3057\u307e\u3059\u3002 <strong>Gudu SQLFlow<\/strong> SQL\u81ea\u4f53\u3092\u89e3\u6790\u3059\u308b\u3053\u3068\u3067\u4ed6\u306e\u3059\u3079\u3066\u3092\u30ab\u30d0\u30fc\u3067\u304d\u308b\u305f\u3081\u3001Databricks\u3078\u306e\u79fb\u884c\u3001Unity Catalog\u4ee5\u5916\u3067\u5b9f\u884c\u3055\u308c\u308bSQL\u3001\u304a\u3088\u3073Databricks\u3068\u4ed6\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u307e\u305f\u304c\u308b\u74b0\u5883\u306e\u305f\u3081\u306e\u30c4\u30fc\u30eb\u3068\u306a\u308a\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> Databricks\u3092\u8cbc\u308a\u4ed8\u3051\u308b <code>\u30de\u30fc\u30b8\u3059\u308b<\/code> \u307e\u305f\u306f\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u30af\u30a8\u30ea\u3092 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=databricks-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\u7121\u6599\u306eSQLFlow\u7cfb\u7d71\u53ef\u8996\u5316\u30c4\u30fc\u30eb<\/a>Databricks\u65b9\u8a00\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u56f3\u304c\u3059\u3050\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30af\u30e9\u30b9\u30bf\u30fc\u3084\u30ef\u30fc\u30af\u30b9\u30da\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f\u4e0d\u8981\u3067\u3059\u3002<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Unity\u30ab\u30bf\u30ed\u30b0\u306e\u5c65\u6b74\u60c5\u5831\u4ee5\u4e0a\u306e\u3082\u306e\u304c\u5fc5\u8981\u306b\u306a\u308b\u306e\u306f\u3069\u306e\u3088\u3046\u306a\u5834\u5408\u3067\u3059\u304b\uff1f<\/h2>\n\n\n\n<p>Unity Catalog\u306f\u3001\u305d\u306e\u6a5f\u80fd\u306b\u304a\u3044\u3066\u975e\u5e38\u306b\u512a\u308c\u3066\u3044\u307e\u3059\u3002Databricks\u306f\u3001Unity Catalog\u3092\u4ecb\u3057\u3066\u5b9f\u884c\u3055\u308c\u308b\u30af\u30a8\u30ea\u3084\u30b8\u30e7\u30d6\u306b\u3064\u3044\u3066\u3001\u7279\u5225\u306a\u30c4\u30fc\u30eb\u3092\u4f7f\u308f\u306a\u304f\u3066\u3082\u81ea\u52d5\u7684\u306b\u5c65\u6b74\u60c5\u5831\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u3082\u3057\u3001\u3059\u3079\u3066\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u304c1\u3064\u306eDatabricks\u30a2\u30ab\u30a6\u30f3\u30c8\u5185\u306b\u3042\u308a\u3001Unity Catalog\u3092\u4ecb\u3057\u3066\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3042\u308c\u3070\u3001\u307e\u305a\u306f\u305d\u3053\u304b\u3089\u59cb\u3081\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u30ae\u30e3\u30c3\u30d7\u306f\u69cb\u9020\u7684\u306a\u3082\u306e\u3067\u3042\u308a\u3001\u30d0\u30b0\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u5b9f\u884c\u6642\u306b\u30ad\u30e3\u30d7\u30c1\u30e3\u3055\u308c\u305f\u30b3\u30fc\u30c9\u30ea\u30cd\u30fc\u30b8\u306f\u3001\u30ad\u30e3\u30d7\u30c1\u30e3\u3092\u5b9f\u884c\u3059\u308b\u74b0\u5883\u3067\u65e2\u306b\u5b9f\u884c\u3055\u308c\u305f\u30b3\u30fc\u30c9\u306b\u5bfe\u3057\u3066\u306e\u307f\u5b58\u5728\u3057\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u30c1\u30fc\u30e0\u304c\u4ee3\u308f\u308a\u306bSQL\u89e3\u6790\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u63a1\u7528\u3059\u308b\u72b6\u6cc1\u304c4\u3064\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><strong>Databricks\u4e0a\u3067\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u3002<\/strong> Oracle\u3001Teradata\u3001\u307e\u305f\u306fSQL Server\u304b\u3089\u79fb\u884c\u3059\u308b\u5834\u5408\u3001\u672c\u756a\u74b0\u5883\u3067\u5b9f\u884c\u3092\u958b\u59cb\u3059\u308b\u524d\u306b\u3001\u5f93\u6765\u306eSQL\u3068\u66f8\u304d\u63db\u3048\u3089\u308c\u305fDatabricks SQL\u306e\u4f9d\u5b58\u95a2\u4fc2\u30b0\u30e9\u30d5\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n<li><strong>Unity\u30ab\u30bf\u30ed\u30b0\u306b\u4e00\u5207\u30a2\u30af\u30bb\u30b9\u3057\u306a\u3044SQL\u3002<\/strong> \u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305fSQL\u3001Git\u30ea\u30dd\u30b8\u30c8\u30ea\u5185\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3001\u5916\u90e8\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u307e\u305f\u306fETL\u30c4\u30fc\u30eb\u306b\u3088\u3063\u3066\u751f\u6210\u3055\u308c\u305fSQL\u3001Unity\u30ab\u30bf\u30ed\u30b0\u306b\u307e\u3060\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3055\u308c\u3066\u3044\u306a\u3044\u30ef\u30fc\u30af\u30b9\u30da\u30fc\u30b9\u4e0a\u306e\u30b3\u30fc\u30c9\u3002<\/li>\n<li><strong>\u30af\u30ed\u30b9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u74b0\u5883\u3002<\/strong> SQL Server \u3067\u958b\u59cb\u3057\u3001Databricks \u3067\u5909\u63db\u3055\u308c\u3001Snowflake \u306b\u683c\u7d0d\u3055\u308c\u308b\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u306b\u306f\u30013 \u3064\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3059\u3079\u3066\u306b\u307e\u305f\u304c\u308b 1 \u3064\u306e\u30ea\u30cd\u30fc\u30b8 \u30b0\u30e9\u30d5\u304c\u5fc5\u8981\u3067\u3059\u3002SQLFlow \u306f\u3001Databricks \u3068 Snowflake \u306e 39 \u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7528\u306e\u65b9\u8a00\u56fa\u6709\u306e\u30d1\u30fc\u30b5\u30fc\u3092\u51fa\u8377\u3057\u3066\u3044\u307e\u3059\u3002 <a href=\"https:\/\/www.gudusoft.com\/jp\/spark-sql-data-lineage\/\">Spark SQL<\/a> \u305d\u308c\u3089\u3092\u542b\u3081\u3066\u3001\u30c1\u30a7\u30fc\u30f3\u5168\u4f53\u304c1\u3064\u306e\u30a8\u30f3\u30b8\u30f3\u3067\u5206\u6790\u3055\u308c\u307e\u3059\u3002<\/li>\n<li><strong>\u65e2\u306b\u904b\u7528\u3057\u3066\u3044\u308b\u30ab\u30bf\u30ed\u30b0\u5185\u306e\u7cfb\u7d71\u60c5\u5831\u3002<\/strong> \u7d44\u7e54\u304cDatabricks\u306eUI\u3067\u306f\u306a\u304f\u3001DataHub\u3001Microsoft Purview\u3001\u307e\u305f\u306fOpenMetadata\u3092\u6a19\u6e96\u3068\u3057\u3066\u63a1\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u305d\u308c\u3089\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3067\u304d\u308b\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u304c\u5fc5\u8981\u3067\u3059\u3002SQLFlow\u306b\u306f\u3001\u3053\u308c\u30893\u3064\u3059\u3079\u3066\u306b\u5bfe\u5fdc\u3059\u308b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a2\u30c0\u30d7\u30bf\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<p>\u3053\u306e2\u3064\u306e\u30a2\u30d7\u30ed\u30fc\u30c1\u306f\u76f8\u4e92\u88dc\u5b8c\u7684\u3067\u3059\u3002Unity Catalog\u306f\u5b9f\u884c\u3055\u308c\u305f\u5185\u5bb9\u3092\u6559\u3048\u3066\u304f\u308c\u3001\u9759\u7684SQL\u5206\u6790\u306f\u30b3\u30fc\u30c9\u306e\u52d5\u4f5c\uff08\u307e\u3060\u5b9f\u884c\u3055\u308c\u3066\u3044\u306a\u3044\u30b3\u30fc\u30c9\u3082\u542b\u3080\uff09\u3092\u6559\u3048\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\u304cDatabricks SQL\u3092\u89e3\u6790\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.gudusoft.com\/jp\/sql-data-lineage-tool\/\">Gudu SQLFlow<\/a> is an automated SQL data lineage tool built on the General SQL Parser, a commercial SQL compiler front-end developed since the mid-2000s and validated against roughly 13,600 per-dialect test fixtures. It ships a dedicated Databricks dialect parser in the Spark SQL family \u2014 not a generic ANSI grammar \u2014 so Databricks-specific constructs are parsed as first-class syntax rather than approximated.<\/p>\n\n\n\n<p>\u5206\u6790\u306f\u5b8c\u5168\u306b\u9759\u7684\u3067\u3059\u3002SQLFlow \u306f SQL \u30c6\u30ad\u30b9\u30c8\u3068\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u30b9\u30ad\u30fc\u30de \u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308a\u307e\u3059\u3002Delta \u30c6\u30fc\u30d6\u30eb\u306e\u884c\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u306f\u6c7a\u3057\u3066\u3042\u308a\u307e\u305b\u3093\u3002 <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\/\">\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u7248<\/a> SQL \u30c6\u30ad\u30b9\u30c8\u81ea\u4f53\u306f\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u304b\u3089\u51fa\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002Docker \u307e\u305f\u306f Kubernetes \u306b\u30c7\u30d7\u30ed\u30a4\u3055\u308c\u3001\u30a8\u30a2\u30ae\u30e3\u30c3\u30d7\u3067\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\u5404\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u5bfe\u3057\u3066\u3001\u30d1\u30fc\u30b5\u30fc\u306f\u5b8c\u5168\u306a\u610f\u5473\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3057\u3001CTE\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u3001\u30d3\u30e5\u30fc\u3001\u304a\u3088\u3073 \u3092\u901a\u3058\u3066\u3059\u3079\u3066\u306e\u5217\u53c2\u7167\u3092\u89e3\u6c7a\u3057\u307e\u3059\u3002 <code>\u9078\u629e *<\/code> \u5c55\u958b\u5f8c\u3001\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u30a2\u30ca\u30e9\u30a4\u30b6\u30fc\u306f\u3001\u5217\u5358\u4f4d\u3067\u30bd\u30fc\u30b9\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u306e\u95a2\u4fc2\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8cbc\u308a\u4ed8\u3051\u305f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3001\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3001JDBC\u7d4c\u7531\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e1\u30bf\u30c7\u30fc\u30bf\u3001\u307e\u305f\u306fDatabricks\u3092\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3059\u308bdbt\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7528\u306edbt\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u306a\u3069\u3001\u30b7\u30b9\u30c6\u30e0\u74b0\u5883\u306b\u5b58\u5728\u3059\u308b\u3042\u3089\u3086\u308b\u5f62\u5f0f\u306eSQL\u3092\u5165\u529b\u3068\u3057\u3066\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u51fa\u529b\u306f\u3001\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u3067\u30c9\u30ea\u30eb\u30c0\u30a6\u30f3\u53ef\u80fd\u306a\u56f3\u3068\u3001JSON\u3001CSV\u3001PNG\u3001\u307e\u305f\u306fREST API\u30ec\u30b9\u30dd\u30f3\u30b9\u3068\u3057\u3066\u69cb\u9020\u5316\u3055\u308c\u305f\u30c7\u30fc\u30bf\u7cfb\u5217\u30c7\u30fc\u30bf\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4f8b\uff1a\u30c7\u30eb\u30bf\u30de\u30fc\u30b8\u306b\u3088\u308b\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71<\/h2>\n\n\n\n<p><code>\u30de\u30fc\u30b8\u3059\u308b<\/code> Delta Lake \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u306e\u4e3b\u529b\u3067\u3042\u308a\u3001\u5358\u4e00\u306e\u30de\u30fc\u30b8\u3067\u8aad\u307f\u53d6\u308a\u3001\u30de\u30c3\u30c1\u30f3\u30b0\u3001\u66f4\u65b0\u3001\u633f\u5165\u304c\u4e00\u5ea6\u306b\u884c\u308f\u308c\u308b\u305f\u3081\u3001\u30c6\u30fc\u30d6\u30eb\u30ec\u30d9\u30eb\u306e\u30ea\u30cd\u30fc\u30b8\u304c\u307b\u3068\u3093\u3069\u5f79\u306b\u7acb\u305f\u306a\u3044\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u3059\u3002\u30b4\u30fc\u30eb\u30c9\u30ec\u30a4\u30e4\u30fc\u306e\u30a2\u30c3\u30d7\u30b5\u30fc\u30c8\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MERGE INTO gold.customer_ltv AS t USING ( SELECT o.customer_id, SUM(o.amount) AS lifetime_value, MAX(o.order_ts) AS last_order_ts FROM silver.orders o WHERE o.status = &#039;completed&#039; GROUP BY o.customer_id ) AS s ON t.customer_id = s.customer_id WHEN MATCHED THEN UPDATE SET t.lifetime_value = s.lifetime_value, t.last_order_ts = s.last_order_ts WHEN NOT MATCHED THEN INSERT (customer_id, lifetime_value, last_order_ts) VALUES (s.customer_id, s.lifetime_value, s.last_order_ts);<\/code><\/pre>\n\n\n\n<p>SQLFlow\u306f\u3053\u308c\u3092\u89e3\u6c7a\u3057\u3001\u6b63\u78ba\u306a\u5217\u30ec\u30d9\u30eb\u306e\u95a2\u4fc2\u6027\u3092\u660e\u3089\u304b\u306b\u3057\u307e\u3059\u3002 <code>\u30b4\u30fc\u30eb\u30c9\u9867\u5ba2\u751f\u6daf\u4fa1\u5024<\/code> \u7531\u6765\u3059\u308b <code>\u9280\u306e\u6ce8\u6587\u6570<\/code> \u3092\u901a\u3057\u3066 <code>\u548c\uff08\uff09<\/code>\u4e21\u65b9\u3092\u901a\u3058\u3066 <code>\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8<\/code> \u305d\u3057\u3066 <code>\u5165\u308c\u308b<\/code> \u652f\u5e97\u3002 <code>last_order_ts<\/code> \u7531\u6765\u3059\u308b <code>silver.orders.order_ts<\/code> \u3092\u901a\u3057\u3066 <code>MAX()<\/code>\u30b5\u30d6\u30af\u30a8\u30ea\u30a8\u30a4\u30ea\u30a2\u30b9 <code>s<\/code> \u89e3\u6c7a\u6e08\u307f\u3002\u7cfb\u7d71\u306f\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u3067\u306f\u306a\u304f\u3001\u5b9f\u969b\u306e\u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u3057\u793a\u3059\u3002<\/p>\n\n\n\n<p>SQLFlow\u304c\u5206\u985e\u3059\u308b\u3082\u306e\u3082\u540c\u69d8\u306b\u91cd\u8981\u3067\u3059\u3002 <strong>\u9593\u63a5\u7684\u306a\u7cfb\u7d71<\/strong>: <code>\u9280\u306e\u6ce8\u6587\u72b6\u6cc1<\/code> \u6c7a\u3057\u3066\u76ee\u6a19\u306b\u306f\u7740\u5f3e\u3057\u306a\u3044\u304c\u3001 <code>\u3069\u3053<\/code> \u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u308b\u3053\u3068\u3067\u3001\u30de\u30fc\u30b8\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u5024\u306e\u5f62\u72b6\u304c\u6c7a\u307e\u308a\u3001 <code>\u9867\u5ba2ID<\/code> \u4e21\u65b9\u3092\u99c6\u52d5\u3059\u308b <code>\u30b0\u30eb\u30fc\u30d7\u5206\u3051<\/code> \u305d\u3057\u3066\u4e00\u81f4\u6761\u4ef6\u3002SQLFlow \u306f\u76f4\u63a5\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3068\u9593\u63a5\u5f71\u97ff\u3092\u3001\u5225\u3005\u306b\u5207\u308a\u66ff\u3048\u53ef\u80fd\u306a\u95a2\u4fc2\u30bf\u30a4\u30d7\u3068\u3057\u3066\u30e2\u30c7\u30eb\u5316\u3057\u307e\u3059\u3002\u7af6\u5408\u3059\u308b\u30c4\u30fc\u30eb\u306e\u307b\u3068\u3093\u3069\u306f\u3053\u306e\u533a\u5225\u3092\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u8ab0\u304b\u304c\u300c\u5909\u66f4\u3059\u308b\u3068\u3069\u3046\u306a\u308b\u304b\u300d\u3068\u5c0b\u306d\u305f\u3068\u304d\u306b\u307e\u3055\u306b\u5fc5\u8981\u306a\u306e\u306f\u3053\u308c\u3067\u3059\u3002 <code>\u72b6\u614b<\/code> \u300c\u9867\u5ba2LTV\u306e\u8a9e\u5f59\u304c\u58ca\u308c\u308b\uff1f\u300d\u6b63\u76f4\u306a\u7b54\u3048\u306f\u30a4\u30a8\u30b9\u3067\u3042\u308a\u3001\u5f71\u97ff\u3092\u610f\u8b58\u3057\u305f\u5c65\u6b74\u306e\u307f\u304c\u305d\u308c\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Databricks\u3078\u306e\u79fb\u884c\uff08\u307e\u305f\u306fDatabricks\u304b\u3089\u306e\u79fb\u884c\uff09<\/h2>\n\n\n\n<p>\u79fb\u884c\u306f\u3001\u30c1\u30fc\u30e0\u304c\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u5916\u3067 Databricks SQL \u3092\u5206\u6790\u3059\u308b\u6700\u3082\u4e00\u822c\u7684\u306a\u7406\u7531\u306e 1 \u3064\u306f\u3067\u3059\u3002Unity Catalog \u306f\u79fb\u884c\u8a08\u753b\u306e\u7b56\u5b9a\u306b\u306f\u5f79\u7acb\u3061\u307e\u305b\u3093\u3002\u306a\u305c\u306a\u3089\u3001\u5fc5\u8981\u306a\u30ea\u30cd\u30fc\u30b8\u306f Databricks \u4e0a\u3067\u5b9f\u884c\u3055\u308c\u305f\u3053\u3068\u306e\u306a\u3044\u30b3\u30fc\u30c9\u3092\u8a18\u8ff0\u3057\u3066\u3044\u308b\u304b\u3089\u3067\u3059\u3002\u30d1\u30fc\u30b5\u30fc\u30d9\u30fc\u30b9\u306e\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3067\u306f\u3001\u6b21\u306e\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<ol><li><strong>\u4f9b\u7d66\u6e90\u3068\u306a\u308b\u571f\u5730\u3092\u5730\u56f3\u4e0a\u306b\u8868\u793a\u3059\u308b\u3002<\/strong> \u30ec\u30ac\u30b7\u30fcSQL\uff08Oracle\u3001Teradata\u3001SQL Server\u306a\u3069\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3068\u305d\u306e\u4e2d\u306e\u52d5\u7684SQL\u3092\u542b\u3080\uff09\u3092SQLFlow\u3067\u5b9f\u884c\u3057\u3066\u3001\u771f\u306e\u4f9d\u5b58\u95a2\u4fc2\u30b0\u30e9\u30d5\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u6700\u521d\u306b\u79fb\u884c\u3059\u3079\u304d\u30b3\u30fc\u30c9\u3068\u3001\u4e0d\u8981\u306a\u30b3\u30fc\u30c9\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/li>\n<li><strong>\u66f8\u304d\u63db\u3048\u5185\u5bb9\u3092\u691c\u8a3c\u3059\u308b\u3002<\/strong> \u66f8\u304d\u63db\u3048\u3089\u308c\u305f Databricks SQL \u3092 Databricks \u65b9\u8a00\u30d1\u30fc\u30b5\u30fc\u3067\u89e3\u6790\u3057\u3001\u30ea\u30cd\u30fc\u30b8\u30b0\u30e9\u30d5\u3092\u6bd4\u8f03\u3057\u307e\u3059\u3002\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306e\u30bd\u30fc\u30b9\u304c Teradata \u30d0\u30fc\u30b8\u30e7\u30f3\u3068 Delta \u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u5909\u66f4\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u51fa\u8377\u524d\u306b\u66f8\u304d\u63db\u3048\u30d0\u30b0\u3092\u767a\u898b\u3057\u305f\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n<li><strong>\u5b64\u7acb\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/strong> \u5207\u308a\u66ff\u3048\u5f8c\u3001\u4e21\u65b9\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u74b0\u5883\u3092\u30d0\u30c3\u30c1\u30b9\u30ad\u30e3\u30f3\u3057\u307e\u3059\u3002SQLFlow\u306f\u3001100\u4ee5\u4e0a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068100\u4e07\u4ee5\u4e0a\u306e\u5217\u3092\u6301\u3064\u74b0\u5883\u3092\u3001\u6c38\u7d9a\u7684\u306a\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u30ea\u30dd\u30b8\u30c8\u30ea\u3078\u306e\u5897\u5206\u30b9\u30ad\u30e3\u30f3\u306b\u3088\u3063\u3066\u51e6\u7406\u3057\u307e\u3059\u3002<\/li><\/ol>\n\n\n\n<p>\u540c\u3058\u30af\u30ed\u30b9\u30c0\u30a4\u30ec\u30af\u30c6\u30a3\u30d6\u6a5f\u80fd\u306f\u9006\u65b9\u5411\u307e\u305f\u306f\u6a2a\u65b9\u5411\u306b\u3082\u6a5f\u80fd\u3057\u307e\u3059\u3002\u5009\u5eab\u306e\u4e00\u90e8\u304c\u4ee3\u308f\u308a\u306b Snowflake \u306b\u79fb\u884c\u3059\u308b\u5834\u5408\u3001 <a href=\"https:\/\/www.gudusoft.com\/jp\/%e3%82%b9%e3%83%8e%e3%83%bc%e3%83%95%e3%83%ac%e3%83%bc%e3%82%af-%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e7%b5%b1\/\">Snowflake\u306e\u7cfb\u7d71\u30ef\u30fc\u30af\u30d5\u30ed\u30fc<\/a> \u4e21\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306f\u540c\u4e00\u306e\u30a8\u30f3\u30b8\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u7d50\u679c\u3068\u3057\u3066\u6bd4\u8f03\u53ef\u80fd\u306a\u30b0\u30e9\u30d5\u306b\u307e\u3068\u3081\u3089\u308c\u308b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Databricks\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u3092DataHub\u3001Purview\u3001\u307e\u305f\u306fOpenMetadata\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b<\/h2>\n\n\n\n<p>\u30ab\u30bf\u30ed\u30b0\u30d5\u30a1\u30fc\u30b9\u30c8\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306f\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u8a18\u9332\u30b7\u30b9\u30c6\u30e0\u3068\u3057\u3066\u512a\u308c\u3066\u304a\u308a\u3001\u591a\u304f\u306e\u7d44\u7e54\u3067\u306f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u30ab\u30bf\u30ed\u30b0\u30d5\u30a1\u30fc\u30b9\u30c8\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3092\u7fa9\u52d9\u4ed8\u3051\u3066\u3044\u307e\u3059\u3002SQLFlow \u306f\u3001\u305d\u306e\u57fa\u76e4\u3068\u306a\u308b\u30ea\u30cd\u30fc\u30b8 \u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u6a5f\u80fd\u3057\u307e\u3059\u3002SQL \u3092\u89e3\u6790\u3057\u3001\u5217\u30ec\u30d9\u30eb\u304a\u3088\u3073\u9593\u63a5\u7684\u306a\u30ea\u30cd\u30fc\u30b8\u3092\u8a08\u7b97\u3057\u3001\u5c02\u7528\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8 \u30a2\u30c0\u30d7\u30bf\u3092\u901a\u3057\u3066\u7d50\u679c\u3092\u30d7\u30c3\u30b7\u30e5\u3057\u307e\u3059\u3002 <strong>DataHub\u3001Microsoft Purview\u3001\u304a\u3088\u3073OpenMetadata<\/strong>JSON\u304a\u3088\u3073CSV\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u306b\u52a0\u3048\u3001REST API\u306b\u3088\u308a\u3042\u3089\u3086\u308b\u30ab\u30b9\u30bf\u30e0\u8981\u4ef6\u306b\u5bfe\u5fdc\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306f\u3001\u30de\u30eb\u30c1\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u554f\u984c\u306b\u5bfe\u3059\u308b\u5b9f\u969b\u7684\u306a\u89e3\u6c7a\u7b56\u3067\u3082\u3042\u308a\u307e\u3059\u30022\u3064\u306e\u7570\u306a\u308b\u30e2\u30c7\u30eb\u3092\u6301\u30642\u3064\u306e\u7570\u306a\u308b\u62bd\u51fa\u5668\u306b\u3088\u3063\u3066\u751f\u6210\u3055\u308c\u305f\u7cfb\u7d71\u56f3\u30921\u3064\u306e\u30b0\u30e9\u30d5\u306b\u7d71\u5408\u3059\u308b\u306e\u306f\u56f0\u96e3\u3067\u3059\u300239\u306e\u3059\u3079\u3066\u306e\u65b9\u8a00\u306b\u5bfe\u3057\u30661\u3064\u306e\u30b0\u30e9\u30d5\u3092\u751f\u6210\u3057\u3001\u65e2\u306b\u5b9f\u884c\u3057\u3066\u3044\u308b\u30ab\u30bf\u30ed\u30b0\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b1\u3064\u306e\u30d1\u30fc\u30b5\u30fc\u3092\u4f7f\u7528\u3059\u308c\u3070\u3001\u3053\u306e\u554f\u984c\u3092\u56de\u907f\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u305d\u308c\u3092\u904b\u7528\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u30aa\u30d7\u30b7\u30e7\u30f3<\/th><th>\u6700\u9069<\/th><th>\u6ce8\u8a18<\/th><\/tr><\/thead><tbody>\n<tr><td><a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=databricks-data-lineage\">SQLFlow \u30af\u30e9\u30a6\u30c9<\/a><\/td><td>\u4eca\u65e5\u306f\u5b9f\u969b\u306eDatabricks SQL\u3067\u8a66\u3057\u3066\u307f\u307e\u3059<\/td><td>\u30d6\u30e9\u30a6\u30b6\u7248\u306f\u7121\u6599\u3001\u30d7\u30ec\u30df\u30a2\u30e0\u7248\u306f\u6708\u984d$49.99<\/td><\/tr>\n<tr><td>SQLFlow \u30aa\u30f3\u30d7\u30ec\u30df\u30b9<\/td><td>\u898f\u5236\u74b0\u5883\u4e0b\u3002SQL\u306f\u5185\u90e8\u3067\u306e\u307f\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/td><td>Docker\/Kubernetes\u3001\u30a8\u30a2\u30ae\u30e3\u30c3\u30d7\u5bfe\u5fdc\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bf\u30a4\u30d7\u3054\u3068\u306b\u6708\u984d$500\u307e\u305f\u306f1\u56de\u9650\u308a\u306e$4,800\u30022\u53f0\u306e\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u53ef\u80fd\u3002<\/td><\/tr>\n<tr><td>REST API \/ CLI \/ Java\u30e9\u30a4\u30d6\u30e9\u30ea<\/td><td>CI\u307e\u305f\u306f\u72ec\u81ea\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u306e\u30ea\u30cd\u30fc\u30b8\u306e\u81ea\u52d5\u5316<\/td><td>\u540c\u3058\u30a8\u30f3\u30b8\u30f3\u3001\u30d8\u30c3\u30c9\u30ec\u30b9\u3002\u88fd\u54c1\u306b\u56f3\u3092\u30ec\u30f3\u30c0\u30ea\u30f3\u30b0\u3059\u308b\u305f\u3081\u306e30\u4ee5\u4e0a\u306e\u30e1\u30bd\u30c3\u30c9API\u3092\u5099\u3048\u305f\u57cb\u3081\u8fbc\u307f\u53ef\u80fd\u306aJavaScript\u30a6\u30a3\u30b8\u30a7\u30c3\u30c8<\/td><\/tr>\n<\/tbody><\/table><\/figure>\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\u306fUnity\u30ab\u30bf\u30ed\u30b0\u306e\u7cfb\u8b5c\u3092\u7f6e\u304d\u63db\u3048\u308b\u3082\u306e\u3067\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u3044\u3044\u3048\u3001\u305d\u308c\u306fUnity Catalog\u3092\u88dc\u5b8c\u3059\u308b\u3082\u306e\u3067\u3059\u3002Unity Catalog\u306f\u3001\u305d\u308c\u3092\u901a\u3057\u3066\u5b9f\u884c\u3055\u308c\u308b\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306e\u5c65\u6b74\u3092\u81ea\u52d5\u7684\u306b\u8a18\u9332\u3057\u307e\u3059\u3002SQLFlow\u306fSQL\u3092\u9759\u7684\u306b\u5206\u6790\u3059\u308b\u305f\u3081\u3001\u5b9f\u884c\u524d\u306e\u30b3\u30fc\u30c9\uff08\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\uff09\u3001Unity Catalog\u306e\u5916\u90e8\u3067\u5b9f\u884c\u3055\u308c\u308bSQL\u3001Databricks\u3068\u4ed6\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u307e\u305f\u304c\u308b\u74b0\u5883\u3092\u7db2\u7f85\u3057\u3001\u305d\u306e\u7d50\u679c\u3092DataHub\u3001Purview\u3001\u307e\u305f\u306fOpenMetadata\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f\u79c1\u306eDatabricks\u30ef\u30fc\u30af\u30b9\u30da\u30fc\u30b9\u3084\u30c7\u30fc\u30bf\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u5fc5\u8981\u3068\u3057\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\u3066\u30b9\u30ad\u30fc\u30de\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u53c2\u7167\u3092\u89e3\u6c7a\u3057\u307e\u3059\u3002Delta\u30c6\u30fc\u30d6\u30eb\u306e\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\u7559\u307e\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306fMERGE INTO\u6587\u3092\u901a\u3057\u3066\u7cfb\u8b5c\u3092\u8ffd\u8de1\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002\u30c7\u30eb\u30bf\u822a\u7a7a\u306e\u5834\u5408\u3002 <code>\u30de\u30fc\u30b8\u3059\u308b<\/code>SQLFlow \u306f\u3001 <code>\u4f7f\u7528<\/code> \u30b5\u30d6\u30af\u30a8\u30ea\u306f\u3001\u5404\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u3092\u3001 <code>\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8<\/code> \u3068 <code>\u5165\u308c\u308b<\/code> \u5206\u5c90\u3057\u3001\u4e00\u81f4\u6761\u4ef6\u3068\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u9593\u63a5\u7684\uff08\u5f71\u97ff\uff09\u7cfb\u7d71\u3068\u3057\u3066\u5206\u985e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Databricks\u306fSQLFlow\u306b\u304a\u3051\u308bSpark SQL\u3068\u306f\u7570\u306a\u308b\u65b9\u8a00\u306a\u306e\u3067\u3057\u3087\u3046\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002SQLFlow \u306e 39 \u306e\u30b5\u30dd\u30fc\u30c8\u5bfe\u8c61\u65b9\u8a00\u306b\u306f\u3001Databricks \u3068 Spark SQL \u304c\u5225\u3005\u306b\u8a18\u8f09\u3055\u308c\u3066\u304a\u308a\u3001\u305d\u308c\u305e\u308c Spark SQL \u30d5\u30a1\u30df\u30ea\u30fc\u306b\u72ec\u81ea\u306e\u30d1\u30fc\u30b5\u30fc\u304c\u3042\u308a\u307e\u3059\u3002Databricks \u306b\u5bfe\u3057\u3066\u8a18\u8ff0\u3055\u308c\u305f SQL \u306b\u306f Databricks \u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5c02\u7528\u306e <a href=\"https:\/\/www.gudusoft.com\/jp\/spark-sql-data-lineage\/\">Spark SQL\u306e\u7cfb\u8b5c\u30da\u30fc\u30b8<\/a> \u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306eSpark\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u5411\u3051\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Databricks\u4e0a\u306edbt\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3082\u52d5\u4f5c\u3057\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002dbt\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3068\u3001SQLFlow\u304cDatabricks\u65b9\u8a00\u3092\u4f7f\u7528\u3057\u3066\u30b3\u30f3\u30d1\u30a4\u30eb\u6e08\u307fSQL\u3092\u89e3\u6790\u3057\u3001\u30e2\u30c7\u30eb\u5168\u4f53\u306b\u308f\u305f\u308b\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u60c5\u5831\u3092\u751f\u6210\u3057\u307e\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\u30d7\u30e9\u30f3\u306f\u6708\u984d$49.99\u3002\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u30d7\u30e9\u30f3\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\">Databricks\u306e\u7cfb\u8b5c\u3092\u4eca\u3059\u3050\u8fbf\u3063\u3066\u307f\u3088\u3046<\/h2>\n\n\n<p>Spark SQL\u30af\u30a8\u30ea\u307e\u305f\u306fDelta MERGE\u3092\u7121\u6599\u306e\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30b6\u30fc\u306b\u8cbc\u308a\u4ed8\u3051\u308b\u304b\u3001\u79fb\u884c\u74b0\u5883\u5168\u4f53\u306e\u30b9\u30ad\u30e3\u30f3\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=databricks-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\u3092\u7121\u6599\u3067\u304a\u8a66\u3057\u304f\u3060\u3055\u3044<\/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\/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\\\/sql-data-lineage-tool\\\/\",\n            \"description\": \"Automated SQL data lineage tool with a dedicated Databricks dialect parser: column-level lineage for Spark SQL and Delta Lake MERGE statements, with export to DataHub, Microsoft Purview, and OpenMetadata.\",\n            \"featureList\": \"Databricks dialect parser, column-level lineage, indirect\\\/impact lineage, Delta MERGE INTO analysis, dbt support, cross-platform migration analysis across 39 dialects, DataHub\\\/Purview\\\/OpenMetadata 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 replace Unity Catalog lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No, it complements it. Unity Catalog captures lineage for workloads that run through it. SQLFlow analyzes SQL statically, covering code before it runs (migrations), SQL executed outside Unity Catalog, and cross-platform estates, then exports to DataHub, Purview, or OpenMetadata.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to my Databricks workspace or data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata. It never reads rows in your Delta tables, and the On-Premise edition keeps SQL text inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through MERGE INTO statements?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. For a Delta MERGE INTO, SQLFlow resolves the USING subquery, maps each target column to its source columns through both the UPDATE and INSERT branches, and classifies match conditions and filters as indirect lineage.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is Databricks a distinct dialect from Spark SQL in SQLFlow?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow's 39 supported dialects list Databricks and Spark SQL separately, each with its own dialect-specific parser in the Spark SQL family.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow work with dbt projects on Databricks?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Import the dbt manifest and SQLFlow produces column-level lineage across your models, parsing the compiled SQL with the Databricks dialect.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium is $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>Databricks data lineage is the column-level map of how data flows through your Spark SQL and Delta Lake code: which source columns feed each target table across your bronze, silver, and gold layers, and which transformations \u2014 joins, aggregates, MERGE logic \u2014 happen along the way. Unity Catalog captures lineage automatically for workloads that run through it; Gudu SQLFlow covers everything else by parsing the SQL itself, which makes it the tool for migrations into Databricks, SQL that runs outside Unity Catalog, and estates that span Databricks plus other platforms. Try it in 30 seconds: paste a Databricks MERGE INTO\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\/6753"}],"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=6753"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages\/6753\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media?parent=6753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}