{"id":6097,"date":"2025-09-19T07:07:22","date_gmt":"2025-09-19T07:07:22","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=6097"},"modified":"2025-09-19T07:07:22","modified_gmt":"2025-09-19T07:07:22","slug":"databricks%e3%81%a7%e8%87%aa%e5%88%86%e3%81%ae%e7%84%a1%e6%96%99rag%e3%83%81%e3%83%a3%e3%83%83%e3%83%88%e3%83%9c%e3%83%83%e3%83%88%e3%82%92%e4%bd%9c%e3%81%a3%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/6097\/","title":{"rendered":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! &#8211; APC \u6280\u8853\u30d6\u30ed\u30b0"},"content":{"rendered":"\n<\/p>\n<div>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250916\/20250916182823.jpg\" width=\"1200\" height=\"630\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<h3 id=\"\u306f\u3058\u3081\u306b\"><strong>\u306f\u3058\u3081\u306b<\/strong><\/h3>\n<p>\u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30baGDAI\u4e8b\u696d\u90e8Lakehouse\u90e8\u306e\u912d(\u30b8\u30e7\u30f3)\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001<a target=\"_blank\" href=\"https:\/\/www.databricks.com\/jp\/blog\/introducing-databricks-free-edition\">Databricks\u306eFree Edition<\/a>\u3092\u5229\u7528\u3057\u3066RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u306e\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u306f\u3001Unity Catalog\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u5229\u7528\u3057\u3066RAG\u3092\u69cb\u7bc9\u3057\u3001Databricks Apps\u4e0a\u3067\u30c7\u30d7\u30ed\u30a4\u3057\u307e\u3057\u305f\u3002<br \/>\nFree Edition\u3067\u306f\u3001Databricks\u306b\u5185\u8535\u3055\u308c\u3066\u3044\u308b\u30e2\u30c7\u30eb\u3092\u5229\u7528\u3057\u3066\u3001\u7121\u6599\u3067\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\n\u305f\u3060\u3057\u3001\u6a5f\u5bc6\u6027\u306e\u9ad8\u3044\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u306b\u306f\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3042\u308a\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3042\u3089\u304b\u3058\u3081\u53d6\u3063\u3066\u304a\u304f\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n<h3 id=\"\u76ee\u6b21\"><strong>\u76ee\u6b21<\/strong><\/h3>\n<h3 id=\"RAG\u69cb\u7bc9\"><strong>RAG\u69cb\u7bc9<\/strong><\/h3>\n<p>\u4eca\u56de\u306f\u3001RAG\u69cb\u7bc9\u30b9\u30c6\u30c3\u30d7\u3092\u7c21\u5358\u306b\u3059\u308b\u305f\u3081\u3001Databricks\u306eVector Search\u3092\u5229\u7528\u305b\u305a\u3001\u30d9\u30af\u30c8\u30ebDB\u3068\u3057\u3066ChromaDB\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li>ChromaDB\u306e\u5834\u5408\u306f\u3001<code>chroma_client.get_or_create_collection()<\/code>\u3092\u5229\u7528\u3057\u3066app.py\u306e\u4e2d\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u751f\u6210\u3068\u691c\u7d22\u3092\u305d\u306e\u307e\u307e\u5229\u7528\u3057\u307e\u3059\u3002<\/li>\n<li>Databricks Vector Search\u306e\u5834\u5408\u306f\u3001embedding\u30c6\u30fc\u30d6\u30eb\u3092\u6e96\u5099\u3057\u305f\u306e\u3068\u540c\u3058\u3088\u3046\u306b\u3001\u5225\u306e\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u3067 <code>VectorSearchClient().create_delta_sync_index()<\/code>\u3092\u5b9f\u884c\u3057\u3066\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f5c\u6210\u3057\u3001\u305d\u306e\u5f8c app.py\u3067 <code>VectorSearchClient().get_index().similarity_search()<\/code>\u3092\u5229\u7528\u3057\u3066\u691c\u7d22\u3092\u884c\u3044\u307e\u3059\u3002<\/li>\n<\/ul>\n<p>ChromaDB\u306f\u30a4\u30f3\u30e1\u30e2\u30ea\u578b\u306eDB\u3068\u3057\u3066\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u69cb\u7bc9\u306e\u30d1\u30fc\u30c8\u3067\u5b9a\u7fa9\u3055\u308c\u307e\u3059\u3002<br \/>Databricks\u306eVector Search\u3092\u5229\u7528\u3057\u305f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u30d6\u30ed\u30b0\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fqiita.com%2Ftaka_yayoi%2Fitems%2F3656de6bf8fb2b5a06dd%23vector-search%25E3%2582%25A4%25E3%2583%25B3%25E3%2583%2587%25E3%2583%2583%25E3%2582%25AF%25E3%2582%25B9%25E3%2581%25AB%25E5%25BF%2585%25E8%25A6%2581%25E3%2581%25AA%25E3%2582%2582%25E3%2581%25AE\" title=\"Databricks Apps\u306b\u3088\u308b\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9\u30a2\u30d7\u30ea\u306e\u30c7\u30d7\u30ed\u30a4 - Qiita\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/qiita.com\/taka_yayoi\/items\/3656de6bf8fb2b5a06dd#vector-search%E3%82%A4%E3%83%B3%E3%83%87%E3%83%83%E3%82%AF%E3%82%B9%E3%81%AB%E5%BF%85%E8%A6%81%E3%81%AA%E3%82%82%E3%81%AE\">qiita.com<\/a><\/cite><\/p>\n<p>RAG\u306b\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u3092Unity Catalog\u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002<br \/>\n\u79c1\u306f\u3001Databricks\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3057\u307e\u3057\u305f\u3002<br \/>\n\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u306b\u306f\u82f1\u8a9e\u306b\u5f37\u3044\u300cdatabricks-bge-large-en\u300d\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3057\u3001requests.post\u3092\u901a\u3058\u3066\u30e2\u30c7\u30eb\u3092\u547c\u3073\u51fa\u3057\u3001\u30c7\u30fc\u30bf\u3092\u30d9\u30af\u30c8\u30eb\u5316\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250911\/20250911170046.png\" width=\"911\" height=\"634\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u30e2\u30c7\u30eb\u306b\u95a2\u3059\u308b\u8a73\u7d30\u306f\u3001\u4ee5\u4e0b\u306e\u30ea\u30f3\u30af\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fdocs.databricks.com%2Faws%2Fja%2Fmachine-learning%2Ffoundation-model-apis%2Fsupported-models%23bge-large-en\" title=\"\u57fa\u76e4\u30e2\u30c7\u30ebAPI\u3067\u5229\u7528\u3067\u304d\u308bDatabricks\u304c\u30db\u30b9\u30c8\u3059\u308b\u57fa\u76e4\u30e2\u30c7\u30eb | Databricks on AWS\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/docs.databricks.com\/aws\/ja\/machine-learning\/foundation-model-apis\/supported-models#bge-large-en\">docs.databricks.com<\/a><\/cite><\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synPreProc\">import<\/span> os\n<span class=\"synPreProc\">import<\/span> requests\n<span class=\"synPreProc\">from<\/span> pyspark.sql <span class=\"synPreProc\">import<\/span> SparkSession\n<span class=\"synPreProc\">import<\/span> pandas <span class=\"synStatement\">as<\/span> pd\n\nspark = SparkSession.builder.getOrCreate()\n\nUC_TABLE = <span class=\"synConstant\">\"apps_data.dbx_doc.databricks_doc\"<\/span>\nEMBEDDING_ENDPOINT = <span class=\"synConstant\">\"Model\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"<\/span>\nDATABRICKS_TOKEN = <span class=\"synConstant\">\"\u30c8\u30fc\u30af\u30f3\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"<\/span>\n\nheaders = {\n    <span class=\"synConstant\">\"Authorization\"<\/span>: f<span class=\"synConstant\">\"Bearer {DATABRICKS_TOKEN}\"<\/span>,\n    <span class=\"synConstant\">\"Content-Type\"<\/span>: <span class=\"synConstant\">\"application\/json\"<\/span>\n}\n\n\ndf_spark = spark.table(UC_TABLE).select(<span class=\"synConstant\">\"id\"<\/span>, <span class=\"synConstant\">\"url\"<\/span>, <span class=\"synConstant\">\"content\"<\/span>)  \ndf = df_spark.toPandas() \n\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">get_embedding<\/span>(text: <span class=\"synIdentifier\">str<\/span>):\n    resp = requests.post(\n        EMBEDDING_ENDPOINT,\n        headers=headers,\n        json={<span class=\"synConstant\">\"input\"<\/span>: text}\n    )\n    resp.raise_for_status()\n    <span class=\"synStatement\">return<\/span> resp.json()[<span class=\"synConstant\">\"data\"<\/span>][<span class=\"synConstant\">0<\/span>][<span class=\"synConstant\">\"embedding\"<\/span>]\n\n\ndf[<span class=\"synConstant\">\"embedding\"<\/span>] = df[<span class=\"synConstant\">\"content\"<\/span>].apply(get_embedding)\n\n\ndf_spark_new = spark.createDataFrame(df)\ndf_spark_new.write.mode(<span class=\"synConstant\">\"overwrite\"<\/span>).option(<span class=\"synConstant\">\"overwriteSchema\"<\/span>, <span class=\"synConstant\">\"true\"<\/span>).saveAsTable(<span class=\"synConstant\">\"apps_data.dbx_doc.databricks_doc\"<\/span>)\n\n<span class=\"synIdentifier\">print<\/span>(f<span class=\"synConstant\">\"\u2705 {UC_TABLE} \u30c6\u30fc\u30d6\u30eb\u306eembedding\u30ab\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u3002\"<\/span>)\n<\/pre>\n<h3 id=\"Application\u69cb\u7bc9\"><strong>Application\u69cb\u7bc9<\/strong><\/h3>\n<p>\u6b21\u306bDatabricks Apps\u3092\u5229\u7528\u3057\u3066Chatbot Application\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002<\/p>\n<p>Apps\u306fCompute\u3067\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<br \/>\nCompute\u306eApps\u30bf\u30d6\u3067\u300cCreate app\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250911\/20250911170952.png\" width=\"740\" height=\"221\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>GradioChatbot\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250911\/20250911175454.png\" width=\"630\" height=\"761\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u5e0c\u671b\u3059\u308bLLM\u30ea\u30bd\u30fc\u30b9\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u79c1\u306f\u300cdatabricks-gpt-oss-120b\u300d\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250911\/20250911175838.png\" width=\"755\" height=\"753\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u30ea\u30bd\u30fc\u30b9\u3092\u9078\u629e\u3057\u305f\u5f8c\u3001\u300cInstall\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3068\u3001\u57fa\u672c\u306eLLMChatbot\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912103844.png\" width=\"646\" height=\"477\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>Rag\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u306b\u5fc5\u8981\u306a\u30ea\u30bd\u30fc\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u305f\u3081\u306b\u300cEdit\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>Running\u306e\u6a2a\u306b\u3042\u308bURL\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30c7\u30d7\u30ed\u30a4\u3055\u308c\u305f\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u958b\u304f\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n<li>Deployment\u306e\u4e0b\u306b\u3042\u308bURL\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u958b\u304f\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ul>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912105007.png\" width=\"725\" height=\"511\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u79c1\u306f\u5408\u8a08\u30673\u3064\u306e\u30ea\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u307e\u3057\u305f\u3002<\/p>\n<ol>\n<li>Apps\u3092Install\u3059\u308b\u969b\u306b\u9078\u629e\u3057\u305fLLM\u7528\u306e\u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/li>\n<li>\u30d9\u30af\u30bf\u30fc\u691c\u7d22\u306e\u305f\u3081\u306e\u57cb\u3081\u8fbc\u307f\u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\uff08RAG\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u6642\u3068\u540c\u3058\u3082\u306e\uff09<\/li>\n<li>Unity Catalog\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u8aad\u307f\u53d6\u308b\u969b\u306b\u4f7f\u7528\u3059\u308bSQL Warehouse<\/li>\n<\/ol>\n<p>\u305d\u308c\u305e\u308c\u306e\u6a29\u9650\u3068\u30ea\u30bd\u30fc\u30b9\u30ad\u30fc\u306f\u3001\u753b\u50cf\u306e\u3088\u3046\u306b\u767b\u9332\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912110620.png\" width=\"636\" height=\"729\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>App resources\u3067\u767b\u9332\u3055\u308c\u305f\u30ea\u30bd\u30fc\u30b9\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912112417.png\" width=\"731\" height=\"194\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>Deployment\u306e\u4e0b\u306b\u3042\u308bURL\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u304a\u3088\u3073\u4fee\u6b63\u3057\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912112308.png\" width=\"734\" height=\"506\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>Databricks Apps\u3092Install\u3059\u308b\u969b\u306b\u81ea\u52d5\u7684\u306b\u751f\u6210\u3055\u308c\u305f4\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002<br \/>\n\u306a\u304a\u3001\u751f\u6210\u5f8c\u306b\u8ffd\u52a0\u3057\u305f\u30ea\u30bd\u30fc\u30b9\u306b\u3064\u3044\u3066\u306f\u81ea\u52d5\u66f4\u65b0\u3055\u308c\u306a\u3044\u305f\u3081\u3001\u5225\u9014\u4fee\u6b63\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250912\/20250912112600.png\" width=\"711\" height=\"275\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u305d\u308c\u305e\u308c\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u7528\u9014\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<div class=\"s_table\"><table>\n<thead>\n<tr>\n<th> \u30d5\u30a1\u30a4\u30eb\u540d <\/th>\n<th> \u5f79\u5272 \/ \u7528\u9014 <\/th>\n<th> \u4e3b\u306a\u5185\u5bb9 <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td> <strong>app.py<\/strong> <\/td>\n<td> \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u672c\u4f53\u306e\u30b3\u30fc\u30c9 <\/td>\n<td> Gradio \u306e UI \u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u5b9a\u7fa9\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u3092\u53d7\u3051\u53d6\u308a\u3001\u30e2\u30c7\u30eb\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u308a\u3001\u5fdc\u7b54\u3092\u8fd4\u3059\u51e6\u7406\u3092\u884c\u3046\u3002\u5bfe\u8a71\u5c65\u6b74\u306e\u7ba1\u7406\u3084\u88dc\u52a9\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u306e\u547c\u3073\u51fa\u3057\u3082\u542b\u307e\u308c\u308b\u3002 <\/td>\n<\/tr>\n<tr>\n<td> <strong>app.yaml<\/strong> <\/td>\n<td> \u5b9f\u884c\u74b0\u5883\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb <\/td>\n<td> Databricks Apps \u3067\u30a2\u30d7\u30ea\u3092\u3069\u306e\u3088\u3046\u306b\u5b9f\u884c\u3059\u308b\u304b\u3092\u5b9a\u7fa9\u3002\u4f8b\uff1a<code>command<\/code>\uff08\u5b9f\u884c\u30b3\u30de\u30f3\u30c9\uff09\u3001<code>env<\/code>\uff08\u74b0\u5883\u5909\u6570\uff09\u3001\u30ea\u30bd\u30fc\u30b9\u3084\u6a29\u9650\u306e\u8a2d\u5b9a\u306a\u3069\u3002 <\/td>\n<\/tr>\n<tr>\n<td> <strong>model_serving_utils.py<\/strong> <\/td>\n<td> \u30e2\u30c7\u30eb\u547c\u3073\u51fa\u3057\u7528\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3 <\/td>\n<td> Databricks \u306e\u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\uff08\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\uff09\u3068\u3084\u308a\u53d6\u308a\u3059\u308b\u95a2\u6570\u3092\u307e\u3068\u3081\u305f\u88dc\u52a9\u30e2\u30b8\u30e5\u30fc\u30eb\u3002\u5165\u529b\u30c7\u30fc\u30bf\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u5909\u63db\u3001\u30ea\u30af\u30a8\u30b9\u30c8\u9001\u4fe1\u3001\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3001\u5fdc\u7b54\u306e\u51e6\u7406\u306a\u3069\u3092\u62c5\u5f53\u3002 <\/td>\n<\/tr>\n<tr>\n<td> <strong>requirements.txt<\/strong> <\/td>\n<td> \u30d1\u30c3\u30b1\u30fc\u30b8\u4f9d\u5b58\u95a2\u4fc2\u306e\u5b9a\u7fa9 <\/td>\n<td> \u30a2\u30d7\u30ea\u306b\u5fc5\u8981\u306a Python \u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u6307\u5b9a\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u3002\u4f8b\uff1a<code>gradio<\/code>, <code>requests<\/code>, <code>transformers<\/code> \u306a\u3069\u3002\u30a2\u30d7\u30ea\u5b9f\u884c\u6642\u3084\u30c7\u30d7\u30ed\u30a4\u6642\u306b\u3053\u306e\u30ea\u30b9\u30c8\u3092\u3082\u3068\u306b\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u3002 <\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>\u305d\u308c\u305e\u308c\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<p><strong>&#8211; requirements.txt<\/strong><\/p>\n<p>\u4eca\u56de\u306e\u691c\u8a3c\u3067\u306fVector DB\u3068\u3057\u3066ChromaDB\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001\u8a72\u5f53\u30e9\u30a4\u30d6\u30e9\u30ea\u3092requirements.txt\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u52a0\u3057\u3066Install\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"code txt\" data-lang=\"txt\" data-unlink=\"\">gradio==5.23.3\nmlflow&gt;=2.21.2\ndatabricks-sdk\nchromadb<\/pre>\n<p><strong>&#8211; app.yaml<\/strong><\/p>\n<p>Apps\u306b\u767b\u9332\u3057\u305f\u30ea\u30bd\u30fc\u30b9\u3092\u74b0\u5883\u5909\u6570\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002valueFrom\u306fApps\u8a2d\u5b9a\u3067\u767b\u9332\u3057\u305f\u30ea\u30bd\u30fc\u30b9\u30ad\u30fc\u3068\u4e00\u81f4\u3055\u305b\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-yaml\" data-lang=\"yaml\" data-unlink=\"\"><span class=\"synIdentifier\">command<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synSpecial\">[<\/span>\n  <span class=\"synConstant\">\"python\"<\/span>,\n  <span class=\"synConstant\">\"app.py\"<\/span>\n<span class=\"synSpecial\">]<\/span>\n\n<span class=\"synIdentifier\">env<\/span><span class=\"synSpecial\">:<\/span>\n  <span class=\"synStatement\">- <\/span><span class=\"synIdentifier\">name<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"SERVING_ENDPOINT_LLM\"<\/span>\n    <span class=\"synIdentifier\">valueFrom<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"llm\"<\/span>\n  <span class=\"synStatement\">- <\/span><span class=\"synIdentifier\">name<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"SERVING_ENDPOINT_EMB\"<\/span>\n    <span class=\"synIdentifier\">valueFrom<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"embedding\"<\/span>\n  <span class=\"synStatement\">- <\/span><span class=\"synIdentifier\">name<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"DATABRICKS_WAREHOUSE_ID\"<\/span>\n    <span class=\"synIdentifier\">valueFrom<\/span><span class=\"synSpecial\">:<\/span> <span class=\"synConstant\">\"sql-warehouse\"<\/span>\n<\/pre>\n<p><strong>&#8211; model_serving_utils.py<\/strong><\/p>\n<p>Databricks\u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u547c\u3073\u51fa\u3057\u307e\u3059\u3002query_endpoint\u95a2\u6570\u306fDatabricks Apps\u306e\u521d\u671fInstall\u6642\u306b\u81ea\u52d5\u7684\u306b\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002LLM\u30e2\u30c7\u30eb\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3068\u9023\u643a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synPreProc\">from<\/span> mlflow.deployments <span class=\"synPreProc\">import<\/span> get_deploy_client\n<span class=\"synPreProc\">from<\/span> databricks.sdk <span class=\"synPreProc\">import<\/span> WorkspaceClient\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">_get_endpoint_task_type<\/span>(endpoint_name: <span class=\"synIdentifier\">str<\/span>) -&gt; <span class=\"synIdentifier\">str<\/span>:\n    <span class=\"synConstant\">\"\"\"Get the task type of a serving endpoint.\"\"\"<\/span>\n    w = WorkspaceClient()\n    ep = w.serving_endpoints.get(endpoint_name)\n    <span class=\"synStatement\">return<\/span> ep.task\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">is_endpoint_supported<\/span>(endpoint_name: <span class=\"synIdentifier\">str<\/span>) -&gt; <span class=\"synIdentifier\">bool<\/span>:\n    <span class=\"synConstant\">\"\"\"Check if the endpoint has a supported task type.\"\"\"<\/span>\n    task_type = _get_endpoint_task_type(endpoint_name)\n    supported_task_types = [<span class=\"synConstant\">\"agent\/v1\/chat\"<\/span>, <span class=\"synConstant\">\"agent\/v2\/chat\"<\/span>, <span class=\"synConstant\">\"llm\/v1\/chat\"<\/span>]\n    <span class=\"synStatement\">return<\/span> task_type <span class=\"synStatement\">in<\/span> supported_task_types\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">_validate_endpoint_task_type<\/span>(endpoint_name: <span class=\"synIdentifier\">str<\/span>) -&gt; <span class=\"synIdentifier\">None<\/span>:\n    <span class=\"synConstant\">\"\"\"Validate that the endpoint has a supported task type.\"\"\"<\/span>\n    <span class=\"synStatement\">if<\/span> <span class=\"synStatement\">not<\/span> is_endpoint_supported(endpoint_name):\n        <span class=\"synStatement\">raise<\/span> <span class=\"synType\">Exception<\/span>(\n            f<span class=\"synConstant\">\"Detected unsupported endpoint type for this basic chatbot template. \"<\/span>\n            f<span class=\"synConstant\">\"This chatbot template only supports chat completions-compatible endpoints. \"<\/span>\n            f<span class=\"synConstant\">\"For a richer chatbot template with support for all conversational endpoints on Databricks, \"<\/span>\n            f<span class=\"synConstant\">\"see https:\/\/docs.databricks.com\/aws\/en\/generative-ai\/agent-framework\/chat-app\"<\/span>\n        )\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">_query_endpoint<\/span>(endpoint_name: <span class=\"synIdentifier\">str<\/span>, messages: <span class=\"synIdentifier\">list<\/span>[<span class=\"synIdentifier\">dict<\/span>[<span class=\"synIdentifier\">str<\/span>, <span class=\"synIdentifier\">str<\/span>]], max_tokens) -&gt; <span class=\"synIdentifier\">list<\/span>[<span class=\"synIdentifier\">dict<\/span>[<span class=\"synIdentifier\">str<\/span>, <span class=\"synIdentifier\">str<\/span>]]:\n    <span class=\"synConstant\">\"\"\"Calls a model serving endpoint.\"\"\"<\/span>\n    _validate_endpoint_task_type(endpoint_name)\n    \n    res = get_deploy_client(<span class=\"synConstant\">'databricks'<\/span>).predict(\n        endpoint=endpoint_name,\n        inputs={<span class=\"synConstant\">'messages'<\/span>: messages, <span class=\"synConstant\">\"max_tokens\"<\/span>: max_tokens},\n    )\n    <span class=\"synStatement\">if<\/span> <span class=\"synConstant\">\"messages\"<\/span> <span class=\"synStatement\">in<\/span> res:\n        <span class=\"synStatement\">return<\/span> res[<span class=\"synConstant\">\"messages\"<\/span>]\n    <span class=\"synStatement\">elif<\/span> <span class=\"synConstant\">\"choices\"<\/span> <span class=\"synStatement\">in<\/span> res:\n        <span class=\"synStatement\">return<\/span> [res[<span class=\"synConstant\">\"choices\"<\/span>][<span class=\"synConstant\">0<\/span>][<span class=\"synConstant\">\"message\"<\/span>]]\n    <span class=\"synStatement\">raise<\/span> <span class=\"synType\">Exception<\/span>(<span class=\"synConstant\">\"This app can only run against:\"<\/span>\n                    <span class=\"synConstant\">\"1) Databricks foundation model or external model endpoints with the chat task type (described in https:\/\/docs.databricks.com\/aws\/en\/machine-learning\/model-serving\/score-foundation-models#chat-completion-model-query)\"<\/span>\n                    <span class=\"synConstant\">\"2) Databricks agent serving endpoints that implement the conversational agent schema documented \"<\/span>\n                    <span class=\"synConstant\">\"in https:\/\/docs.databricks.com\/aws\/en\/generative-ai\/agent-framework\/author-agent\"<\/span>)\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">query_endpoint<\/span>(endpoint_name, messages, max_tokens):\n    <span class=\"synStatement\">return<\/span> _query_endpoint(endpoint_name, messages, max_tokens)[-<span class=\"synConstant\">1<\/span>]\n<\/pre>\n<p>query_embedding\u95a2\u6570\u306f\u3001\u30d9\u30af\u30bf\u30fc\u691c\u7d22\u3092\u884c\u3046\u305f\u3081\u306b\u8ffd\u52a0\u3067\u4f5c\u6210\u3057\u305f\u95a2\u6570\u3067\u3059\u3002embedding\u30e2\u30c7\u30eb\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3068\u9023\u643a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">query_embedding<\/span>(endpoint_name: <span class=\"synIdentifier\">str<\/span>, message: <span class=\"synIdentifier\">str<\/span>) -&gt; <span class=\"synIdentifier\">list<\/span>[<span class=\"synIdentifier\">float<\/span>]:\n    <span class=\"synConstant\">\"\"\"Calls an embedding model serving endpoint.\"\"\"<\/span>\n    res = get_deploy_client(<span class=\"synConstant\">'databricks'<\/span>).predict(\n        endpoint=endpoint_name,\n        inputs={<span class=\"synConstant\">\"input\"<\/span>: message},\n    )\n    <span class=\"synStatement\">if<\/span> <span class=\"synConstant\">\"data\"<\/span> <span class=\"synStatement\">in<\/span> res <span class=\"synStatement\">and<\/span> <span class=\"synConstant\">\"embedding\"<\/span> <span class=\"synStatement\">in<\/span> res[<span class=\"synConstant\">\"data\"<\/span>][<span class=\"synConstant\">0<\/span>]:\n        <span class=\"synStatement\">return<\/span> res[<span class=\"synConstant\">\"data\"<\/span>][<span class=\"synConstant\">0<\/span>][<span class=\"synConstant\">\"embedding\"<\/span>]\n    <span class=\"synStatement\">raise<\/span> <span class=\"synType\">Exception<\/span>(<span class=\"synConstant\">\"This app can only run against Databricks embedding model endpoints\"<\/span>)\n<\/pre>\n<p><strong>&#8211; app.py<\/strong><\/p>\n<p>Chatbot\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u307e\u305a\u3001Gradio\u3001Pandas\u3001DatabricksSDK\u306a\u3069\u5fc5\u8981\u306a\u5916\u90e8\u30e9\u30a4\u30d6\u30e9\u30ea\u3068\u3001model_serving_utils\u306e\u3088\u3046\u306a\u5185\u90e8\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<br \/>\n\u6b21\u306b\u3001\u30a2\u30d7\u30ea\u5b9f\u884c\u306b\u5fc5\u9808\u3068\u306a\u308b\u74b0\u5883\u5909\u6570\uff08DATABRICKS_WAREHOUSE_ID\u3001SERVING_ENDPOINT_EMB\uff09\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3057\u3001\u672a\u8a2d\u5b9a\u306e\u5834\u5408\u306f\u5b9f\u884c\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synPreProc\">import<\/span> gradio <span class=\"synStatement\">as<\/span> gr\n<span class=\"synPreProc\">import<\/span> logging\n<span class=\"synPreProc\">import<\/span> os\n<span class=\"synPreProc\">from<\/span> model_serving_utils <span class=\"synPreProc\">import<\/span> query_endpoint, is_endpoint_supported, query_embedding\n<span class=\"synPreProc\">import<\/span> chromadb\n<span class=\"synPreProc\">import<\/span> pandas <span class=\"synStatement\">as<\/span> pd\n<span class=\"synPreProc\">from<\/span> databricks <span class=\"synPreProc\">import<\/span> sql\n<span class=\"synPreProc\">from<\/span> databricks.sdk.core <span class=\"synPreProc\">import<\/span> Config\n\n\n<span class=\"synStatement\">assert<\/span> os.getenv(<span class=\"synConstant\">'DATABRICKS_WAREHOUSE_ID'<\/span>), <span class=\"synConstant\">\"DATABRICKS_WAREHOUSE_ID must be set in app.yaml.\"<\/span>\n<span class=\"synStatement\">assert<\/span> os.getenv(<span class=\"synConstant\">'SERVING_ENDPOINT_EMB'<\/span>), <span class=\"synConstant\">\"SERVING_ENDPOINT_EMB must be set in app.yaml.\"<\/span>\n<\/pre>\n<p>\u30ed\u30ae\u30f3\u30b0\u3092\u6709\u52b9\u5316\u3057\u307e\u3059\u3002\u305d\u3057\u3066Databricks SQL Warehouse\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306esqlQuery\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002<br \/>\n\u3053\u306e\u95a2\u6570\u306f\u5165\u529b\u3055\u308c\u305fSQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3001\u305d\u306e\u7d50\u679c\u3092Pandas DataFrame\u3068\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002<br \/>\n\u305d\u306e\u5f8c\u3001\u74b0\u5883\u5909\u6570 UC_TABLE\u306b\u6307\u5b9a\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\uff08apps_data.dbx_doc.databricks_doc\uff09\u3092\u53c2\u7167\u3057\u3001\u30c7\u30fc\u30bf\u306e\u5f62\u72b6\u3068\u30ab\u30e9\u30e0\u60c5\u5831\u3092\u51fa\u529b\u3057\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002<br \/>\n\u30af\u30a8\u30ea\u5b9f\u884c\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f\u4f8b\u5916\u3092\u51fa\u529b\u3057\u3001\u7a7a\u306eDataFrame\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\">\nlogging.basicConfig(level=logging.INFO)\nlogger = logging.getLogger(__name__)\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">sqlQuery<\/span>(query: <span class=\"synIdentifier\">str<\/span>) -&gt; pd.DataFrame:\n    <span class=\"synConstant\">\"\"\"Execute a SQL query and return the result as a pandas DataFrame.\"\"\"<\/span>\n    cfg = Config()  \n    <span class=\"synStatement\">with<\/span> sql.connect(\n        server_hostname=cfg.host,\n        http_path=f<span class=\"synConstant\">\"\/sql\/1.0\/warehouses\/{os.getenv('DATABRICKS_WAREHOUSE_ID')}\"<\/span>,\n        credentials_provider=<span class=\"synStatement\">lambda<\/span>: cfg.authenticate\n    ) <span class=\"synStatement\">as<\/span> connection:\n        <span class=\"synStatement\">with<\/span> connection.cursor() <span class=\"synStatement\">as<\/span> cursor:\n            cursor.execute(query)\n            <span class=\"synStatement\">return<\/span> cursor.fetchall_arrow().to_pandas()\n\n\nUC_TABLE = os.getenv(<span class=\"synConstant\">\"UC_TABLE\"<\/span>, <span class=\"synConstant\">\"apps_data.dbx_doc.databricks_doc\"<\/span>)\n<span class=\"synStatement\">try<\/span>:\n    \n    data = sqlQuery(f<span class=\"synConstant\">\"SELECT * FROM {UC_TABLE}\"<\/span>)\n    <span class=\"synIdentifier\">print<\/span>(f<span class=\"synConstant\">\"Data shape: {data.shape}\"<\/span>)\n    <span class=\"synIdentifier\">print<\/span>(f<span class=\"synConstant\">\"Data columns: {data.columns}\"<\/span>)\n<span class=\"synStatement\">except<\/span> <span class=\"synType\">Exception<\/span> <span class=\"synStatement\">as<\/span> e:\n    <span class=\"synIdentifier\">print<\/span>(f<span class=\"synConstant\">\"An error occurred in querying data: {str(e)}\"<\/span>)\n    data = pd.DataFrame()\n<\/pre>\n<p>In-memory\u306eChromaDB\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u3001\u300crag_docs\u300d\u3068\u3044\u3046\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u6e96\u5099\u3057\u307e\u3059\u3002<br \/>\nDatabricks SQL\u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u304b\u3089\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8ID\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\uff08URL\uff09\u3001\u672c\u6587\u30c6\u30ad\u30b9\u30c8\u3001\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u3092\u62bd\u51fa\u3057\u3001ChromaDB\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<br \/>\n\u3053\u308c\u306b\u3088\u308a\u3001\u5f8c\u7d9a\u306e\u30af\u30a8\u30ea\u6642\u306b\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u985e\u4f3c\u5ea6\u306b\u57fa\u3065\u3044\u3066\u95a2\u9023\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u691c\u7d22\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\">\nchroma_client = chromadb.Client()\ncollection = chroma_client.get_or_create_collection(name=<span class=\"synConstant\">\"rag_docs\"<\/span>)\n\nids = data[<span class=\"synConstant\">\"id\"<\/span>].astype(<span class=\"synIdentifier\">str<\/span>).tolist()\nurls = data[<span class=\"synConstant\">\"url\"<\/span>].tolist()\ndocs = data[<span class=\"synConstant\">\"content\"<\/span>].tolist()\nembs = data[<span class=\"synConstant\">\"embedding\"<\/span>].tolist() \n\ncollection.add(\n    ids=ids,\n    documents=docs,\n    embeddings=embs,\n    metadatas=[{<span class=\"synConstant\">\"url\"<\/span>: u} <span class=\"synStatement\">for<\/span> u <span class=\"synStatement\">in<\/span> urls]\n)\n<\/pre>\n<p>LLM\u3068Embedding\u30e2\u30c7\u30eb\u306e\u74b0\u5883\u5909\u6570\u3092\u8aad\u307f\u8fbc\u307f\u3001LLM\u30e2\u30c7\u30eb\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304cChat\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\">\nSERVING_ENDPOINT_LLM = os.getenv(<span class=\"synConstant\">'SERVING_ENDPOINT_LLM'<\/span>)\n<span class=\"synStatement\">assert<\/span> SERVING_ENDPOINT_LLM,<span class=\"synSpecial\">\\<\/span>\n    (<span class=\"synConstant\">\"Unable to determine serving endpoint to use for chatbot app. If developing locally, \"<\/span>\n     <span class=\"synConstant\">\"set the SERVING_ENDPOINT_LLM environment variable to the name of your serving endpoint. If \"<\/span>\n     <span class=\"synConstant\">\"deploying to a Databricks app, include a serving endpoint resource named \"<\/span>\n     <span class=\"synConstant\">\"'llm' with CAN_QUERY permissions, as described in \"<\/span>\n     <span class=\"synConstant\">\"https:\/\/docs.databricks.com\/aws\/en\/generative-ai\/agent-framework\/chat-app#deploy-the-databricks-app\"<\/span>)\n\nendpoint_supported_llm = is_endpoint_supported(SERVING_ENDPOINT_LLM)\nSERVING_ENDPOINT_EMB = os.getenv(<span class=\"synConstant\">'SERVING_ENDPOINT_EMB'<\/span>)\n<\/pre>\n<p>query_rag\u95a2\u6570\u306f\u30e6\u30fc\u30b6\u30fc\u306e\u8cea\u554f\u3092\u53d7\u3051\u53d6\u308a\u3001RAG\uff08Retrieval-Augmented Generation\uff09\u65b9\u5f0f\u3067\u51e6\u7406\u3057\u307e\u3059\u3002<br \/>\n\u307e\u305a\u8cea\u554f\u3092\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u30d9\u30af\u30c8\u30eb\u306b\u5909\u63db\u3057\u3001ChromaDB\u3067\u985e\u4f3c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u691c\u7d22\u3057\u3066\u95a2\u9023\u3059\u308b\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u3053\u306e\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u3068\u65e2\u5b58\u306e\u4f1a\u8a71\u5c65\u6b74\u3092\u7d44\u307f\u5408\u308f\u305b\u3066Databricks LLM\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306b\u6e21\u3057\u3001\u30e2\u30c7\u30eb\u304c\u751f\u6210\u3057\u305f\u56de\u7b54\u3092\u8fd4\u3057\u307e\u3059\u3002<br \/>\n\u3053\u306e\u904e\u7a0b\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306f\u3001\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">query_rag<\/span>(message, history):\n    <span class=\"synStatement\">if<\/span> <span class=\"synStatement\">not<\/span> message.strip():\n        <span class=\"synStatement\">return<\/span> <span class=\"synConstant\">\"ERROR: The question should not be empty\"<\/span>\n\n    query_vector = query_embedding(SERVING_ENDPOINT_EMB, message)\n    results = collection.query(query_embeddings=[query_vector], n_results=<span class=\"synConstant\">3<\/span>)\n\n    context = <span class=\"synConstant\">\"<\/span><span class=\"synSpecial\">\\n<\/span><span class=\"synConstant\">\"<\/span>.join([\n        f<span class=\"synConstant\">\"- {doc} (Sources: {meta['url']})\"<\/span>\n        <span class=\"synStatement\">for<\/span> doc, meta <span class=\"synStatement\">in<\/span> <span class=\"synIdentifier\">zip<\/span>(results[<span class=\"synConstant\">\"documents\"<\/span>][<span class=\"synConstant\">0<\/span>], results[<span class=\"synConstant\">\"metadatas\"<\/span>][<span class=\"synConstant\">0<\/span>])\n    ])\n\n    message_history = []\n    <span class=\"synStatement\">for<\/span> user_msg, assistant_msg <span class=\"synStatement\">in<\/span> history:\n        message_history.append({<span class=\"synConstant\">\"role\"<\/span>: <span class=\"synConstant\">\"user\"<\/span>, <span class=\"synConstant\">\"content\"<\/span>: user_msg})\n        message_history.append({<span class=\"synConstant\">\"role\"<\/span>: <span class=\"synConstant\">\"assistant\"<\/span>, <span class=\"synConstant\">\"content\"<\/span>: assistant_msg})\n\n    message_history.append({\n        <span class=\"synConstant\">\"role\"<\/span>: <span class=\"synConstant\">\"user\"<\/span>,\n        <span class=\"synConstant\">\"content\"<\/span>: f<span class=\"synConstant\">\"Answer the following question using the context.<\/span><span class=\"synSpecial\">\\n\\n<\/span><span class=\"synConstant\">Context:<\/span><span class=\"synSpecial\">\\n<\/span><span class=\"synConstant\">{context}<\/span><span class=\"synSpecial\">\\n\\n<\/span><span class=\"synConstant\">Question: {message}\"<\/span>\n    })\n\n    <span class=\"synStatement\">try<\/span>:\n        logger.info(f<span class=\"synConstant\">\"Sending request to model endpoint: {SERVING_ENDPOINT_LLM}\"<\/span>)\n        response = query_endpoint(\n            endpoint_name=SERVING_ENDPOINT_LLM,\n            messages=message_history,\n            max_tokens=<span class=\"synConstant\">400<\/span>\n        )\n        \n        <span class=\"synIdentifier\">print<\/span>(message_history)\n        <span class=\"synIdentifier\">print<\/span>(response)\n        <span class=\"synStatement\">return<\/span> response[<span class=\"synConstant\">\"content\"<\/span>][-<span class=\"synConstant\">1<\/span>][<span class=\"synConstant\">\"text\"<\/span>]\n    <span class=\"synStatement\">except<\/span> <span class=\"synType\">Exception<\/span> <span class=\"synStatement\">as<\/span> e:\n        logger.error(f<span class=\"synConstant\">\"Error querying model: {str(e)}\"<\/span>, exc_info=<span class=\"synIdentifier\">True<\/span>)\n        <span class=\"synStatement\">return<\/span> f<span class=\"synConstant\">\"Error: {str(e)}\"<\/span>\n<\/pre>\n<p>Gradio\u3092\u5229\u7528\u3057\u3066Databricks LLM\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u306e\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u751f\u6210\u3057\u307e\u3059\u3002<br \/>\n\u3082\u3057\u6307\u5b9a\u3055\u308c\u305fLLM\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304c\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u306a\u3044\u30bf\u30a4\u30d7\u3067\u3042\u308c\u3070\u3001\u7c21\u6613UI\u3092\u8868\u793a\u3057\u3066\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304c\u4e92\u63db\u6027\u3092\u6301\u305f\u306a\u3044\u65e8\u306e\u6848\u5185\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u793a\u3057\u307e\u3059\u3002<br \/>\n\u6b63\u5e38\u306a\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3067\u3042\u308c\u3070\u3001query_rag\u95a2\u6570\u3092\u30d9\u30fc\u30b9\u306b\u5bfe\u8a71\u578b\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u69cb\u6210\u3057\u3001\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u306e\u30bf\u30a4\u30c8\u30eb\u30fb\u8aac\u660e\u30fb\u30b5\u30f3\u30d7\u30eb\u8cea\u554f\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<br \/>\n\u6700\u5f8c\u306bdemo.launch()\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u8d77\u52d5\u3057\u3001Web\u30d6\u30e9\u30a6\u30b6\u4e0a\u3067\u76f4\u63a5\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\">\n<span class=\"synStatement\">if<\/span> <span class=\"synStatement\">not<\/span> endpoint_supported_llm:\n    \n    <span class=\"synStatement\">with<\/span> gr.Blocks() <span class=\"synStatement\">as<\/span> demo:\n        gr.Markdown(<span class=\"synConstant\">\"# Databricks LLM Chatbot\"<\/span>)\n        gr.Markdown(\n            f<span class=\"synConstant\">\"\"\"<\/span>\n<span class=\"synConstant\">            \u26a0\ufe0f **Unsupported Endpoint Type**<\/span>\n<span class=\"synConstant\">            <\/span>\n<span class=\"synConstant\">            The endpoint `{SERVING_ENDPOINT_LLM}` is not compatible with this basic chatbot template.<\/span>\n<span class=\"synConstant\">            <\/span>\n<span class=\"synConstant\">            This template only supports chat completions-compatible endpoints.<\/span>\n<span class=\"synConstant\">            <\/span>\n<span class=\"synConstant\">            \ud83d\udc49 **For a richer chatbot template** that supports all conversational endpoints on Databricks, <\/span>\n<span class=\"synConstant\">            please see the [Databricks documentation](https:\/\/docs.databricks.com\/aws\/en\/generative-ai\/agent-framework\/chat-app).<\/span>\n<span class=\"synConstant\">            \"\"\"<\/span>\n        )\n<span class=\"synStatement\">else<\/span>:\n    demo = gr.ChatInterface(\n        fn=query_rag,\n        title=<span class=\"synConstant\">\"Databricks LLM Chatbot\"<\/span>,\n        description=(\n            <span class=\"synConstant\">\"Note: this is a simple example. See \"<\/span>\n            <span class=\"synConstant\">\"[Databricks docs](https:\/\/docs.databricks.com\/aws\/en\/generative-ai\/agent-framework\/chat-app) \"<\/span>\n            <span class=\"synConstant\">\"for a more comprehensive example, with support for streaming output and more.\"<\/span>\n        ),\n        examples=[\n            <span class=\"synConstant\">\"What is machine learning?\"<\/span>,\n            <span class=\"synConstant\">\"What are Large Language Models?\"<\/span>,\n            <span class=\"synConstant\">\"What is Databricks?\"<\/span>\n        ],\n    )\n\n<span class=\"synStatement\">if<\/span> __name__ == <span class=\"synConstant\">\"__main__\"<\/span>:\n    demo.launch()\n<\/pre>\n<h3 id=\"Chatbot\u5b9f\u884c\"><strong>Chatbot\u5b9f\u884c<\/strong><\/h3>\n<p>\u30d5\u30a1\u30a4\u30eb\u306e\u6e96\u5099\u304c\u5b8c\u4e86\u3057\u305f\u3089\u300cDeploy\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066Apps\u3092\u30c7\u30d7\u30ed\u30a4\u3057\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250916\/20250916151127.png\" width=\"905\" height=\"643\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u3082\u3057\u30c7\u30d7\u30ed\u30a4\u4e2d\u306b\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306f\u3001\u305d\u306e\u30ed\u30b0\u3092\u300cLogs\u300d\u3067\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250916\/20250916151354.png\" width=\"926\" height=\"777\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u30c7\u30d7\u30ed\u30a4\u304c\u5b8c\u4e86\u3059\u308b\u3068\u3001\u4e0b\u306e\u753b\u50cf\u306b\u3042\u308b\u90e8\u5206\u304cUnavailable\u304b\u3089Running\u306b\u5909\u308f\u308a\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250916\/20250916151543.png\" width=\"910\" height=\"212\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>Running\u306b\u3042\u308bURL\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u304c\u958b\u304d\u307e\u3059\u3002<\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/j\/jungsua\/20250916\/20250916151726.png\" width=\"753\" height=\"929\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<h3 id=\"\u307e\u3068\u3081\"><strong> \u307e\u3068\u3081<\/strong><\/h3>\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306fDatabricks Free Edition\u3067Apps\u6a5f\u80fd\u3092\u6d3b\u7528\u3057\u3001\u7c21\u5358\u306aRAG Chatbot\u3092\u5b9f\u88c5\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\n\u4eca\u56de\u306e\u691c\u8a3c\u3067\u306f\u3001Databricks\u306b\u5185\u8535\u3055\u308c\u305f\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3057\u305f\u304c\u3001\u4efb\u610f\u306e\u30e2\u30c7\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u30b5\u30fc\u30d3\u30f3\u30b0\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306b\u767b\u9332\u3059\u308c\u3070\u3001\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u305d\u3057\u3066\u3001Gradio\u306eUI\u3092\u81ea\u7531\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u5206\u3060\u3051\u306e\u30ab\u30b9\u30bf\u30e0\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<br \/>\n\u6700\u5f8c\u307e\u3067\u304a\u8aad\u307f\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002<\/p>\n<p>\u203b\u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\u767b\u9332\u306b\u95a2\u3059\u308b\u8a18\u4e8b\u306f\u4ee5\u4e0b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Ftechblog.ap-com.co.jp%2Fentry%2F2024%2F06%2F11%2F183446\" title=\"Databricks \u30e2\u30c7\u30eb\u30b5\u30fc\u30d3\u30f3\u30b0\u306b\u30a8\u30f3\u30d9\u30c7\u30a3\u30f3\u30b0\u30e2\u30c7\u30eb\u3092\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3059\u308b - APC \u6280\u8853\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/techblog.ap-com.co.jp\/entry\/2024\/06\/11\/183446\">techblog.ap-com.co.jp<\/a><\/cite><\/p>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/K\/Kazumain\/20230801\/20230801142404.png\" width=\"1200\" height=\"556\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<p>\u79c1\u305f\u3061\u306fDatabricks\u3092\u7528\u3044\u305f\u30c7\u30fc\u30bf\u5206\u6790\u57fa\u76e4\u306e\u5c0e\u5165\u304b\u3089\u5185\u88fd\u5316\u652f\u63f4\u307e\u3067\u5e45\u5e83\u304f\u652f\u63f4\u3092\u3057\u3066\u304a\u308a\u307e\u3059\u3002<br \/>\u3082\u3057\u3054\u8208\u5473\u304c\u3042\u308b\u65b9\u306f\u3001\u304a\u554f\u3044\u5408\u308f\u305b\u9802\u3051\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fwww.ap-com.co.jp%2Fservice%2Fdata_ai%2F\" title=\"\u30c7\u30fc\u30bf&amp;AI\u5206\u6790\u57fa\u76e4\u306e\u652f\u63f4\u30b5\u30fc\u30d3\u30b9 with Databricks | \u30b5\u30fc\u30d3\u30b9 | \u682a\u5f0f\u4f1a\u793e\u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30ba | AP Communications (APC)\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/www.ap-com.co.jp\/service\/data_ai\/\">www.ap-com.co.jp<\/a><\/cite><\/p>\n<p>\u307e\u305f\u3001\u4e00\u7dd2\u306b\u50cd\u3044\u3066\u3044\u305f\u3060\u3051\u308b\u4ef2\u9593\u3082\u52df\u96c6\u4e2d\u3067\u3059\uff01<br \/>APC\u306b\u3054\u8208\u5473\u304c\u3042\u308b\u65b9\u306e\u9023\u7d61\u3092\u304a\u5f85\u3061\u3057\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fwww.ap-com.co.jp%2Frecruit%2Finfo%2Frequirements.html%3Futm_source%3Dblog%26utm_medium%3Darticle_bottom%26utm_campaign%3Drecruit\" title=\"\u682a\u5f0f\u4f1a\u793e\u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30ba \u63a1\u7528\u60c5\u5831\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/www.ap-com.co.jp\/recruit\/info\/requirements.html?utm_source=blog&amp;utm_medium=article_bottom&amp;utm_campaign=recruit\">www.ap-com.co.jp<\/a><\/cite><\/p>\n<\/div>\n<p><script>(function(d, s, id) {\n  var js, fjs = d.getElementsByTagName(s)[0];\n  if (d.getElementById(id)) return;\n  js = d.createElement(s); js.id = id;\n  js.src = \"\/\/connect.facebook.net\/ja_JP\/sdk.js#xfbml=1&appId=719729204785177&version=v17.0\";\n  fjs.parentNode.insertBefore(js, fjs);\n}(document, 'script', 'facebook-jssdk'));<\/script><br \/>\n<br \/>\n<br \/><a href=\"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926\">\u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\u306f\u3058\u3081\u306b \u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30baGDAI\u4e8b\u696d\u90e8Lakehouse\u90e8\u306e\u912d(\u30b8\u30e7\u30f3)\u3067\u3059\u3002 \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Databricks\u306eFree Edition\u3092\u5229\u7528\u3057\u3066RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u4eca\u56de [&hellip;]","protected":false},"author":1,"featured_media":6098,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6097","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-tec"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"og:description\" content=\"\u306f\u3058\u3081\u306b \u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30baGDAI\u4e8b\u696d\u90e8Lakehouse\u90e8\u306e\u912d(\u30b8\u30e7\u30f3)\u3067\u3059\u3002 \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Databricks\u306eFree Edition\u3092\u5229\u7528\u3057\u3066RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u4eca\u56de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926\" \/>\n<meta property=\"og:site_name\" content=\"\u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-19T07:07:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"info@pokecon.jp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"info@pokecon.jp\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/6097\\\/\"},\"author\":{\"name\":\"info@pokecon.jp\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"headline\":\"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! &#8211; APC \u6280\u8853\u30d6\u30ed\u30b0\",\"datePublished\":\"2025-09-19T07:07:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/6097\\\/\"},\"wordCount\":232,\"image\":{\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg\",\"articleSection\":[\"\u4f01\u696d\u30c6\u30c3\u30af\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/6097\\\/\",\"url\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926\",\"name\":\"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg\",\"datePublished\":\"2025-09-19T07:07:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#primaryimage\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg\",\"contentUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg\",\"width\":1300,\"height\":683},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/techblog.ap-com.co.jp\\\/entry\\\/2025\\\/09\\\/19\\\/153926#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! &#8211; APC \u6280\u8853\u30d6\u30ed\u30b0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\",\"name\":\"\u30dd\u30b1\u30b3\u30f3\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\",\"name\":\"info@pokecon.jp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"caption\":\"info@pokecon.jp\"},\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/author\\\/infopokecon-jp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926","og_locale":"ja_JP","og_type":"article","og_title":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3","og_description":"\u306f\u3058\u3081\u306b \u30a8\u30fc\u30d4\u30fc\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30baGDAI\u4e8b\u696d\u90e8Lakehouse\u90e8\u306e\u912d(\u30b8\u30e7\u30f3)\u3067\u3059\u3002 \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Databricks\u306eFree Edition\u3092\u5229\u7528\u3057\u3066RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u4eca\u56de [&hellip;]","og_url":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926","og_site_name":"\u30dd\u30b1\u30b3\u30f3","article_published_time":"2025-09-19T07:07:22+00:00","og_image":[{"width":1300,"height":683,"url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg","type":"image\/jpeg"}],"author":"info@pokecon.jp","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"info@pokecon.jp","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"7\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#article","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/6097\/"},"author":{"name":"info@pokecon.jp","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"headline":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! &#8211; APC \u6280\u8853\u30d6\u30ed\u30b0","datePublished":"2025-09-19T07:07:22+00:00","mainEntityOfPage":{"@id":"https:\/\/pokecon.jp\/job\/6097\/"},"wordCount":232,"image":{"@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg","articleSection":["\u4f01\u696d\u30c6\u30c3\u30af"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/pokecon.jp\/job\/6097\/","url":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926","name":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! - APC \u6280\u8853\u30d6\u30ed\u30b0 - \u30dd\u30b1\u30b3\u30f3","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/#website"},"primaryImageOfPage":{"@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#primaryimage"},"image":{"@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg","datePublished":"2025-09-19T07:07:22+00:00","author":{"@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"breadcrumb":{"@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#primaryimage","url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg","contentUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/09\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fj2Fjungsua2F202509162F20250916182823.j.jpeg","width":1300,"height":683},{"@type":"BreadcrumbList","@id":"https:\/\/techblog.ap-com.co.jp\/entry\/2025\/09\/19\/153926#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/pokecon.jp\/job\/"},{"@type":"ListItem","position":2,"name":"Databricks\u3067\u81ea\u5206\u306e\u7121\u6599RAG\u30c1\u30e3\u30c3\u30c8\u30dc\u30c3\u30c8\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046-! &#8211; APC \u6280\u8853\u30d6\u30ed\u30b0"}]},{"@type":"WebSite","@id":"https:\/\/pokecon.jp\/job\/#website","url":"https:\/\/pokecon.jp\/job\/","name":"\u30dd\u30b1\u30b3\u30f3","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pokecon.jp\/job\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997","name":"info@pokecon.jp","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","caption":"info@pokecon.jp"},"url":"https:\/\/pokecon.jp\/job\/author\/infopokecon-jp\/"}]}},"_links":{"self":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/6097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/comments?post=6097"}],"version-history":[{"count":1,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/6097\/revisions"}],"predecessor-version":[{"id":6099,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/6097\/revisions\/6099"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media\/6098"}],"wp:attachment":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media?parent=6097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/categories?post=6097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/tags?post=6097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}