{"id":6969,"date":"2025-07-17T16:43:58","date_gmt":"2025-07-17T07:43:58","guid":{"rendered":"https:\/\/blog.since2020.jp\/?p=6969"},"modified":"2025-07-17T16:44:56","modified_gmt":"2025-07-17T07:44:56","slug":"databricks_genie","status":"publish","type":"post","link":"https:\/\/since2020.jp\/media\/databricks_genie\/","title":{"rendered":"\u3010Databricks\u3011\u30c7\u30fc\u30bf\u00d7\u751f\u6210AI \u300cgenie\u300d\u306e\u7d39\u4ecb\u3068\u4f7f\u3044\u65b9"},"content":{"rendered":"\n<p>\u8fd1\u5e74\u3001AI\u6280\u8853\u306e\u767a\u5c55\u306f\u79c1\u305f\u3061\u306e\u30d3\u30b8\u30cd\u30b9\u306e\u3042\u308a\u65b9\u3092\u5927\u304d\u304f\u5909\u3048\u3066\u3044\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u591a\u304f\u306e\u4f01\u696d\u3067\u306f\u30c7\u30fc\u30bf\u6d3b\u7528\u3084AI\u5c0e\u5165\u306b\u304a\u3051\u308b\u8ab2\u984c\u304c\u5c71\u7a4d\u3057\u3066\u3044\u307e\u3059\u3002\u305d\u3053\u3067\u4eca\u56de\u306f\u3001\u6ce8\u76ee\u306e\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u300cDatabricks\u300d\u3068\u305d\u306e\u751f\u6210AI\u30c4\u30fc\u30eb\u3067\u3042\u308b\u300cgenie\u300d\u306e\u6d3b\u7528\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002AI\u3068\u30c7\u30fc\u30bf\u304c\u7d71\u5408\u3055\u308c\u305f\u74b0\u5883\u3067\u306e\u52b9\u7387\u7684\u306a\u30d3\u30b8\u30cd\u30b9\u5206\u6790\u306e\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n<h2>\u306f\u3058\u3081\u306b<\/h2>\n<p>\u8fd1\u5e74\u3001AI\u6280\u8853\u306e\u767a\u5c55\u306f\u79c1\u305f\u3061\u306e\u30d3\u30b8\u30cd\u30b9\u306e\u3042\u308a\u65b9\u3092\u5927\u304d\u304f\u5909\u3048\u3066\u3044\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u591a\u304f\u306e\u4f01\u696d\u3067\u306f\u30c7\u30fc\u30bf\u6d3b\u7528\u3084AI\u5c0e\u5165\u306b\u304a\u3051\u308b\u8ab2\u984c\u304c\u5c71\u7a4d\u3057\u3066\u3044\u307e\u3059\u3002\u305d\u3053\u3067\u4eca\u56de\u306f\u3001\u6ce8\u76ee\u306e\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u300cDatabricks\u300d\u3068\u305d\u306e\u751f\u6210AI\u30c4\u30fc\u30eb\u3067\u3042\u308b\u300cgenie\u300d\u306e\u6d3b\u7528\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002AI\u3068\u30c7\u30fc\u30bf\u304c\u7d71\u5408\u3055\u308c\u305f\u74b0\u5883\u3067\u306e\u52b9\u7387\u7684\u306a\u30d3\u30b8\u30cd\u30b9\u5206\u6790\u306e\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n<h2>1. Databricks\u3068\u306f<\/h2>\n<p>Databricks\u3068\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3068AI\u904b\u7528\u3092\u7d71\u5408\u3057\u3066\u69cb\u7bc9\u30fb\u30c7\u30d7\u30ed\u30a4\u30fb\u5171\u6709\u30fb\u4fdd\u5b88\u3092\u884c\u3048\u308b\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3059\u3002Databricks\u306f\u3001\u4ee5\u4e0b\u306e\u5c64\u3067\u69cb\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\r\n<ul>\r\n\t<li><strong>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30b9\u30c8\u30ec\u30fc\u30b8\u5c64<\/strong>\uff1aAWS S3\u3084Google Cloud Storage(GCS)\u306a\u3069\u3092\u6d3b\u7528\u3057\u3066\u5168\u3066\u306e\u751f\u30c7\u30fc\u30bf\u3092\u683c\u7d0d<\/li>\r\n\t<li><strong>\u30c7\u30fc\u30bf\u30ec\u30a4\u30af\u5c64<\/strong>\uff1aDelta Lake\u3092\u6d3b\u7528\u3057\u3066\u30c7\u30fc\u30bf\u3092\u7dcf\u5408\u7684\u306b\u7ba1\u7406<\/li>\r\n\t<li><strong>\u30c7\u30fc\u30bf\u7ba1\u7406\u5c64<\/strong>\uff1aUnity Catalog\u3092\u4f7f\u7528\u3057\u3066\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3068\u30ac\u30d0\u30ca\u30f3\u30b9\u3092\u4e00\u5143\u7ba1\u7406<\/li>\r\n<\/ul>\r\n<p>Databricks\u306e\u6700\u5927\u306e\u7279\u5fb4\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u5206\u6790\u3001\u6a5f\u68b0\u5b66\u7fd2\u3001SQL\u51e6\u7406\u3001\u751f\u6210AI\u307e\u3067\u3092\u30b7\u30fc\u30e0\u30ec\u30b9\u306b\u7d71\u5408\u3057\u3066\u3044\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\r\n<p>\u4eca\u56de\u306e\u30d6\u30ed\u30b0\u3067\u306f\u30c7\u30fc\u30bf\u57fa\u76e4\u30c4\u30fc\u30eb\u3067\u3042\u308bDatabricks\u4e0a\u306b\u4ed8\u968f\u3059\u308b\u300cgenie\u300d\u306b\u3064\u3044\u3066\u7d39\u4ecb\u3057\u7406\u89e3\u3092\u6df1\u3081\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\r\n<p><!-- notionvc: 723be9f5-866d-4e59-bbc9-e7f0406d8e11 --><\/p>\n\n<h2>2. Databricks\u751f\u6210AI\u300cgenie\u300d\u306e\u6d3b\u7528\u80cc\u666f<\/h2>\n<p>\u591a\u304f\u306e\u4f01\u696d\u3067\u306f\u3001\u610f\u601d\u6c7a\u5b9a\u3092\u884c\u3046\u969b\u306b\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3092\u5229\u7528\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u3053\u308c\u306f\u4e3b\u306b\u30d1\u30bf\u30fc\u30f3\u3084\u50be\u5411\u3092\u8996\u899a\u7684\u306b\u8868\u793a\u3059\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-56.jpg\" alt=\"\" width=\"1251\" height=\"663\" class=\"aligncenter size-full wp-image-6970\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-56.jpg 1251w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-56-300x159.jpg 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-56-1024x543.jpg 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-56-768x407.jpg 768w\" sizes=\"(max-width: 1251px) 100vw, 1251px\" \/><\/p>\r\n<p>\u3057\u304b\u3057\u3001\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306b\u306f\u9650\u754c\u304c\u3042\u308a\u307e\u3059\u3002\u500b\u4eba\u304c\u6c42\u3081\u308b\u5177\u4f53\u7684\u306a\u60c5\u5831\u3092\u67d4\u8edf\u306b\u8868\u793a\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002\u4f8b\u3048\u3070\u3001\u300c\u5009\u5eab\u306e\u7a3c\u50cd\u7387\u306f\uff1f\u300d\u300c\u5f93\u696d\u54e1\u306e\u6b20\u52e4\u56de\u6570\u306f\uff1f\u300d\u306a\u3069\u3001\u7d30\u304b\u306a\u7591\u554f\u306b\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u5bfe\u5fdc\u3059\u308b\u3053\u3068\u306f\u5bb9\u6613\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-57.jpg\" alt=\"\" width=\"1248\" height=\"662\" class=\"aligncenter size-full wp-image-6971\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-57.jpg 1248w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-57-300x159.jpg 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-57-1024x543.jpg 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-57-768x407.jpg 768w\" sizes=\"(max-width: 1248px) 100vw, 1248px\" \/><\/p>\r\n<p>\u3059\u306a\u308f\u3061\u3001\u73fe\u72b6\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306fKPI\u306a\u3069\u306e\u5171\u6709\u3059\u308b\u3079\u304d\u9805\u76ee\u3092\u4e00\u62ec\u3067\u8868\u793a\u3059\u308b\u90e8\u5206\u306f\u512a\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u30e6\u30fc\u30b6\u30fc\u500b\u4eba\u304c\u77e5\u308a\u305f\u3044\u60c5\u5831\u3092\u4efb\u610f\u306e\u7c92\u5ea6\u3067\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u306b\u306f\u5411\u3044\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58.png\" alt=\"\" width=\"504\" height=\"272\" class=\"aligncenter size-full wp-image-6972\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58.png 504w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58-300x162.png 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/p>\r\n<p>Databricks\u306e\u300cgenie\u300d\u306f\u3001\u3053\u306e\u3088\u3046\u306a\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059\u3002\u300cgenie\u300d\u3092\u4f7f\u3048\u3070\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u30c7\u30fc\u30bf\u3068\u76f4\u63a5\u4f1a\u8a71\u3092\u884c\u3046\u3088\u3046\u306a\u611f\u899a\u3067\u30c7\u30fc\u30bf\u3092\u63a2\u6c42\u3057\u3001\u3088\u308a\u8fc5\u901f\u304b\u3064\u6b63\u78ba\u306a\u610f\u601d\u6c7a\u5b9a\u304c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n<h2>3. \u30c7\u30fc\u30bf\u6d3b\u7528\u3068\u3057\u3066\u306e\u300cgenie\u300d<\/h2>\n<b>\u30c7\u30fc\u30bf\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3068\u306f<\/b>\r\n<p>Databricks\u306f\u3001\u300cgenie\u300d\u3092\u4e2d\u5fc3\u306b\u30c7\u30fc\u30bf\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3092\u5c55\u958b\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u3001\u4f01\u696d\u304c\u4fdd\u6301\u3059\u308b\u7279\u6709\u306e\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u304d\u3001\u7279\u5b9a\u306e\u554f\u984c\u306b\u7279\u5316\u3057\u305fAI\u3092\u63d0\u4f9b\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u5e83\u7bc4\u306a\u4e00\u822c\u7684\u30c7\u30fc\u30bf\u3060\u3051\u3092\u4f7f\u3063\u305f\u6c4e\u7528\u7684\u306aAI\u30e2\u30c7\u30eb\u3068\u306f\u7570\u306a\u308a\u3001\u4f01\u696d\u7279\u6709\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3059\u308b\u529b\u5f37\u3044\u30c4\u30fc\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\r\n<b>geni\u304c\u56de\u7b54\u3092\u751f\u6210\u3059\u308b\u4ed5\u7d44\u307f<\/b>\r\n<p>\u3053\u3053\u3067genie\u304c\u56de\u7b54\u3092\u751f\u6210\u3059\u308b\u4ed5\u7d44\u307f\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002\u901a\u5e38\u306e\u751f\u6210AI\u306f\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u5165\u529b\u3055\u308c\u305f\u60c5\u5831\u304b\u3089\u7b54\u3048\u3092\u751f\u6210\u3057\u307e\u3059\u304c\u3001genie\u306f\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u5165\u529b\u3055\u308c\u305f\u60c5\u5831\u3060\u3051\u3067\u306a\u304fDatabricks\u4e0a\u3067\u4fdd\u6709\u3059\u308b\u30c7\u30fc\u30bf\u3084\u30ce\u30fc\u30c9\u30d6\u30c3\u30af\u3001\u904e\u53bb\u306e\u30c1\u30e3\u30c3\u30c8\u306e\u5c65\u6b74\u306a\u3069Databricks\u4e0a\u306e\u8cc7\u7523\u3092\u7d71\u5408\u3057\u3066\u56de\u7b54\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u30e6\u30fc\u30b6\u30fc\u56fa\u6709\u306e\u60c5\u5831\u306b\u57fa\u3065\u3044\u3066\u56de\u7b54\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308b\u306e\u3067\u3059\u3002<\/p>\r\n<p><!-- notionvc: 5f3dfe7a-2edb-44b1-a382-e2606e2e04c3 --><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58.png\" alt=\"\" width=\"504\" height=\"272\" class=\"aligncenter size-full wp-image-6972\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58.png 504w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-58-300x162.png 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/p>\r\n<b>\u30cf\u30f3\u30ba\u30aa\u30f3<\/b>\r\n<p>\u3067\u306f\u3053\u3053\u304b\u3089\u306f\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u3001\u56fa\u6709\u306e\u60c5\u5831\u306b\u57fa\u3065\u3044\u3066\u7d50\u679c\u3092\u51fa\u529b\u3057\u3066\u304f\u308c\u308b\u304b\u691c\u8a3c\u3092\u3057\u307e\u3059\u3002<\/p>\r\n<p>\u4eca\u56de\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u306f\u30a2\u30e1\u30ea\u30ab\u306e\u30b9\u30fc\u30d1\u30fc\u30de\u30fc\u30b1\u30c3\u30c8\u300cWalmart\u300d\u306e\u9031\u6b21\u58f2\u4e0a\u30c7\u30fc\u30bf\u3067\u3059\u3002\u8a73\u7d30\u3092\u4ee5\u4e0b\u306b\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\r\n<p><!-- notionvc: b10db5fd-6fda-4fe6-a501-7f74c8feef4a --><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-60.png\" alt=\"\" width=\"508\" height=\"267\" class=\"aligncenter size-full wp-image-6973\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-60.png 508w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-60-300x158.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/p>\r\n<p>\u53c2\u8003\uff1a<\/p>\r\n<p><a href=\"https:\/\/www.kaggle.com\/datasets\/yasserh\/walmart-dataset\">https:\/\/www.kaggle.com\/datasets\/yasserh\/walmart-dataset<\/a><\/p>\r\n<p><!-- notionvc: 11a13c8f-1bb8-456d-b14b-42631048f172 --><\/p>\r\n<p>\u3067\u306f\u65e9\u901fgenie\u306b\u5bfe\u3057\u3066\u8cea\u554f\u3092\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\r\n<p><strong>\u8cea\u554f1\uff1a<\/strong><\/p>\r\n<p>\u5e97\u8217\u3054\u3068\u306e\u5408\u8a08\u58f2\u4e0a\u9ad8\u3092\u51fa\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\r\n<p><strong>\u7d50\u679c\uff1a<\/strong><\/p>\r\n<p><!-- notionvc: 24bc10ba-5b5b-4baa-9c8d-faca8ae74a27 --><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61.png\" alt=\"\" width=\"871\" height=\"630\" class=\"aligncenter size-full wp-image-6974\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61.png 871w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61-300x217.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61-768x555.png 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/p>\r\n<p>\u3053\u306e\u3088\u3046\u306b\u5404\u5e97\u8217\u3054\u3068\u306e\u5408\u8a08\u58f2\u4e0a\u9ad8\u3092\u30c7\u30fc\u30bf\u304b\u3089\u51fa\u529b\u3057\u3066\u304f\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\r\n<p><strong>SQL\uff1a<\/strong><\/p>\r\n<p>\u307e\u305f\u3001\u4f5c\u6210\u3055\u308c\u305fSQL\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3082\u51fa\u6765\u307e\u3059\u3002<\/p>\r\n<p><!-- notionvc: 2075ac07-d945-44b7-b816-453b6cad36e3 --><\/p>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT\r\n`Store`,\r\nSUM(`Weekly_Sales`) AS `Total_Sales`\r\nFROM\r\n`--------`.`default`.`walmart_master`\r\nGROUP BY\r\n`Store`\r\nORDER BY\r\n`Total_Sales` DESC;\r\n<\/code><\/pre>\r\n<\/div>\r\n<p>\u3053\u308c\u306b\u3088\u308a\u6b63\u3057\u304f\u8a08\u7b97\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\r\n<p><strong>\u8cea\u554f\uff12\uff1a<\/strong><\/p>\r\n<p>\u795d\u65e5\u3092\u542b\u3080\u9031\u306e\u5408\u8a08\u58f2\u4e0a\u9ad8\u306f\u3069\u308c\u304f\u3089\u3044\u3067\u3059\u304b\uff1f\uff1f\u5e97\u8217\u3054\u3068\u306b\u307e\u3068\u3081\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\r\n<p><strong>\u7d50\u679c\uff1a<\/strong><\/p>\r\n<p><!-- notionvc: 510d8763-132b-45f1-9dca-113ac1212046 --><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61.png\" alt=\"\" width=\"871\" height=\"630\" class=\"aligncenter size-full wp-image-6974\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61.png 871w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61-300x217.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/07\/image-61-768x555.png 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/> \u3053\u306e\u3088\u3046\u306b\u8cea\u554f\u306b\u5bfe\u3059\u308b\u7b54\u3048\u3068\u63cf\u753b\u304c\u8fd4\u3063\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\r\n<p><span data-token-index=\"0\" class=\"notion-enable-hover\">SQL:<\/span><!-- notionvc: 11f281c0-fdfb-4ce6-bd74-a848ed237bc7 --><\/p>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT\r\n`Store`,\r\nSUM(`Weekly_Sales`) AS `Total_Sales`\r\nFROM\r\n`since_workspace_aws`.`default`.`walmart_master`\r\nWHERE\r\n`Holiday_Flag` = 1\r\nGROUP BY\r\n`Store`\r\nORDER BY\r\n`Total_Sales` DESC;<\/code><\/pre>\r\n<\/div>\r\n<p>\u540c\u69d8\u306b\u795d\u65e5\u306b\u9650\u5b9a\u3057\u305f\u7d50\u679c\u3092\u8fd4\u3057\u3066\u304f\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3055\u308c\u307e\u3059\u3002<\/p>\n\n<h2>\u7d42\u308f\u308a\u306b<\/h2>\n<p>Databricks\u306e\u751f\u6210AI\u300cgenie\u300d\u306f\u3001\u4f01\u696d\u306e\u30c7\u30fc\u30bf\u6d3b\u7528\u3084\u610f\u601d\u6c7a\u5b9a\u306e\u8fc5\u901f\u5316\u306b\u5927\u304d\u306a\u8ca2\u732e\u3092\u679c\u305f\u3057\u307e\u3059\u3002\u3053\u308c\u307e\u3067\u30c7\u30fc\u30bf\u5206\u6790\u3084AI\u306e\u5c0e\u5165\u306b\u82e6\u52b4\u3057\u3066\u3044\u305f\u4f01\u696d\u3067\u3082\u3001genie\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u30c7\u30fc\u30bf\u99c6\u52d5\u578b\u306e\u4f01\u696d\u6587\u5316\u3092\u91b8\u6210\u3057\u3001\u30d3\u30b8\u30cd\u30b9\u6210\u679c\u3092\u5927\u304d\u304f\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u8fd1\u5e74\u3001AI\u6280\u8853\u306e\u767a\u5c55\u306f\u79c1\u305f\u3061\u306e\u30d3\u30b8\u30cd\u30b9\u306e\u3042\u308a\u65b9\u3092\u5927\u304d\u304f\u5909\u3048\u3066\u3044\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u591a\u304f\u306e\u4f01\u696d\u3067\u306f\u30c7\u30fc\u30bf\u6d3b\u7528\u3084AI\u5c0e\u5165\u306b\u304a\u3051\u308b\u8ab2\u984c\u304c\u5c71\u7a4d\u3057\u3066\u3044\u307e\u3059\u3002\u305d\u3053\u3067\u4eca\u56de\u306f\u3001\u6ce8\u76ee\u306e\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u300cDatabricks\u300d\u3068\u305d\u306e\u751f\u6210 [&hellip;]<\/p>\n","protected":false},"author":44,"featured_media":6170,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","swell_btn_cv_data":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[1246],"tags":[774,1068,564,651],"class_list":["post-6969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-infrastructure","tag-databricks","tag-genie","tag-llm","tag-ai"],"_links":{"self":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/6969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/comments?post=6969"}],"version-history":[{"count":0,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/6969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media\/6170"}],"wp:attachment":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media?parent=6969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/categories?post=6969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/tags?post=6969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}