{"id":15356,"date":"2026-10-14T11:38:43","date_gmt":"2026-10-14T02:38:43","guid":{"rendered":"https:\/\/debono.co.jp\/media\/ai-usecase\/sql-query-review\/"},"modified":"2026-10-14T11:38:43","modified_gmt":"2026-10-14T02:38:43","slug":"sql-query-review","status":"publish","type":"ai_usecase","link":"https:\/\/debono.co.jp\/media\/ai-usecase\/sql-query-review\/","title":{"rendered":"\u696d\u52d9\u90e8\u9580\u304c\u66f8\u3044\u305f\u30c7\u30fc\u30bf\u62bd\u51fa\u306eSQL\u3092\u3001\u793e\u5185\u306e\u547d\u540d\u898f\u7d04\u3068BigQuery\u306e\u6027\u80fd\u306e\u89b3\u70b9\u3067\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u7406\u7531\u3092\u8fd4\u3059"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"<p>\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u66f8\u3044\u305f\u30c7\u30fc\u30bf\u62bd\u51fa\u306eSQL\u3092\u3001\u793e\u5185\u306e\u547d\u540d\u898f\u7d04\u3068 BigQuery \u306e\u6027\u80fd\u306e\u89b3\u70b9\u3067\u70b9\u691c\u3057\u307e\u3059\u3002\u76f4\u3057\u305f\u7248\u306eSQL\u3068\u3001\u76f4\u3057\u305f\u7b87\u6240\u3054\u3068\u306e\u7406\u7531\u3092\u3001\u66f8\u3044\u305f\u672c\u4eba\u3068\u30c7\u30fc\u30bf\u62c5\u5f53\u306b\u8fd4\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":5,"featured_media":0,"template":"","meta":{"swell_btn_cv_data":"","usecase_id":"UC-1482","platform_main":"Claude","publish_date":"","last_updated":"2026-10-14","tech_verified_date":"2026-10-14","trigger":"**\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u8d77\u70b9\u306b\u3057\u307e\u3059\u3002** Google Apps Script \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\u306b\u306f\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u306e\u9001\u4fe1\u3067\u52d5\u304f\u3082\u306e\u304c\u3042\u308a\u307e\u3059\u3002**\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\u306f\u3001\u4f5c\u3063\u305f\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u52d5\u304d\u307e\u3059\u3002** \u500b\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u308b\u3068\u3001\u305d\u306e\u4eba\u304c\u7570\u52d5\u3057\u305f\u3068\u304d\u306b\u6b62\u307e\u308a\u3001BigQuery \u3078\u306e\u6a29\u9650\u3082\u305d\u306e\u4eba\u306e\u3082\u306e\u306b\u306a\u308a\u307e\u3059\u3002**\u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u306e\u5171\u6709\u306e\u4f5c\u696d\u7528\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u308a\u307e\u3059\u3002**\n\n1\u56de\u306e\u9001\u4fe1\u30671\u672c\u306eSQL\u3092\u70b9\u691c\u3057\u307e\u3059\u3002**\u8907\u6570\u306eSQL\u30921\u56de\u306e\u4f9d\u983c\u306b\u307e\u3068\u3081\u3055\u305b\u307e\u305b\u3093\u3002** \u307e\u3068\u3081\u308b\u3068\u3001\u3069\u306e\u76f4\u3057\u304c\u3069\u306eSQL\u306e\u3082\u306e\u304b\u5206\u304b\u3089\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u30d5\u30a9\u30fc\u30e0\u306e\u9805\u76ee\u306f\u3001SQL\u672c\u6587\u3001\u76ee\u7684\uff08\u4f55\u306b\u4f7f\u3046\u304b\uff09\u3001\u60f3\u5b9a\u3059\u308b\u671f\u9593\u3001\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u304b\u3069\u3046\u304b\u3001\u306e4\u3064\u3067\u3059\u3002\n\nApps Script \u306e1\u56de\u306e\u5b9f\u884c\u306f6\u5206\u307e\u3067\u3067\u3059\u3002**\u70b9\u691c\u3068\u7a81\u304d\u5408\u308f\u305b\u304c6\u5206\u306b\u53ce\u307e\u3089\u306a\u3044SQL\u306f\u3001\u7a81\u304d\u5408\u308f\u305b\u3092\u5f8c\u56de\u3057\u306e\u5b9f\u884c\u306b\u5206\u3051\u307e\u3059\u3002** \u4e00\u89a7\u306b\u300c\u7a81\u304d\u5408\u308f\u305b\u5f85\u3061\u300d\u3068\u66f8\u304d\u3001\u6642\u9593\u4e3b\u5c0e\u578b\u306e\u30c8\u30ea\u30ac\u30fc\u3067\u7d9a\u304d\u3092\u52d5\u304b\u3057\u307e\u3059\u3002","input_data":"| \u30c7\u30fc\u30bf | \u4e2d\u8eab | \u53d6\u5f97\u5143 |\n|:--|:--|:--|\n| SQL\u672c\u6587 | \u4f9d\u983c\u8005\u304c\u66f8\u3044\u305fSELECT\u6587 | \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 |\n| \u76ee\u7684\u3068\u671f\u9593 | \u4f55\u306b\u4f7f\u3046\u304b\u3001\u3069\u306e\u671f\u9593\u306e\u30c7\u30fc\u30bf\u304b\u3001\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u304b | \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 |\n| \u8868\u306e\u60c5\u5831 | \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u5217\u306e\u540d\u524d\u3068\u578b\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3001\u30af\u30e9\u30b9\u30bf\u306e\u5217\u306e\u9806 | BigQuery \u306e `INFORMATION_SCHEMA.COLUMNS` |\n| \u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c | \u69cb\u6587\u306e\u8aa4\u308a\u306e\u6709\u7121\u3001\u51e6\u7406\u3055\u308c\u308b\u91cf | BigQuery \u306e\u30c9\u30e9\u30a4\u30e9\u30f3 |\n| \u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7 | \u547d\u540d\u898f\u7d04\uff08N-01\u301c\uff09\u3068\u6027\u80fd\u306e\u89b3\u70b9\uff08P-01\u301c\uff09\u306e\u756a\u53f7\u4ed8\u304d\u306e\u9805\u76ee | \u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u304c\u4f5c\u308b\u6587\u66f8 |\n\n**\u8cea\u3092\u6c7a\u3081\u308b\u306e\u306f\u30013\u884c\u76ee\u30685\u884c\u76ee\u3067\u3059\u3002** \u8868\u306e\u60c5\u5831\u304c\u7121\u3044\u3068\u3001AI\u306f\u3069\u306e\u5217\u304c\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u304b\u3092\u63a8\u6e2c\u3057\u3001**\u5b9f\u5728\u3057\u306a\u3044\u5217\u306e\u540d\u524d\u3067\u6761\u4ef6\u3092\u66f8\u304d\u307e\u3059\u3002** \u89b3\u70b9\u306e\u4e00\u89a7\u304c\u7121\u3044\u3068\u3001AI\u306f\u4e00\u822c\u7684\u306aSQL\u306e\u66f8\u304d\u65b9\u3067\u76f4\u3057\u3001**\u793e\u5185\u306e\u6c7a\u307e\u308a\u3068\u9055\u3046\u76f4\u3057\u3092\u8fd4\u3057\u307e\u3059\u3002**\n\n**\u76ee\u7684\u3068\u671f\u9593\u306f\u3001\u6027\u80fd\u306e\u76f4\u3057\u306e\u5224\u65ad\u306b\u4f7f\u3044\u307e\u3059\u3002** \u300c\u76f4\u8fd13\u304b\u6708\u306e\u5e97\u8217\u5225\u306e\u58f2\u4e0a\u300d\u304c\u76ee\u7684\u306a\u3089\u3001\u65e5\u4ed8\u306e\u6761\u4ef6\u304c\u7121\u3044SQL\u306f\u5168\u671f\u9593\u3092\u8aad\u3093\u3067\u3044\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002**\u76ee\u7684\u306b\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u671f\u9593\u306e\u6761\u4ef6\u3092\u3001AI\u304c\u8db3\u3059\u3053\u3068\u306f\u3055\u305b\u307e\u305b\u3093\u3002** \u8db3\u3059\u3079\u304d\u304b\u3092\u6307\u6458\u3057\u3001\u8db3\u3059\u304b\u306f\u4f9d\u983c\u8005\u304c\u6c7a\u3081\u307e\u3059\u3002","data_source":"| \u53d6\u308b\u3082\u306e | \u65b9\u6cd5 | \u6ce8\u610f |\n|:--|:--|:--|\n| \u8aad\u3093\u3067\u3044\u308b\u8868 | SQL\u672c\u6587\u304b\u3089 `FROM`\u30fb`JOIN` \u306e\u5f8c\u306e\u8868\u306e\u540d\u524d\u3092\u6b63\u898f\u8868\u73fe\u3067\u62fe\u3046 | WITH\u53e5\u306e\u540d\u524d\u306f\u8868\u304b\u3089\u9664\u304f |\n| \u5217\u306e\u4e00\u89a7 | `INFORMATION_SCHEMA.COLUMNS` \u3092\u8868\u3054\u3068\u306b\u5f15\u304f | `bigquery.tables.get` \u3068 `bigquery.tables.list` \u306e\u6a29\u9650\u304c\u8981\u308b |\n| \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf | \u540c\u3058\u30d3\u30e5\u30fc\u306e `is_partitioning_column` \u3068 `clustering_ordinal_position` | \u30af\u30e9\u30b9\u30bf\u304c\u7121\u3044\u8868\u306f `NULL` |\n| \u30c9\u30e9\u30a4\u30e9\u30f3 | BigQuery \u306e `jobs.query` \u3092 `dryRun: true` \u3067\u547c\u3076 | `useLegacySql` \u306f\u65e2\u5b9a\u304c true \u306a\u306e\u3067 false \u3092\u6307\u5b9a\u3059\u308b |\n\nApps Script \u304b\u3089\u306f\u3001BigQuery \u306e\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\u3092\u6709\u52b9\u306b\u3057\u3066\u547c\u3073\u307e\u3059\u3002\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\u306f**\u516c\u958b\u3055\u308c\u3066\u3044\u308b API \u3068\u540c\u3058\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30fb\u30e1\u30bd\u30c3\u30c9\u30fb\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u4f7f\u3046**\u3068\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001`jobs.query` \u306e `dryRun` \u3092\u305d\u306e\u307e\u307e\u6e21\u305b\u307e\u3059\u3002\n\n**`useLegacySql: false` \u3092\u5fc5\u305a\u6307\u5b9a\u3057\u307e\u3059\u3002** `jobs.query` \u306e `useLegacySql` \u306f\u65e2\u5b9a\u304c true \u3067\u3059\u3002**\u6307\u5b9a\u3092\u5fd8\u308c\u308b\u3068\u3001\u6a19\u6e96\u306eSQL\u3067\u66f8\u304b\u308c\u305fSQL\u304c\u69cb\u6587\u306e\u8aa4\u308a\u3068\u3057\u3066\u8fd4\u308a\u307e\u3059\u3002** \u8aa4\u308a\u306e\u539f\u56e0\u304cSQL\u3067\u306f\u306a\u304f\u547c\u3073\u65b9\u306b\u3042\u308b\u306e\u3067\u3001\u6c17\u3065\u304d\u306b\u304f\u3044\u5931\u6557\u3067\u3059\u3002\n\n**\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u6a29\u9650\u306f\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u95b2\u89a7\u3060\u3051\u306e\u5f79\u5272\u3067\u8db3\u308a\u307e\u3059\u3002** `INFORMATION_SCHEMA.COLUMNS` \u3092\u8aad\u3080\u306b\u306f `roles\/bigquery.metadataViewer` \u306a\u3069\u306e\u5f79\u5272\u304c\u4f7f\u3048\u307e\u3059\u3002**\u70b9\u691c\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3001\u8868\u306e\u4e2d\u8eab\u3092\u8aad\u3080\u6a29\u9650\u3092\u5e83\u304f\u6301\u305f\u305b\u307e\u305b\u3093\u3002** \u4e2d\u8eab\u3092\u8aad\u3080\u306e\u306f\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u306e\u3068\u304d\u3060\u3051\u3067\u3059\u3002","preprocessing":"1. **SELECT\u6587\u304b\u306e\u78ba\u8a8d** \u2026 \u5148\u982d\u304c `SELECT` \u304b `WITH` \u3067\u3001`INSERT`\u30fb`UPDATE`\u30fb`DELETE`\u30fb`MERGE`\u30fb`CREATE`\u30fb`DROP` \u3092\u542b\u307e\u306a\u3044\u3053\u3068\u3092\u78ba\u304b\u3081\u307e\u3059\u3002\u542b\u3080\u3082\u306e\u306f\u70b9\u691c\u305b\u305a\u306b\u8fd4\u3057\u307e\u3059\n2. **\u30b3\u30e1\u30f3\u30c8\u306e\u6271\u3044** \u2026 `--` \u3068 `\/* *\/` \u306e\u30b3\u30e1\u30f3\u30c8\u306f\u6b8b\u3057\u307e\u3059\u3002**\u4f9d\u983c\u8005\u306e\u610f\u56f3\u304c\u66f8\u304b\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u591a\u3044**\u304b\u3089\u3067\u3059\n3. **\u8868\u306e\u540d\u524d\u306e\u53d6\u308a\u51fa\u3057** \u2026 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30fb\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u30fb\u8868\u306e3\u3064\u306b\u5206\u3051\u3001WITH\u53e5\u306e\u540d\u524d\u3092\u9664\u304d\u307e\u3059\n4. **\u5143\u306eSQL\u306e\u30c9\u30e9\u30a4\u30e9\u30f3** \u2026 \u69cb\u6587\u306e\u8aa4\u308a\u304c\u3042\u308c\u3070\u3001\u70b9\u691c\u306e\u524d\u306b\u8aa4\u308a\u306e\u6587\u3092\u4f9d\u983c\u8005\u306b\u8fd4\u3057\u307e\u3059\n5. **\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u8a18\u9332** \u2026 \u5143\u306eSQL\u306e\u51e6\u7406\u3055\u308c\u308b\u91cf\u3092\u8a18\u9332\u3057\u307e\u3059\u3002**\u76f4\u3057\u305f\u7248\u3068\u306e\u6bd4\u8f03\u306e\u57fa\u6e96\u306b\u306a\u308a\u307e\u3059**\n6. **0\u30d0\u30a4\u30c8\u306e\u5370** \u2026 \u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u304c\u304b\u304b\u3063\u305f\u8868\u3084\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u8aad\u3080SQL\u30670\u30d0\u30a4\u30c8\u304c\u8fd4\u3063\u305f\u3089\u3001\u5370\u3092\u4ed8\u3051\u307e\u3059\n7. **\u8868\u306e\u60c5\u5831\u306e\u5727\u7e2e** \u2026 \u5217\u304c\u591a\u3044\u8868\u306f\u3001SQL\u3067\u4f7f\u3063\u3066\u3044\u308b\u5217\u3068\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf\u306e\u5217\u3060\u3051\u306b\u7d5e\u3063\u3066\u6e21\u3057\u307e\u3059\n\n**1\u756a\u76ee\u3092AI\u306b\u4efb\u305b\u305a\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u884c\u3046\u306e\u304c\u8981\u70b9\u3067\u3059\u3002** \u66f4\u65b0\u3092\u542b\u3080SQL\u3092\u70b9\u691c\u306e\u6d41\u308c\u306b\u5165\u308c\u308b\u3068\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u3067**\u66f4\u65b0\u304c\u5b9f\u884c\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002** \u6b63\u898f\u8868\u73fe\u3067\u5f3e\u304d\u3001\u8ff7\u3046\u3082\u306e\u306f\u70b9\u691c\u3057\u307e\u305b\u3093\u3002\n\n**4\u756a\u76ee\u3067\u69cb\u6587\u306e\u8aa4\u308a\u3092\u5148\u306b\u8fd4\u3059\u306e\u3082\u3001\u540c\u3058\u7406\u7531\u3067\u3059\u3002** \u52d5\u304b\u306a\u3044SQL\u3092AI\u306b\u6e21\u3059\u3068\u3001AI\u306f\u8aa4\u308a\u3092\u76f4\u3057\u305f\u3046\u3048\u3067\u6027\u80fd\u306e\u76f4\u3057\u3092\u91cd\u306d\u3001**\u3069\u3053\u304c\u69cb\u6587\u306e\u76f4\u3057\u3067\u3069\u3053\u304c\u6027\u80fd\u306e\u76f4\u3057\u304b\u5206\u304b\u3089\u306a\u3044\u7248\u304c\u8fd4\u308a\u307e\u3059\u3002**","ai_processing":"**\u3055\u305b\u308b\u306e\u306f\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u6cbf\u3063\u3066\u554f\u984c\u3092\u62fe\u3044\u3001\u76f4\u3057\u305f\u7248\u3092\u66f8\u304d\u3001\u76f4\u3057\u3054\u3068\u306b\u89b3\u70b9\u306e\u756a\u53f7\u3068\u7406\u7531\u3068\u300c\u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u304b\u300d\u3092\u4ed8\u3051\u308b\u3053\u3068\u3067\u3059\u3002**\n\n| \u89b3\u70b9\u306e\u7a2e\u985e | \u4f8b | \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u304b |\n|:--|:--|:--|\n| \u547d\u540d\uff08N\uff09 | WITH\u53e5\u306e\u540d\u524d\u3092\u51e6\u7406\u306e\u5185\u5bb9\u304c\u5206\u304b\u308b\u540d\u524d\u306b\u3059\u308b\u3001\u5225\u540d\u3092\u8868\u306e\u7565\u79f0\u306b\u305d\u308d\u3048\u308b\u3001\u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u306b\u3059\u308b | \u5909\u308f\u3089\u306a\u3044\uff08\u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u5909\u3048\u305f\u3068\u304d\u306f\u3001\u5f8c\u308d\u306e\u51e6\u7406\u3078\u306e\u5f71\u97ff\u3092\u66f8\u304f\uff09 |\n| \u8aad\u307f\u8fbc\u3080\u5217\uff08P-01\uff09 | `SELECT *` \u3092\u4f7f\u3046\u5217\u3060\u3051\u306b\u7d5e\u308b | \u51fa\u529b\u306e\u5217\u304c\u6e1b\u308b\u306e\u3067\u5909\u308f\u308b |\n| \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\uff08P-02\uff09 | \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3067\u671f\u9593\u3092\u7d5e\u308b | \u671f\u9593\u304c\u5909\u308f\u308c\u3070\u5909\u308f\u308b |\n| \u7d50\u5408\uff08P-03\u301c\uff09 | \u7d50\u5408\u306e\u524d\u306b\u96c6\u8a08\u3059\u308b\u3001\u884c\u6570\u306e\u591a\u3044\u8868\u3092\u5148\u306b\u7f6e\u304f\u3001\u81ea\u5df1\u7d50\u5408\u3092\u30a6\u30a3\u30f3\u30c9\u30a6\u95a2\u6570\u306b\u3059\u308b | \u66f8\u304d\u65b9\u306b\u3088\u3063\u3066\u5909\u308f\u308b |\n| WITH\u53e5\uff08P-06\uff09 | \u4f55\u5ea6\u3082\u53c2\u7167\u3059\u308b\u91cd\u3044\u8a08\u7b97\u3092\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u843d\u3068\u3059\u3053\u3068\u3092\u52e7\u3081\u308b | \u5909\u308f\u3089\u306a\u3044 |\n\n**3\u5217\u76ee\u306e\u5370\u304c\u3001\u3053\u306e\u69cb\u6210\u3067\u3044\u3061\u3070\u3093\u5927\u4e8b\u306a\u533a\u5225\u3067\u3059\u3002** \u5370\u304c\u300c\u5909\u308f\u308b\u300d\u300c\u66f8\u304d\u65b9\u306b\u3088\u3063\u3066\u5909\u308f\u308b\u300d\u306e\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u3060\u3051\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u3092\u52d5\u304b\u3057\u307e\u3059\u3002**\u547d\u540d\u306e\u76f4\u3057\u3060\u3051\u306a\u3089\u7a81\u304d\u5408\u308f\u305b\u306f\u8981\u308a\u307e\u305b\u3093\u3002**\n\n| \u3055\u305b\u306a\u3044\u3053\u3068 | \u7406\u7531 |\n|:--|:--|\n| \u696d\u52d9\u306e\u5b9a\u7fa9\u306e\u5909\u66f4 | \u58f2\u4e0a\u306b\u8fd4\u54c1\u3092\u542b\u3081\u308b\u304b\u3001\u3069\u306e\u5e97\u8217\u3092\u5bfe\u8c61\u306b\u3059\u308b\u304b\u306f\u696d\u52d9\u90e8\u9580\u304c\u6c7a\u3081\u308b |\n| \u76ee\u7684\u306b\u7121\u3044\u671f\u9593\u306e\u6761\u4ef6\u306e\u8ffd\u52a0 | \u671f\u9593\u3092\u6c7a\u3081\u308b\u306e\u306f\u4f9d\u983c\u8005\u3002\u8db3\u3059\u3079\u304d\u304b\u306e\u6307\u6458\u306b\u3068\u3069\u3081\u308b |\n| \u8868\u306e\u60c5\u5831\u306b\u7121\u3044\u5217\u306e\u4f7f\u7528 | \u5b9f\u5728\u3057\u306a\u3044\u5217\u306e\u540d\u524d\u3067\u76f4\u3055\u306a\u3044 |\n| \u66f4\u65b0\u30fb\u4f5c\u6210\u306e\u6587\u306e\u63d0\u6848 | \u70b9\u691c\u306e\u5bfe\u8c61\u306fSELECT\u6587\u3060\u3051 |\n| \u300c\u7d50\u679c\u306f\u540c\u3058\u300d\u3068\u3044\u3046\u7d50\u8ad6 | \u540c\u3058\u304b\u3069\u3046\u304b\u306f\u7a81\u304d\u5408\u308f\u305b\u3067\u78ba\u304b\u3081\u308b |\n\n**5\u884c\u76ee\u304c\u3044\u3061\u3070\u3093\u8d77\u304d\u3084\u3059\u3044\u5931\u6557\u3067\u3059\u3002** \u66f8\u304d\u63db\u3048\u305f\u7406\u7531\u306b\u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u6dfb\u3048\u308b\u306e\u306f\u81ea\u7136\u306a\u66f8\u304d\u65b9\u3067\u3059\u304c\u3001**\u305d\u306e\u4e00\u6587\u3092\u4fe1\u3058\u3066\u7a81\u304d\u5408\u308f\u305b\u3092\u7701\u304f\u3068\u3001\u7b2c3\u7ae0\u306e\uff08c\uff09\u304c\u305d\u306e\u307e\u307e\u8d77\u304d\u307e\u3059\u3002**","prompt_example":"```\n\u3042\u306a\u305f\u306f\u793e\u5185\u306e\u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u3067\u3001\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u66f8\u3044\u305fSELECT\u6587\u3092\n\u70b9\u691c\u3059\u308b\u62c5\u5f53\u8005\u3092\u624b\u4f1d\u3046\u7acb\u5834\u3067\u3059\u3002\n\u6e21\u3055\u308c\u305f\u300c\u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u300d\u306b\u6cbf\u3063\u3066SQL\u3092\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u3001\n\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3092\u8fd4\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n\n\u3010\u53b3\u5b88\u4e8b\u9805\u3011\n- \u76f4\u3057\u306f\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u8f09\u3063\u3066\u3044\u308b\u9805\u76ee\u306b\u5f53\u305f\u308b\u3082\u306e\u3060\u3051\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n  \u4e00\u89a7\u306b\u7121\u3044\u597d\u307f\u306e\u66f8\u304d\u65b9\u3067\u76f4\u3055\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76f4\u3057\u3054\u3068\u306b rule_id\uff08N-01 \u3084 P-02\uff09\u3092\u5fc5\u305a\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- \u8868\u306e\u60c5\u5831\u306b\u8f09\u3063\u3066\u3044\u306a\u3044\u5217\u306e\u540d\u524d\u3092\u4f7f\u308f\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u696d\u52d9\u306e\u5b9a\u7fa9\uff08\u4f55\u3092\u58f2\u4e0a\u3068\u3059\u308b\u304b\u3001\u3069\u306e\u5e97\u8217\u30fb\u4f1a\u54e1\u3092\u5bfe\u8c61\u306b\u3059\u308b\u304b\uff09\u3092\u5909\u3048\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76ee\u7684\u306b\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u671f\u9593\u306e\u6761\u4ef6\u3092\u8db3\u3055\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n  \u671f\u9593\u306e\u6761\u4ef6\u304c\u7121\u3044\u3053\u3068\u304c\u554f\u984c\u306a\u3089\u3001notes \u306b\u6307\u6458\u3068\u3057\u3066\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u76f4\u3057\u306b\u306f result_may_change \u3092 true \u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n  LEFT JOIN \u306e\u76f8\u624b\u306e\u8868\u306e\u6761\u4ef6\u3092 ON \u3068 WHERE \u306e\u9593\u3067\u52d5\u304b\u3059\u76f4\u3057\u3001\n  SELECT * \u3092\u5217\u306e\u6307\u5b9a\u306b\u5909\u3048\u308b\u76f4\u3057\u3001DISTINCT \u3092\u5916\u3059\u76f4\u3057\u3001\n  \u96c6\u8a08\u306e\u4f4d\u7f6e\u3092\u52d5\u304b\u3059\u76f4\u3057\u306f\u3001\u5fc5\u305a true \u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n- \u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u66f8\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\u7d50\u679c\u304c\u540c\u3058\u304b\u3069\u3046\u304b\u306f\n  \u5225\u306e\u624b\u9806\u3067\u78ba\u304b\u3081\u307e\u3059\u3002\n- before \u306b\u306f\u5143\u306eSQL\u306e\u8a72\u5f53\u90e8\u5206\u3092\u4e00\u5b57\u4e00\u53e5\u305d\u306e\u307e\u307e\u5199\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n- \u7406\u7531\uff08reason\uff09\u306f\u3001\u4f9d\u983c\u8005\u304c\u6b21\u306b\u540c\u3058\u66f8\u304d\u65b9\u3092\u3057\u306a\u3044\u3067\u6e08\u3080\u3088\u3046\u306b\u3001\n  2\u6587\u4ee5\u5185\u3067\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- SELECT\u6587\u4ee5\u5916\u306e\u6587\uff08INSERT\u3001UPDATE\u3001CREATE \u306a\u3069\uff09\u3092\u66f8\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76f4\u3059\u7b87\u6240\u304c\u7121\u3051\u308c\u3070\u3001changes \u3092\u7a7a\u306b\u3057\u3066 revised_sql \u306b\u5143\u306eSQL\u3092\u5165\u308c\u3066\u304f\u3060\u3055\u3044\u3002\n\n\u3010\u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u3011{rules}\n\u3010SQL\u672c\u6587\u3011{sql}\n\u3010\u76ee\u7684\u3068\u671f\u9593\u3011{purpose}\n\u3010\u8868\u306e\u60c5\u5831\uff08\u5217\u3001\u578b\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3001\u30af\u30e9\u30b9\u30bf\uff09\u3011{table_info}\n\u3010\u5143\u306eSQL\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c\uff08\u51e6\u7406\u3055\u308c\u308b\u91cf\uff09\u3011{dry_run}\n```\n\n**\u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u3068\u66f8\u304b\u306a\u3044\u300d\u3092\u660e\u8a18\u3057\u306a\u3044\u3068\u3001\u7406\u7531\u306e\u307b\u307c\u3059\u3079\u3066\u306b\u4ed8\u304d\u307e\u3059\u3002** \u4f9d\u983c\u8005\u3092\u5b89\u5fc3\u3055\u305b\u308b\u66f8\u304d\u65b9\u3068\u3057\u3066\u81ea\u7136\u306b\u51fa\u3066\u304d\u307e\u3059\u3002**\u7981\u3058\u308b\u306e\u306f\u3001\u78ba\u304b\u3081\u3066\u3044\u306a\u3044\u3053\u3068\u3092\u78ba\u304b\u3081\u305f\u3088\u3046\u306b\u66f8\u304f\u3053\u3068\u3067\u3059\u3002**\n\n**`before` \u3092\u4e00\u5b57\u4e00\u53e5\u3067\u5199\u3055\u305b\u308b\u306e\u306f\u3001\u5f8c\u3067\u7167\u3089\u3059\u305f\u3081\u3067\u3059\u3002** \u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u5143\u306eSQL\u306e\u4e2d\u306b `before` \u306e\u6587\u5b57\u5217\u304c\u3042\u308b\u304b\u3092\u78ba\u304b\u3081\u3001**\u898b\u3064\u304b\u3089\u306a\u3044\u76f4\u3057\u306f\u4e00\u89a7\u304b\u3089\u5916\u3057\u3066\u5370\u3092\u4ed8\u3051\u307e\u3059\u3002**","output_data":"**Claude API \u306e\u69cb\u9020\u5316\u51fa\u529b\u3067\u3001\u6b21\u306e\u5f62\u306eJSON\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002**\n\n```json\n{\n  \"revised_sql\": \"\",\n  \"changes\": [\n    {\n      \"rule_id\": \"P-02\",\n      \"category\": \"naming | performance\",\n      \"before\": \"\",\n      \"after\": \"\",\n      \"reason\": \"\",\n      \"result_may_change\": true\n    }\n  ],\n  \"notes\": [\n    { \"kind\": \"missing_date_filter | business_definition | other\", \"text\": \"\" }\n  ]\n}\n```\n\n**1\u3064\u76ee\u306e\u7406\u7531\u306f\u3001`rule_id` \u3067\u6307\u6458\u3092\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u7d50\u3073\u4ed8\u3051\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** \u4e00\u89a7\u306b\u7121\u3044\u756a\u53f7\u306e\u76f4\u3057\u306f\u53d7\u3051\u4ed8\u3051\u307e\u305b\u3093\u3002**\u3069\u306e\u6c7a\u307e\u308a\u306b\u57fa\u3065\u304f\u76f4\u3057\u304b\u304c\u3001\u4f9d\u983c\u8005\u306b\u3082\u898b\u3048\u307e\u3059\u3002** \u7406\u7531\u306e\u5f8c\u308d\u306b\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u8a72\u5f53\u9805\u76ee\u3078\u306e\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u3066\u8fd4\u3057\u307e\u3059\u3002\n\n**2\u3064\u76ee\u306f\u3001`result_may_change` \u3067\u7a81\u304d\u5408\u308f\u305b\u306e\u8981\u5426\u3092\u6c7a\u3081\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** 1\u3064\u3067\u3082 true \u304c\u3042\u308c\u3070\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u7a81\u304d\u5408\u308f\u305b\u3092\u52d5\u304b\u3057\u307e\u3059\u3002\n\n**3\u3064\u76ee\u306f\u3001`notes` \u3092\u76f4\u3057\u3068\u5206\u3051\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** \u671f\u9593\u306e\u6761\u4ef6\u304c\u7121\u3044\u3053\u3068\u3084\u3001\u696d\u52d9\u306e\u5b9a\u7fa9\u306b\u95a2\u308f\u308b\u7591\u554f\u306f\u3001**\u76f4\u3055\u305a\u306b\u4f9d\u983c\u8005\u3078\u306e\u554f\u3044\u3068\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002**\n\n\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3001AI\u306e\u51fa\u529b\u306e\u5f8c\u306b\u6b21\u306e3\u3064\u3092\u6a5f\u68b0\u3067\u78ba\u304b\u3081\u3001\u70b9\u691c\u306e\u533a\u5206\u3092\u6c7a\u3081\u307e\u3059\u3002\n\n| \u533a\u5206 | \u6761\u4ef6 |\n|:--|:--|\n| \u8fd4\u5374\u53ef | \u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u6210\u529f\u3057\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u304c\u5143\u3088\u308a\u5897\u3048\u3066\u304a\u3089\u305a\u3001\u7a81\u304d\u5408\u308f\u305b\u304c\u4e0d\u8981\u304b\u5dee\u304c0\u884c |\n| \u8981\u78ba\u8a8d | \u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u305f\u3001`before` \u304c\u5143\u306eSQL\u306b\u898b\u3064\u304b\u3089\u306a\u3044\u30010\u30d0\u30a4\u30c8\u306e\u5370\u304c\u3042\u308b |\n| \u5dee\u3057\u623b\u3057 | \u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u5931\u6557\u3057\u305f |\n\n\u7a81\u304d\u5408\u308f\u305b\u306f\u3001\u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u306e\u4e21\u65b9\u306b**\u540c\u30581\u65e5\u5206\u306e\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u6761\u4ef6**\u3092\u8db3\u3057\u3066\u5b9f\u884c\u3057\u3001`EXCEPT DISTINCT` \u3067\u53cc\u65b9\u5411\u306e\u5dee\u306e\u884c\u6570\u3092\u6570\u3048\u307e\u3059\u3002\u5b9f\u884c\u306b\u306f `maximumBytesBilled` \u3092\u4ed8\u3051\u307e\u3059\u3002`jobs.query` \u306e\u8aac\u660e\u3067\u306f\u3001**\u3053\u306e\u4e0a\u9650\u3092\u8d85\u3048\u308b\u30af\u30a8\u30ea\u306f\u6599\u91d1\u304c\u304b\u304b\u3089\u305a\u306b\u5931\u6557\u3059\u308b**\u3068\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n\n```sql\n-- \u7a81\u304d\u5408\u308f\u305b\u306e\u5b9a\u578b\uff08{orig} \u3068 {revised} \u306f1\u65e5\u5206\u306e\u6761\u4ef6\u3092\u8db3\u3057\u305f\u3082\u306e\uff09\nWITH a AS ({orig}), b AS ({revised})\nSELECT\n  (SELECT COUNT(*) FROM (SELECT * FROM a EXCEPT DISTINCT SELECT * FROM b)) AS only_in_orig,\n  (SELECT COUNT(*) FROM (SELECT * FROM b EXCEPT DISTINCT SELECT * FROM a)) AS only_in_revised\n```\n\n**\u5217\u306e\u4e26\u3073\u304c\u5909\u308f\u308b\u76f4\u3057\u3067\u306f\u3001\u3053\u306e\u6bd4\u8f03\u304c\u901a\u308a\u307e\u305b\u3093\u3002** \u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3084\u9806\u3092\u5909\u3048\u305f\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u306f\u3001\u7a81\u304d\u5408\u308f\u305b\u306e\u524d\u306b\u3001\u5143\u306eSQL\u306e\u5217\u306e\u4e26\u3073\u306b\u5408\u308f\u305b\u3066\u76f4\u3057\u305f\u7248\u3092\u5305\u307f\u76f4\u3057\u307e\u3059\u3002","integration_systems":"| \u3064\u306a\u304e\u5148 | \u65b9\u5f0f | \u5185\u5bb9 |\n|:--|:--|:--|\n| \u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0 | Apps Script \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc | \u4f9d\u983c\u306e\u53d7\u3051\u4ed8\u3051 |\n| BigQuery | Apps Script \u306e\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\uff08`jobs.query`\uff09 | \u30e1\u30bf\u30c7\u30fc\u30bf\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u3001\u7a81\u304d\u5408\u308f\u305b\u306e\u5b9f\u884c |\n| Claude API | `UrlFetchApp` \u304b\u3089 Messages API | \u70b9\u691c\u3068\u76f4\u3057\u305f\u7248\u306e\u4f5c\u6210 |\n| \u70b9\u691c\u306e\u4e00\u89a7 | \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u306e\u8ffd\u8a18 | \u533a\u5206\u3001\u76f4\u3057\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u6bd4\u8f03 |\n| \u30c7\u30fc\u30bf\u62c5\u5f53 | Google Chat \u307e\u305f\u306f\u30e1\u30fc\u30eb | \u300c\u8981\u78ba\u8a8d\u300d\u300c\u5dee\u3057\u623b\u3057\u300d\u3092\u5148\u306b\u77e5\u3089\u305b\u308b |\n\nApps Script \u306e `UrlFetchApp` \u306f\u3001Google Workspace \u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u30671\u65e510\u4e07\u56de\u307e\u3067\u547c\u3079\u307e\u3059\u3002**\u6708240\u4ef6\u306e\u70b9\u691c\u306a\u3089\u4e0a\u9650\u306b\u5c4a\u304d\u307e\u305b\u3093\u3002** \u30c8\u30ea\u30ac\u30fc\u306e\u5408\u8a08\u306e\u5b9f\u884c\u6642\u9593\u306f1\u65e56\u6642\u9593\u307e\u3067\u3067\u30011\u4ef6\u306e\u70b9\u691c\u306f\u6570\u5341\u79d2\u3067\u7d42\u308f\u308b\u60f3\u5b9a\u3067\u3059\u3002\n\n\u4f9d\u983c\u8005\u3078\u306e\u8fd4\u5374\u306f\u3001**\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u4e00\u89a7\u306e\u884c\u304b\u3089\u9001\u308a\u307e\u3059\u3002** \u8fd4\u3059\u6587\u9762\u306b\u306f\u3001\u76f4\u3057\u305f\u7248\u3001\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3068\u89b3\u70b9\u306e\u756a\u53f7\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u5909\u5316\uff08\u4f8b\uff1a\u5143 820GB \u2192 \u76f4\u3057\u305f\u7248 36GB\uff09\u3001`notes` \u306e\u554f\u3044\u3092\u4e26\u3079\u307e\u3059\u3002**\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u5909\u5316\u3092\u6570\u5b57\u3067\u8fd4\u3059\u3068\u3001\u4f9d\u983c\u8005\u304c\u76f4\u3057\u3092\u53d7\u3051\u5165\u308c\u308b\u7406\u7531\u306b\u306a\u308a\u307e\u3059\u3002**","human_review":"1. **\u300c\u8981\u78ba\u8a8d\u300d\u3068\u300c\u5dee\u3057\u623b\u3057\u300d\u3092\u5148\u306b\u898b\u308b** \u2026 \u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u305f\u3082\u306e\u306f\u3001\u3069\u306e\u76f4\u3057\u304c\u5dee\u3092\u751f\u3093\u3060\u304b\u3092\u898b\u307e\u3059\n2. **`result_may_change` \u304c true \u306e\u76f4\u3057\u3092\u8aad\u3080** \u2026 \u5dee\u304c0\u884c\u3067\u3082\u30011\u65e5\u5206\u3067\u306f\u51fa\u306a\u304b\u3063\u305f\u3060\u3051\u306e\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002**\u6708\u672b\u3084\u795d\u65e5\u306e\u6761\u4ef6\u306b\u95a2\u308f\u308b\u76f4\u3057\u306f\u3001\u5225\u306e\u65e5\u3067\u3082\u7a81\u304d\u5408\u308f\u305b\u307e\u3059**\n3. **`notes` \u306e\u554f\u3044\u3092\u78ba\u304b\u3081\u308b** \u2026 \u671f\u9593\u306e\u6761\u4ef6\u3084\u696d\u52d9\u306e\u5b9a\u7fa9\u306e\u7591\u554f\u306f\u3001\u4f9d\u983c\u8005\u306b\u805e\u304f\u5f62\u3067\u8fd4\u3057\u307e\u3059\n4. **\u547d\u540d\u306e\u76f4\u3057\u306f\u6d41\u3057\u898b\u308b** \u2026 \u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u5909\u3048\u305f\u76f4\u3057\u306f\u3001\u5f8c\u308d\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3084\u30ec\u30dd\u30fc\u30c8\u304c\u5217\u306e\u540d\u524d\u3067\u53c2\u7167\u3057\u3066\u3044\u306a\u3044\u304b\u3092\u4f9d\u983c\u8005\u306b\u78ba\u304b\u3081\u307e\u3059\n5. **AI\u306e\u76f4\u3057\u3092\u8986\u3057\u305f\u3089\u8a18\u9332\u3059\u308b** \u2026 \u89b3\u70b9\u306e\u4e00\u89a7\u306e\u66f8\u304d\u65b9\u3092\u76f4\u3059\u6750\u6599\u306b\u3057\u307e\u3059\n\n**2\u756a\u76ee\u3092\u7701\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002** 1\u65e5\u5206\u306e\u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c0\u884c\u3067\u3082\u3001**\u6708\u3092\u307e\u305f\u3050\u6761\u4ef6\u3084\u3001\u7279\u5b9a\u306e\u66dc\u65e5\u306b\u3057\u304b\u7121\u3044\u30c7\u30fc\u30bf\u3067\u306f\u5dee\u304c\u51fa\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002** \u7a81\u304d\u5408\u308f\u305b\u306f\u300c\u5dee\u304c\u7121\u3044\u3053\u3068\u306e\u8a3c\u660e\u300d\u3067\u306f\u306a\u304f\u3001**\u300c\u5dee\u304c\u3042\u308b\u3053\u3068\u3092\u898b\u3064\u3051\u308b\u7db2\u300d**\u3067\u3059\u3002\n\n**\u76ee\u6a19\u306f\u3001240\u4ef6\u3092\u306a\u3089\u3057\u30661\u4ef65\u5206\u3067\u3059\u3002** \u300c\u8fd4\u5374\u53ef\u300d\u306f\u76f4\u3057\u3092\u6d41\u3057\u898b\u3066\u8fd4\u3057\u3001\u300c\u8981\u78ba\u8a8d\u300d\u306b\u6642\u9593\u3092\u4f7f\u3044\u307e\u3059\u3002","exception_handling":"| \u8d77\u304d\u308b\u3053\u3068 | \u5bfe\u5fdc |\n|:--|:--|\n| SELECT\u6587\u3067\u306a\u3044 | \u70b9\u691c\u305b\u305a\u3001\u300c\u70b9\u691c\u306e\u5bfe\u8c61\u5916\u300d\u3068\u4f9d\u983c\u8005\u306b\u8fd4\u3059 |\n| \u5143\u306eSQL\u304c\u69cb\u6587\u306e\u8aa4\u308a | \u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u8aa4\u308a\u306e\u6587\u3092\u8fd4\u3057\u3001\u76f4\u3057\u3066\u304b\u3089\u51fa\u3057\u76f4\u3057\u3066\u3082\u3089\u3046 |\n| \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u6a29\u9650\u304c\u70b9\u691c\u7528\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u7121\u3044 | \u300c\u8981\u78ba\u8a8d\u300d\u3002\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u6a29\u9650\u306e\u4ed8\u4e0e\u304b\u3092\u5224\u65ad\u3059\u308b |\n| 0\u30d0\u30a4\u30c8\u304c\u8fd4\u3063\u305f\uff08\u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30fb\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\uff09 | \u8aad\u307f\u8fbc\u3080\u91cf\u306e\u6bd4\u8f03\u3092\u305b\u305a\u3001\u300c\u8981\u78ba\u8a8d\u300d |\n| `before` \u304c\u5143\u306eSQL\u306b\u898b\u3064\u304b\u3089\u306a\u3044 | \u305d\u306e\u76f4\u3057\u3092\u5916\u3057\u3001\u300c\u8981\u78ba\u8a8d\u300d |\n| \u7a81\u304d\u5408\u308f\u305b\u304c `maximumBytesBilled` \u3067\u6b62\u307e\u308b | \u671f\u9593\u3092\u3055\u3089\u306b\u77ed\u304f\u3059\u308b\u304b\u3001\u7a81\u304d\u5408\u308f\u305b\u3092\u4eba\u306b\u56de\u3059 |\n| 6\u5206\u3092\u8d85\u3048\u305d\u3046 | \u7a81\u304d\u5408\u308f\u305b\u3092\u5f8c\u56de\u3057\u306e\u5b9f\u884c\u306b\u5206\u3051\u308b |\n| \u69cb\u9020\u5316\u51fa\u529b\u304c `refusal` \u3084 `max_tokens` \u3067\u7d42\u308f\u308b | \u53d7\u3051\u4ed8\u3051\u305a\u3001`max_tokens` \u3092\u4e0a\u3052\u3066\u518d\u5b9f\u884c\u3002\u7d9a\u3051\u3070\u4eba\u3078 |","log_storage":"- \u4f9d\u983c\u306e\u65e5\u6642\u3001\u4f9d\u983c\u8005\u3001SQL\u672c\u6587\u3001\u76ee\u7684\u3068\u671f\u9593\n- \u6e21\u3057\u305f\u8868\u306e\u60c5\u5831\u3068\u3001\u305d\u306e\u3068\u304d\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u7248\n- \u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c\uff08\u51e6\u7406\u3055\u308c\u308b\u91cf\uff09\n- Claude API \u306e\u51fa\u529b\u306e\u5168\u6587\u3068\u3001\u7167\u5408\u3067\u5916\u3057\u305f\u76f4\u3057\n- \u7a81\u304d\u5408\u308f\u305b\u306e\u6761\u4ef6\uff08\u65e5\u4ed8\uff09\u3068\u3001\u53cc\u65b9\u5411\u306e\u5dee\u306e\u884c\u6570\n- \u30c7\u30fc\u30bf\u62c5\u5f53\u306e\u6700\u7d42\u306e\u5224\u65ad\u3001\u8986\u3057\u305f\u76f4\u3057\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3057\u305f\u65e5\u6642\n\n**\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u7248\u3092\u6b8b\u3059\u306e\u306f\u3001\u6c7a\u307e\u308a\u304c\u5f8c\u304b\u3089\u5909\u308f\u308b\u305f\u3081\u3067\u3059\u3002** \u547d\u540d\u306e\u6c7a\u307e\u308a\u3092\u5909\u3048\u308b\u3068\u904e\u53bb\u306e\u76f4\u3057\u306e\u610f\u5473\u304c\u5909\u308f\u308a\u3001**\u5f53\u6642\u306e\u6c7a\u307e\u308a\u304c\u6b8b\u3063\u3066\u3044\u306a\u3044\u3068\u3001\u306a\u305c\u305d\u306e\u76f4\u3057\u3092\u3057\u305f\u304b\u304c\u8ffd\u3048\u307e\u305b\u3093\u3002**\n\n**\u4f9d\u983c\u8005\u3054\u3068\u306e\u6307\u6458\u306e\u591a\u3044\u89b3\u70b9\u3082\u3001\u6708\u306b1\u56de\u6570\u3048\u307e\u3059\u3002** \u540c\u3058\u89b3\u70b9\u3067\u6bce\u6708\u76f4\u3055\u308c\u3066\u3044\u308b\u4eba\u306b\u306f\u3001**\u70b9\u691c\u3067\u8fd4\u3059\u3088\u308a\u3001\u77ed\u3044\u52c9\u5f37\u4f1a\u3067\u4f1d\u3048\u305f\u307b\u3046\u304c\u65e9\u304f\u6e1b\u308a\u307e\u3059\u3002**","implementation_level":"\u534a\u81ea\u52d5\u5316","difficulty":2,"cost_band":"\u4e2d","cost_level_label":"API\u9023\u643a","security_level":"\u4e2d","implementation_status":"\u69cb\u6210\u4f8b","assumption_people":3,"assumption_frequency":240,"assumption_workdays":20,"volume_month":240,"before_minutes_per_case":15,"after_minutes_per_case":5,"hourly_cost":4500,"before_hours_month":60,"after_hours_month":20,"saved_hours_month":40,"reduction_rate":67,"saved_hours_year":480,"annual_cost_effect":2160000,"summary":"\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u66f8\u3044\u305f\u30c7\u30fc\u30bf\u62bd\u51fa\u306eSQL\u3092\u3001\u793e\u5185\u306e\u547d\u540d\u898f\u7d04\u3068 BigQuery \u306e\u6027\u80fd\u306e\u89b3\u70b9\u3067\u70b9\u691c\u3057\u307e\u3059\u3002\u76f4\u3057\u305f\u7248\u306eSQL\u3068\u3001\u76f4\u3057\u305f\u7b87\u6240\u3054\u3068\u306e\u7406\u7531\u3092\u3001\u66f8\u3044\u305f\u672c\u4eba\u3068\u30c7\u30fc\u30bf\u62c5\u5f53\u306b\u8fd4\u3057\u307e\u3059\u3002","before_flow":"1. \u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u3001BigQuery \u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u3067SQL\u3092\u66f8\u3044\u3066\u8a66\u3059\n2. \u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306bSQL\u3068\u76ee\u7684\uff08\u4f55\u306b\u4f7f\u3046\u304b\u3001\u3069\u306e\u671f\u9593\u304b\uff09\u3092\u66f8\u3044\u3066\u70b9\u691c\u3092\u4f9d\u983c\u3059\u308b\n3. \u30c7\u30fc\u30bf\u62c5\u5f53\u304cSQL\u3092\u958b\u304d\u3001\u8aad\u3093\u3067\u3044\u308b\u8868\u3068\u5217\u3001\u6761\u4ef6\u3001\u7d50\u5408\u3092\u8aad\u307f\u53d6\u308b\n4. \u793e\u5185\u306e\u6c7a\u307e\u308a\u306b\u7167\u3089\u3057\u3001\u547d\u540d\u30fb\u5225\u540d\u30fb\u65e5\u4ed8\u306e\u6271\u3044\u3092\u898b\u308b\n5. \u6027\u80fd\u306e\u89b3\u70b9\u3067\u3001\u8aad\u307f\u8fbc\u3080\u5217\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u6761\u4ef6\u3001\u7d50\u5408\u306e\u9806\u3001\u304f\u308a\u8fd4\u3057\u53c2\u7167\u3055\u308c\u308bWITH\u53e5\u3092\u898b\u308b\n6. \u76f4\u3057\u305f\u7248\u3092\u66f8\u304d\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u3067\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u78ba\u304b\u3081\u308b\n7. \u76f4\u3057\u305f\u7b87\u6240\u3068\u7406\u7531\u3092\u66f8\u3044\u3066\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3059\n\n**\uff08a\uff09\u898b\u308b\u4eba\u304c\u9650\u3089\u308c\u3066\u5f85\u3061\u304c\u51fa\u308b\u3002** BigQuery \u306e\u6027\u80fd\u306e\u52d8\u3069\u3053\u308d\u304c\u5206\u304b\u308b\u306e\u306f3\u540d\u3060\u3051\u3067\u3059\u3002**\u4f9d\u983c\u304c\u96c6\u4e2d\u3059\u308b\u6708\u521d\u306f\u3001\u8fd4\u3059\u307e\u3067\u306b3\u301c4\u65e5\u304b\u304b\u308a\u307e\u3059\u3002** \u5f85\u3061\u304d\u308c\u305a\u306b\u3001\u70b9\u691c\u3092\u901a\u3055\u306a\u3044\u307e\u307e\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u307e\u308c\u308bSQL\u304c\u51fa\u307e\u3059\u3002\n\n**\uff08b\uff09\u6307\u6458\u306e\u57fa\u6e96\u304c\u4eba\u306b\u3088\u3063\u3066\u9055\u3046\u3002** \u3042\u308b\u62c5\u5f53\u306f\u5225\u540d\u306e\u4ed8\u3051\u65b9\u307e\u3067\u76f4\u3057\u3001\u5225\u306e\u62c5\u5f53\u306f\u6027\u80fd\u3060\u3051\u3092\u898b\u307e\u3059\u3002**\u540c\u3058SQL\u3067\u3082\u3001\u8ab0\u306b\u5f53\u305f\u308b\u304b\u3067\u8fd4\u3063\u3066\u304f\u308b\u76f4\u3057\u304c\u5909\u308f\u308a\u307e\u3059\u3002** \u4f9d\u983c\u8005\u304b\u3089\u898b\u308b\u3068\u3001\u6c7a\u307e\u308a\u304c\u3069\u3053\u306b\u3042\u308b\u306e\u304b\u5206\u304b\u308a\u307e\u305b\u3093\u3002\n\n**\uff08c\uff09\u76f4\u3057\u3067\u7d50\u679c\u304c\u5909\u308f\u3063\u305f\u3053\u3068\u306b\u6c17\u3065\u304b\u306a\u3044\u3002** \u6027\u80fd\u306e\u305f\u3081\u306b\u6761\u4ef6\u306e\u4f4d\u7f6e\u3092\u52d5\u304b\u3057\u3001\u5916\u90e8\u7d50\u5408\u304c\u5185\u90e8\u7d50\u5408\u3068\u540c\u3058\u7d50\u679c\u306b\u306a\u308b\u76f4\u3057\u3092\u8fd4\u3057\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002**\u76f4\u3057\u305f\u5074\u3082\u4f9d\u983c\u8005\u3082\u3001\u4ef6\u6570\u304c\u5c11\u3057\u6e1b\u3063\u305f\u3053\u3068\u306b\u6c17\u3065\u304b\u306a\u3044\u307e\u307e\u4f7f\u3044\u307e\u3059\u3002**\n\n**\uff08d\uff09\u540c\u3058\u76f4\u3057\u3092\u6bce\u6708\u304f\u308a\u8fd4\u3059\u3002** \u76f4\u3057\u305f\u7406\u7531\u3092\u6bce\u56de\u624b\u3067\u66f8\u304f\u306e\u3067\u3001\u77ed\u304f\u6e08\u307e\u305b\u304c\u3061\u3067\u3059\u3002**\u7406\u7531\u304c\u4f1d\u308f\u3089\u306a\u3044\u306e\u3067\u3001\u6b21\u306e\u6708\u3082\u540c\u3058SQL\u304c\u5c4a\u304d\u307e\u3059\u3002** \u6559\u3048\u308b\u6a5f\u4f1a\u3092\u3001\u70b9\u691c\u306e\u305f\u3073\u306b\u9003\u3057\u3066\u3044\u307e\u3059\u3002","before_flow_steps":["\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u3001BigQuery \u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u3067SQL\u3092\u66f8\u3044\u3066\u8a66\u3059","\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306bSQL\u3068\u76ee\u7684\uff08\u4f55\u306b\u4f7f\u3046\u304b\u3001\u3069\u306e\u671f\u9593\u304b\uff09\u3092\u66f8\u3044\u3066\u70b9\u691c\u3092\u4f9d\u983c\u3059\u308b","\u30c7\u30fc\u30bf\u62c5\u5f53\u304cSQL\u3092\u958b\u304d\u3001\u8aad\u3093\u3067\u3044\u308b\u8868\u3068\u5217\u3001\u6761\u4ef6\u3001\u7d50\u5408\u3092\u8aad\u307f\u53d6\u308b","\u793e\u5185\u306e\u6c7a\u307e\u308a\u306b\u7167\u3089\u3057\u3001\u547d\u540d\u30fb\u5225\u540d\u30fb\u65e5\u4ed8\u306e\u6271\u3044\u3092\u898b\u308b","\u6027\u80fd\u306e\u89b3\u70b9\u3067\u3001\u8aad\u307f\u8fbc\u3080\u5217\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u6761\u4ef6\u3001\u7d50\u5408\u306e\u9806\u3001\u304f\u308a\u8fd4\u3057\u53c2\u7167\u3055\u308c\u308bWITH\u53e5\u3092\u898b\u308b","\u76f4\u3057\u305f\u7248\u3092\u66f8\u304d\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u3067\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u78ba\u304b\u3081\u308b","\u76f4\u3057\u305f\u7b87\u6240\u3068\u7406\u7531\u3092\u66f8\u3044\u3066\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3059"],"after_flow":"1. **\u3010\u4eba\u3011** \u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u3001\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306bSQL\u3068\u76ee\u7684\u3092\u66f8\u3044\u3066\u70b9\u691c\u3092\u4f9d\u983c\u3059\u308b\n2. **\u3010\u81ea\u52d5\u3011** \u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u304d\u3063\u304b\u3051\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u52d5\u304d\u3001SELECT\u6587\u304b\u3069\u3046\u304b\u3068\u3001\u8aad\u3093\u3067\u3044\u308b\u8868\u3092\u53d6\u308a\u51fa\u3059\n3. **\u3010\u81ea\u52d5\u3011** \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u5217\u306e\u4e00\u89a7\u3068\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf\u306e\u5217\u3092\u3001BigQuery \u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u304b\u3089\u53d6\u308b\n4. **\u3010\u81ea\u52d5\u3011** \u5143\u306eSQL\u3092\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u304b\u3051\u3001\u69cb\u6587\u306e\u8aa4\u308a\u3068\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u53d6\u308b\n5. **\u3010\u81ea\u52d5\u3011** Claude API \u304c\u3001\u547d\u540d\u898f\u7d04\u3068\u6027\u80fd\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u6cbf\u3063\u3066SQL\u3092\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3092\u8fd4\u3059\n6. **\u3010\u81ea\u52d5\u3011** \u76f4\u3057\u305f\u7248\u3092\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u304b\u3051\u3001\u69cb\u6587\u3068\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u78ba\u304b\u3081\u308b\n7. **\u3010\u81ea\u52d5\u3011** \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u306f\u3001\u77ed\u3044\u671f\u9593\u3067\u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u3092\u5b9f\u884c\u3057\u3001\u7d50\u679c\u3092\u7a81\u304d\u5408\u308f\u305b\u308b\n8. **\u3010\u81ea\u52d5\u3011** \u70b9\u691c\u306e\u7d50\u679c\u3092\u4e00\u89a7\u306b\u66f8\u304d\u3001\u30c7\u30fc\u30bf\u62c5\u5f53\u306b\u77e5\u3089\u305b\u308b\n9. **\u3010\u4eba\u3011** \u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u3001\u76f4\u3057\u3068\u7a81\u304d\u5408\u308f\u305b\u306e\u7d50\u679c\u3092\u78ba\u304b\u3081\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3059\n\n**7\u756a\u76ee\u304c\u3001\u3053\u306e\u8a2d\u8a08\u306e\u5206\u304b\u308c\u76ee\u3067\u3059\u3002** \u76f4\u3057\u305f\u7248\u304c\u901f\u304f\u306a\u3063\u3066\u3082\u3001**\u7d50\u679c\u304c\u5909\u308f\u308c\u3070\u4f7f\u3048\u307e\u305b\u3093\u3002** AI\u306b\u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u8a00\u308f\u305b\u308b\u306e\u3067\u306f\u306a\u304f\u3001**\u4e21\u65b9\u3092\u5b9f\u884c\u3057\u3066\u884c\u306e\u5dee\u3092\u6570\u3048\u307e\u3059\u3002**\n\n**9\u756a\u76ee\u3092\u6b8b\u3057\u3066\u3044\u308b\u306e\u3082\u3001\u610f\u56f3\u3057\u3066\u306e\u3053\u3068\u3067\u3059\u3002** AI\u306e\u76f4\u3057\u3092\u305d\u306e\u307e\u307e\u4f9d\u983c\u8005\u306b\u9001\u3089\u305a\u3001**\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u4e00\u5ea6\u898b\u3066\u304b\u3089\u8fd4\u3057\u307e\u3059\u3002** \u898b\u308b\u6642\u9593\u306f\u77ed\u304f\u306a\u308a\u307e\u3059\u304c\u3001\u76f4\u3057\u306e\u8cac\u4efb\u306f\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u304c\u6301\u3061\u307e\u3059\u3002","after_flow_steps":["**\u3010\u4eba\u3011** \u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u3001\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306bSQL\u3068\u76ee\u7684\u3092\u66f8\u3044\u3066\u70b9\u691c\u3092\u4f9d\u983c\u3059\u308b","**\u3010\u81ea\u52d5\u3011** \u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u304d\u3063\u304b\u3051\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u52d5\u304d\u3001SELECT\u6587\u304b\u3069\u3046\u304b\u3068\u3001\u8aad\u3093\u3067\u3044\u308b\u8868\u3092\u53d6\u308a\u51fa\u3059","**\u3010\u81ea\u52d5\u3011** \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u5217\u306e\u4e00\u89a7\u3068\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf\u306e\u5217\u3092\u3001BigQuery \u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u304b\u3089\u53d6\u308b","**\u3010\u81ea\u52d5\u3011** \u5143\u306eSQL\u3092\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u304b\u3051\u3001\u69cb\u6587\u306e\u8aa4\u308a\u3068\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u53d6\u308b","**\u3010\u81ea\u52d5\u3011** Claude API \u304c\u3001\u547d\u540d\u898f\u7d04\u3068\u6027\u80fd\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u6cbf\u3063\u3066SQL\u3092\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3092\u8fd4\u3059","**\u3010\u81ea\u52d5\u3011** \u76f4\u3057\u305f\u7248\u3092\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u304b\u3051\u3001\u69cb\u6587\u3068\u8aad\u307f\u8fbc\u3080\u91cf\u3092\u78ba\u304b\u3081\u308b","**\u3010\u81ea\u52d5\u3011** \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u306f\u3001\u77ed\u3044\u671f\u9593\u3067\u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u3092\u5b9f\u884c\u3057\u3001\u7d50\u679c\u3092\u7a81\u304d\u5408\u308f\u305b\u308b","**\u3010\u81ea\u52d5\u3011** \u70b9\u691c\u306e\u7d50\u679c\u3092\u4e00\u89a7\u306b\u66f8\u304d\u3001\u30c7\u30fc\u30bf\u62c5\u5f53\u306b\u77e5\u3089\u305b\u308b","**\u3010\u4eba\u3011** \u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u3001\u76f4\u3057\u3068\u7a81\u304d\u5408\u308f\u305b\u306e\u7d50\u679c\u3092\u78ba\u304b\u3081\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3059"],"architecture":"```\n\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\uff08SQL\u3068\u76ee\u7684\uff09\n   \u25bc\u3010\u30c8\u30ea\u30ac\u30fc\u3011\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\nGoogle Apps Script\n   \u251c\u2500\u2500 SELECT\u6587\u304b\uff0f\u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u53d6\u308a\u51fa\u3057\n   \u251c\u2500\u2500 BigQuery INFORMATION_SCHEMA.COLUMNS\uff08\u5217\u30fb\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf\uff09\n   \u251c\u2500\u2500 BigQuery \u306e\u30c9\u30e9\u30a4\u30e9\u30f3\uff08\u5143\u306eSQL\uff09\n   \u25bc\nClaude API \u2500\u2500 \u547d\u540d\u898f\u7d04\u3068\u6027\u80fd\u306e\u89b3\u70b9\u3067\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u7406\u7531\u3092\u8fd4\u3059\uff08\u69cb\u9020\u5316\u51fa\u529b\uff09\n   \u25bc\nGoogle Apps Script\n   \u251c\u2500\u2500 BigQuery \u306e\u30c9\u30e9\u30a4\u30e9\u30f3\uff08\u76f4\u3057\u305f\u7248\uff09\n   \u2514\u2500\u2500 \u77ed\u3044\u671f\u9593\u3067\u306e\u5b9f\u884c\u3068\u3001\u7d50\u679c\u306e\u7a81\u304d\u5408\u308f\u305b\uff08\u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u76f4\u3057\u306e\u3068\u304d\uff09\n   \u25bc\n\u70b9\u691c\u306e\u4e00\u89a7\uff08\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u3068\u30c7\u30fc\u30bf\u62c5\u5f53\u3078\u306e\u901a\u77e5\n   \u25bc\n\u3010\u4eba\u3011\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u78ba\u304b\u3081\u3066\u4f9d\u983c\u8005\u3078\u8fd4\u3059\n```\n\n| \u5f79\u5272 | \u60f3\u5b9a\u3059\u308b\u88fd\u54c1 | \u4ee3\u66ff\u5019\u88dc |\n|:--|:--|:--|\n| \u51e6\u7406 | Claude API\uff08\u547d\u540d\u898f\u7d04\u3068\u6027\u80fd\u306e\u89b3\u70b9\u3067\u306e\u70b9\u691c\u3001\u76f4\u3057\u305f\u7248\u3068\u7406\u7531\u306e\u4f5c\u6210\uff09 | OpenAI API\u3001Gemini API |\n| \u9023\u643a | Google Apps Script\uff08\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u8d77\u70b9\u306b\u52d5\u304b\u3057\u3001BigQuery \u3068 Claude API \u3092\u547c\u3076\uff09 | Cloud Run functions |\n| \u4fdd\u7ba1 | \u70b9\u691c\u306e\u4e00\u89a7\uff08\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u3068\u3001\u5165\u51fa\u529b\u306eJSON | BigQuery \u306e\u8a18\u9332\u7528\u306e\u8868 |\n\n**\u30c7\u30fc\u30bf\u57fa\u76e4\u3082\u793e\u5185\u306e\u6c7a\u307e\u308a\u3082\u3001\u65b0\u3057\u304f\u8db3\u3059\u3082\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002** \u8db3\u3059\u306e\u306f\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3067\u52d5\u304f\u30b9\u30af\u30ea\u30d7\u30c8\u3068\u3001**\u793e\u5185\u306e\u6c7a\u307e\u308a\u3092\u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u66f8\u304d\u76f4\u3057\u305f\u6587\u66f8**\u3067\u3059\u3002\u5171\u6709\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u6c7a\u307e\u308a\u306f\u6587\u7ae0\u3067\u66f8\u304b\u308c\u3066\u3044\u308b\u305f\u3081\u30011\u9805\u76ee\u305a\u3064\u756a\u53f7\u3092\u632f\u3063\u305f\u4e00\u89a7\u306b\u3057\u307e\u3059\u3002\n\n**\u70b9\u691c\u306e\u89b3\u70b9\u306e\u3046\u3061\u3001\u6027\u80fd\u306e\u5074\u306f BigQuery \u306e\u516c\u5f0f\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u306b\u6cbf\u3044\u307e\u3059\u3002** \u516c\u5f0f\u306b\u306f\u3001\u5fc5\u8981\u306a\u5217\u3060\u3051\u3092\u8aad\u3080\u3053\u3068\u3001**`SELECT *` \u306b LIMIT \u3092\u4ed8\u3051\u3066\u3082\u8aad\u307f\u8fbc\u3080\u91cf\u306f\u5909\u308f\u3089\u306a\u3044\u3053\u3068**\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3067\u7d5e\u308b\u3053\u3068\u3001\u7d50\u5408\u306e\u524d\u306b\u96c6\u8a08\u3057\u3066\u91cf\u3092\u6e1b\u3089\u3059\u3053\u3068\u3001\u884c\u6570\u306e\u591a\u3044\u8868\u3092\u5148\u306b\u7f6e\u304f\u3053\u3068\u306a\u3069\u304c\u6319\u3052\u3089\u308c\u3066\u3044\u307e\u3059\u3002**WITH\u53e5\u306f\u53c2\u7167\u306e\u305f\u3073\u306b\u8a55\u4fa1\u3055\u308c\u3046\u308b**\u306e\u3067\u3001\u4f55\u5ea6\u3082\u53c2\u7167\u3059\u308b\u91cd\u3044\u8a08\u7b97\u306f\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u843d\u3068\u3059\u3088\u3046\u6848\u5185\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n\n**\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u78ba\u304b\u3081\u306b\u306f\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u3092\u4f7f\u3044\u307e\u3059\u3002** \u30c9\u30e9\u30a4\u30e9\u30f3\u306f\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u305b\u305a\u3001\u69cb\u6587\u306e\u78ba\u8a8d\u3068\u51e6\u7406\u3055\u308c\u308b\u91cf\u306e\u898b\u7a4d\u3082\u308a\u3092\u8fd4\u3057\u3001**\u30b9\u30ed\u30c3\u30c8\u3092\u4f7f\u308f\u305a\u6599\u91d1\u3082\u304b\u304b\u308a\u307e\u305b\u3093\u3002** \u305f\u3060\u3057\u3001**\u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u304c\u304b\u304b\u3063\u305f\u8868\u3067\u306f\u5e38\u306b0\u30d0\u30a4\u30c8\u304c\u8fd4\u308a\u3001\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3078\u306e\u30af\u30a8\u30ea\u3067\u306f\u4e0b\u9650\u3068\u3057\u30660\u30d0\u30a4\u30c8\u304c\u8fd4\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002** \u3053\u306e2\u3064\u306f\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u6bd4\u8f03\u306b\u4f7f\u3048\u306a\u3044\u306e\u3067\u3001\u5370\u3092\u4ed8\u3051\u3066\u4eba\u306b\u56de\u3057\u307e\u3059\u3002","implementation_steps":"### \u30c8\u30ea\u30ac\u30fc\n\n**\u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u8d77\u70b9\u306b\u3057\u307e\u3059\u3002** Google Apps Script \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\u306b\u306f\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u306e\u9001\u4fe1\u3067\u52d5\u304f\u3082\u306e\u304c\u3042\u308a\u307e\u3059\u3002**\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\u306f\u3001\u4f5c\u3063\u305f\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u52d5\u304d\u307e\u3059\u3002** \u500b\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u308b\u3068\u3001\u305d\u306e\u4eba\u304c\u7570\u52d5\u3057\u305f\u3068\u304d\u306b\u6b62\u307e\u308a\u3001BigQuery \u3078\u306e\u6a29\u9650\u3082\u305d\u306e\u4eba\u306e\u3082\u306e\u306b\u306a\u308a\u307e\u3059\u3002**\u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u306e\u5171\u6709\u306e\u4f5c\u696d\u7528\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u308a\u307e\u3059\u3002**\n\n1\u56de\u306e\u9001\u4fe1\u30671\u672c\u306eSQL\u3092\u70b9\u691c\u3057\u307e\u3059\u3002**\u8907\u6570\u306eSQL\u30921\u56de\u306e\u4f9d\u983c\u306b\u307e\u3068\u3081\u3055\u305b\u307e\u305b\u3093\u3002** \u307e\u3068\u3081\u308b\u3068\u3001\u3069\u306e\u76f4\u3057\u304c\u3069\u306eSQL\u306e\u3082\u306e\u304b\u5206\u304b\u3089\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u30d5\u30a9\u30fc\u30e0\u306e\u9805\u76ee\u306f\u3001SQL\u672c\u6587\u3001\u76ee\u7684\uff08\u4f55\u306b\u4f7f\u3046\u304b\uff09\u3001\u60f3\u5b9a\u3059\u308b\u671f\u9593\u3001\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u304b\u3069\u3046\u304b\u3001\u306e4\u3064\u3067\u3059\u3002\n\nApps Script \u306e1\u56de\u306e\u5b9f\u884c\u306f6\u5206\u307e\u3067\u3067\u3059\u3002**\u70b9\u691c\u3068\u7a81\u304d\u5408\u308f\u305b\u304c6\u5206\u306b\u53ce\u307e\u3089\u306a\u3044SQL\u306f\u3001\u7a81\u304d\u5408\u308f\u305b\u3092\u5f8c\u56de\u3057\u306e\u5b9f\u884c\u306b\u5206\u3051\u307e\u3059\u3002** \u4e00\u89a7\u306b\u300c\u7a81\u304d\u5408\u308f\u305b\u5f85\u3061\u300d\u3068\u66f8\u304d\u3001\u6642\u9593\u4e3b\u5c0e\u578b\u306e\u30c8\u30ea\u30ac\u30fc\u3067\u7d9a\u304d\u3092\u52d5\u304b\u3057\u307e\u3059\u3002\n\n### \u5165\u529b\u30c7\u30fc\u30bf\n\n| \u30c7\u30fc\u30bf | \u4e2d\u8eab | \u53d6\u5f97\u5143 |\n|:--|:--|:--|\n| SQL\u672c\u6587 | \u4f9d\u983c\u8005\u304c\u66f8\u3044\u305fSELECT\u6587 | \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 |\n| \u76ee\u7684\u3068\u671f\u9593 | \u4f55\u306b\u4f7f\u3046\u304b\u3001\u3069\u306e\u671f\u9593\u306e\u30c7\u30fc\u30bf\u304b\u3001\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u304b | \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 |\n| \u8868\u306e\u60c5\u5831 | \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u5217\u306e\u540d\u524d\u3068\u578b\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3001\u30af\u30e9\u30b9\u30bf\u306e\u5217\u306e\u9806 | BigQuery \u306e `INFORMATION_SCHEMA.COLUMNS` |\n| \u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c | \u69cb\u6587\u306e\u8aa4\u308a\u306e\u6709\u7121\u3001\u51e6\u7406\u3055\u308c\u308b\u91cf | BigQuery \u306e\u30c9\u30e9\u30a4\u30e9\u30f3 |\n| \u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7 | \u547d\u540d\u898f\u7d04\uff08N-01\u301c\uff09\u3068\u6027\u80fd\u306e\u89b3\u70b9\uff08P-01\u301c\uff09\u306e\u756a\u53f7\u4ed8\u304d\u306e\u9805\u76ee | \u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u304c\u4f5c\u308b\u6587\u66f8 |\n\n**\u8cea\u3092\u6c7a\u3081\u308b\u306e\u306f\u30013\u884c\u76ee\u30685\u884c\u76ee\u3067\u3059\u3002** \u8868\u306e\u60c5\u5831\u304c\u7121\u3044\u3068\u3001AI\u306f\u3069\u306e\u5217\u304c\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u304b\u3092\u63a8\u6e2c\u3057\u3001**\u5b9f\u5728\u3057\u306a\u3044\u5217\u306e\u540d\u524d\u3067\u6761\u4ef6\u3092\u66f8\u304d\u307e\u3059\u3002** \u89b3\u70b9\u306e\u4e00\u89a7\u304c\u7121\u3044\u3068\u3001AI\u306f\u4e00\u822c\u7684\u306aSQL\u306e\u66f8\u304d\u65b9\u3067\u76f4\u3057\u3001**\u793e\u5185\u306e\u6c7a\u307e\u308a\u3068\u9055\u3046\u76f4\u3057\u3092\u8fd4\u3057\u307e\u3059\u3002**\n\n**\u76ee\u7684\u3068\u671f\u9593\u306f\u3001\u6027\u80fd\u306e\u76f4\u3057\u306e\u5224\u65ad\u306b\u4f7f\u3044\u307e\u3059\u3002** \u300c\u76f4\u8fd13\u304b\u6708\u306e\u5e97\u8217\u5225\u306e\u58f2\u4e0a\u300d\u304c\u76ee\u7684\u306a\u3089\u3001\u65e5\u4ed8\u306e\u6761\u4ef6\u304c\u7121\u3044SQL\u306f\u5168\u671f\u9593\u3092\u8aad\u3093\u3067\u3044\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002**\u76ee\u7684\u306b\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u671f\u9593\u306e\u6761\u4ef6\u3092\u3001AI\u304c\u8db3\u3059\u3053\u3068\u306f\u3055\u305b\u307e\u305b\u3093\u3002** \u8db3\u3059\u3079\u304d\u304b\u3092\u6307\u6458\u3057\u3001\u8db3\u3059\u304b\u306f\u4f9d\u983c\u8005\u304c\u6c7a\u3081\u307e\u3059\u3002\n\n### \u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u65b9\u6cd5\n\n| \u53d6\u308b\u3082\u306e | \u65b9\u6cd5 | \u6ce8\u610f |\n|:--|:--|:--|\n| \u8aad\u3093\u3067\u3044\u308b\u8868 | SQL\u672c\u6587\u304b\u3089 `FROM`\u30fb`JOIN` \u306e\u5f8c\u306e\u8868\u306e\u540d\u524d\u3092\u6b63\u898f\u8868\u73fe\u3067\u62fe\u3046 | WITH\u53e5\u306e\u540d\u524d\u306f\u8868\u304b\u3089\u9664\u304f |\n| \u5217\u306e\u4e00\u89a7 | `INFORMATION_SCHEMA.COLUMNS` \u3092\u8868\u3054\u3068\u306b\u5f15\u304f | `bigquery.tables.get` \u3068 `bigquery.tables.list` \u306e\u6a29\u9650\u304c\u8981\u308b |\n| \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf | \u540c\u3058\u30d3\u30e5\u30fc\u306e `is_partitioning_column` \u3068 `clustering_ordinal_position` | \u30af\u30e9\u30b9\u30bf\u304c\u7121\u3044\u8868\u306f `NULL` |\n| \u30c9\u30e9\u30a4\u30e9\u30f3 | BigQuery \u306e `jobs.query` \u3092 `dryRun: true` \u3067\u547c\u3076 | `useLegacySql` \u306f\u65e2\u5b9a\u304c true \u306a\u306e\u3067 false \u3092\u6307\u5b9a\u3059\u308b |\n\nApps Script \u304b\u3089\u306f\u3001BigQuery \u306e\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\u3092\u6709\u52b9\u306b\u3057\u3066\u547c\u3073\u307e\u3059\u3002\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\u306f**\u516c\u958b\u3055\u308c\u3066\u3044\u308b API \u3068\u540c\u3058\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30fb\u30e1\u30bd\u30c3\u30c9\u30fb\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u4f7f\u3046**\u3068\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001`jobs.query` \u306e `dryRun` \u3092\u305d\u306e\u307e\u307e\u6e21\u305b\u307e\u3059\u3002\n\n**`useLegacySql: false` \u3092\u5fc5\u305a\u6307\u5b9a\u3057\u307e\u3059\u3002** `jobs.query` \u306e `useLegacySql` \u306f\u65e2\u5b9a\u304c true \u3067\u3059\u3002**\u6307\u5b9a\u3092\u5fd8\u308c\u308b\u3068\u3001\u6a19\u6e96\u306eSQL\u3067\u66f8\u304b\u308c\u305fSQL\u304c\u69cb\u6587\u306e\u8aa4\u308a\u3068\u3057\u3066\u8fd4\u308a\u307e\u3059\u3002** \u8aa4\u308a\u306e\u539f\u56e0\u304cSQL\u3067\u306f\u306a\u304f\u547c\u3073\u65b9\u306b\u3042\u308b\u306e\u3067\u3001\u6c17\u3065\u304d\u306b\u304f\u3044\u5931\u6557\u3067\u3059\u3002\n\n**\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u6a29\u9650\u306f\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u95b2\u89a7\u3060\u3051\u306e\u5f79\u5272\u3067\u8db3\u308a\u307e\u3059\u3002** `INFORMATION_SCHEMA.COLUMNS` \u3092\u8aad\u3080\u306b\u306f `roles\/bigquery.metadataViewer` \u306a\u3069\u306e\u5f79\u5272\u304c\u4f7f\u3048\u307e\u3059\u3002**\u70b9\u691c\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3001\u8868\u306e\u4e2d\u8eab\u3092\u8aad\u3080\u6a29\u9650\u3092\u5e83\u304f\u6301\u305f\u305b\u307e\u305b\u3093\u3002** \u4e2d\u8eab\u3092\u8aad\u3080\u306e\u306f\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u306e\u3068\u304d\u3060\u3051\u3067\u3059\u3002\n\n### \u524d\u51e6\u7406\n\n1. **SELECT\u6587\u304b\u306e\u78ba\u8a8d** \u2026 \u5148\u982d\u304c `SELECT` \u304b `WITH` \u3067\u3001`INSERT`\u30fb`UPDATE`\u30fb`DELETE`\u30fb`MERGE`\u30fb`CREATE`\u30fb`DROP` \u3092\u542b\u307e\u306a\u3044\u3053\u3068\u3092\u78ba\u304b\u3081\u307e\u3059\u3002\u542b\u3080\u3082\u306e\u306f\u70b9\u691c\u305b\u305a\u306b\u8fd4\u3057\u307e\u3059\n2. **\u30b3\u30e1\u30f3\u30c8\u306e\u6271\u3044** \u2026 `--` \u3068 `\/* *\/` \u306e\u30b3\u30e1\u30f3\u30c8\u306f\u6b8b\u3057\u307e\u3059\u3002**\u4f9d\u983c\u8005\u306e\u610f\u56f3\u304c\u66f8\u304b\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u591a\u3044**\u304b\u3089\u3067\u3059\n3. **\u8868\u306e\u540d\u524d\u306e\u53d6\u308a\u51fa\u3057** \u2026 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30fb\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u30fb\u8868\u306e3\u3064\u306b\u5206\u3051\u3001WITH\u53e5\u306e\u540d\u524d\u3092\u9664\u304d\u307e\u3059\n4. **\u5143\u306eSQL\u306e\u30c9\u30e9\u30a4\u30e9\u30f3** \u2026 \u69cb\u6587\u306e\u8aa4\u308a\u304c\u3042\u308c\u3070\u3001\u70b9\u691c\u306e\u524d\u306b\u8aa4\u308a\u306e\u6587\u3092\u4f9d\u983c\u8005\u306b\u8fd4\u3057\u307e\u3059\n5. **\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u8a18\u9332** \u2026 \u5143\u306eSQL\u306e\u51e6\u7406\u3055\u308c\u308b\u91cf\u3092\u8a18\u9332\u3057\u307e\u3059\u3002**\u76f4\u3057\u305f\u7248\u3068\u306e\u6bd4\u8f03\u306e\u57fa\u6e96\u306b\u306a\u308a\u307e\u3059**\n6. **0\u30d0\u30a4\u30c8\u306e\u5370** \u2026 \u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u304c\u304b\u304b\u3063\u305f\u8868\u3084\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u8aad\u3080SQL\u30670\u30d0\u30a4\u30c8\u304c\u8fd4\u3063\u305f\u3089\u3001\u5370\u3092\u4ed8\u3051\u307e\u3059\n7. **\u8868\u306e\u60c5\u5831\u306e\u5727\u7e2e** \u2026 \u5217\u304c\u591a\u3044\u8868\u306f\u3001SQL\u3067\u4f7f\u3063\u3066\u3044\u308b\u5217\u3068\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30fb\u30af\u30e9\u30b9\u30bf\u306e\u5217\u3060\u3051\u306b\u7d5e\u3063\u3066\u6e21\u3057\u307e\u3059\n\n**1\u756a\u76ee\u3092AI\u306b\u4efb\u305b\u305a\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u884c\u3046\u306e\u304c\u8981\u70b9\u3067\u3059\u3002** \u66f4\u65b0\u3092\u542b\u3080SQL\u3092\u70b9\u691c\u306e\u6d41\u308c\u306b\u5165\u308c\u308b\u3068\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u3067**\u66f4\u65b0\u304c\u5b9f\u884c\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002** \u6b63\u898f\u8868\u73fe\u3067\u5f3e\u304d\u3001\u8ff7\u3046\u3082\u306e\u306f\u70b9\u691c\u3057\u307e\u305b\u3093\u3002\n\n**4\u756a\u76ee\u3067\u69cb\u6587\u306e\u8aa4\u308a\u3092\u5148\u306b\u8fd4\u3059\u306e\u3082\u3001\u540c\u3058\u7406\u7531\u3067\u3059\u3002** \u52d5\u304b\u306a\u3044SQL\u3092AI\u306b\u6e21\u3059\u3068\u3001AI\u306f\u8aa4\u308a\u3092\u76f4\u3057\u305f\u3046\u3048\u3067\u6027\u80fd\u306e\u76f4\u3057\u3092\u91cd\u306d\u3001**\u3069\u3053\u304c\u69cb\u6587\u306e\u76f4\u3057\u3067\u3069\u3053\u304c\u6027\u80fd\u306e\u76f4\u3057\u304b\u5206\u304b\u3089\u306a\u3044\u7248\u304c\u8fd4\u308a\u307e\u3059\u3002**\n\n### AI\u306b\u4f55\u3092\u3055\u305b\u308b\u306e\u304b\n\n**\u3055\u305b\u308b\u306e\u306f\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u6cbf\u3063\u3066\u554f\u984c\u3092\u62fe\u3044\u3001\u76f4\u3057\u305f\u7248\u3092\u66f8\u304d\u3001\u76f4\u3057\u3054\u3068\u306b\u89b3\u70b9\u306e\u756a\u53f7\u3068\u7406\u7531\u3068\u300c\u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u304b\u300d\u3092\u4ed8\u3051\u308b\u3053\u3068\u3067\u3059\u3002**\n\n| \u89b3\u70b9\u306e\u7a2e\u985e | \u4f8b | \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u304b |\n|:--|:--|:--|\n| \u547d\u540d\uff08N\uff09 | WITH\u53e5\u306e\u540d\u524d\u3092\u51e6\u7406\u306e\u5185\u5bb9\u304c\u5206\u304b\u308b\u540d\u524d\u306b\u3059\u308b\u3001\u5225\u540d\u3092\u8868\u306e\u7565\u79f0\u306b\u305d\u308d\u3048\u308b\u3001\u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u306b\u3059\u308b | \u5909\u308f\u3089\u306a\u3044\uff08\u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u5909\u3048\u305f\u3068\u304d\u306f\u3001\u5f8c\u308d\u306e\u51e6\u7406\u3078\u306e\u5f71\u97ff\u3092\u66f8\u304f\uff09 |\n| \u8aad\u307f\u8fbc\u3080\u5217\uff08P-01\uff09 | `SELECT *` \u3092\u4f7f\u3046\u5217\u3060\u3051\u306b\u7d5e\u308b | \u51fa\u529b\u306e\u5217\u304c\u6e1b\u308b\u306e\u3067\u5909\u308f\u308b |\n| \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\uff08P-02\uff09 | \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3067\u671f\u9593\u3092\u7d5e\u308b | \u671f\u9593\u304c\u5909\u308f\u308c\u3070\u5909\u308f\u308b |\n| \u7d50\u5408\uff08P-03\u301c\uff09 | \u7d50\u5408\u306e\u524d\u306b\u96c6\u8a08\u3059\u308b\u3001\u884c\u6570\u306e\u591a\u3044\u8868\u3092\u5148\u306b\u7f6e\u304f\u3001\u81ea\u5df1\u7d50\u5408\u3092\u30a6\u30a3\u30f3\u30c9\u30a6\u95a2\u6570\u306b\u3059\u308b | \u66f8\u304d\u65b9\u306b\u3088\u3063\u3066\u5909\u308f\u308b |\n| WITH\u53e5\uff08P-06\uff09 | \u4f55\u5ea6\u3082\u53c2\u7167\u3059\u308b\u91cd\u3044\u8a08\u7b97\u3092\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u843d\u3068\u3059\u3053\u3068\u3092\u52e7\u3081\u308b | \u5909\u308f\u3089\u306a\u3044 |\n\n**3\u5217\u76ee\u306e\u5370\u304c\u3001\u3053\u306e\u69cb\u6210\u3067\u3044\u3061\u3070\u3093\u5927\u4e8b\u306a\u533a\u5225\u3067\u3059\u3002** \u5370\u304c\u300c\u5909\u308f\u308b\u300d\u300c\u66f8\u304d\u65b9\u306b\u3088\u3063\u3066\u5909\u308f\u308b\u300d\u306e\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u3060\u3051\u30017\u756a\u76ee\u306e\u7a81\u304d\u5408\u308f\u305b\u3092\u52d5\u304b\u3057\u307e\u3059\u3002**\u547d\u540d\u306e\u76f4\u3057\u3060\u3051\u306a\u3089\u7a81\u304d\u5408\u308f\u305b\u306f\u8981\u308a\u307e\u305b\u3093\u3002**\n\n| \u3055\u305b\u306a\u3044\u3053\u3068 | \u7406\u7531 |\n|:--|:--|\n| \u696d\u52d9\u306e\u5b9a\u7fa9\u306e\u5909\u66f4 | \u58f2\u4e0a\u306b\u8fd4\u54c1\u3092\u542b\u3081\u308b\u304b\u3001\u3069\u306e\u5e97\u8217\u3092\u5bfe\u8c61\u306b\u3059\u308b\u304b\u306f\u696d\u52d9\u90e8\u9580\u304c\u6c7a\u3081\u308b |\n| \u76ee\u7684\u306b\u7121\u3044\u671f\u9593\u306e\u6761\u4ef6\u306e\u8ffd\u52a0 | \u671f\u9593\u3092\u6c7a\u3081\u308b\u306e\u306f\u4f9d\u983c\u8005\u3002\u8db3\u3059\u3079\u304d\u304b\u306e\u6307\u6458\u306b\u3068\u3069\u3081\u308b |\n| \u8868\u306e\u60c5\u5831\u306b\u7121\u3044\u5217\u306e\u4f7f\u7528 | \u5b9f\u5728\u3057\u306a\u3044\u5217\u306e\u540d\u524d\u3067\u76f4\u3055\u306a\u3044 |\n| \u66f4\u65b0\u30fb\u4f5c\u6210\u306e\u6587\u306e\u63d0\u6848 | \u70b9\u691c\u306e\u5bfe\u8c61\u306fSELECT\u6587\u3060\u3051 |\n| \u300c\u7d50\u679c\u306f\u540c\u3058\u300d\u3068\u3044\u3046\u7d50\u8ad6 | \u540c\u3058\u304b\u3069\u3046\u304b\u306f\u7a81\u304d\u5408\u308f\u305b\u3067\u78ba\u304b\u3081\u308b |\n\n**5\u884c\u76ee\u304c\u3044\u3061\u3070\u3093\u8d77\u304d\u3084\u3059\u3044\u5931\u6557\u3067\u3059\u3002** \u66f8\u304d\u63db\u3048\u305f\u7406\u7531\u306b\u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u6dfb\u3048\u308b\u306e\u306f\u81ea\u7136\u306a\u66f8\u304d\u65b9\u3067\u3059\u304c\u3001**\u305d\u306e\u4e00\u6587\u3092\u4fe1\u3058\u3066\u7a81\u304d\u5408\u308f\u305b\u3092\u7701\u304f\u3068\u3001\u7b2c3\u7ae0\u306e\uff08c\uff09\u304c\u305d\u306e\u307e\u307e\u8d77\u304d\u307e\u3059\u3002**\n\n### \u30d7\u30ed\u30f3\u30d7\u30c8\u307e\u305f\u306f\u6307\u793a\u5185\u5bb9\u306e\u4f8b\n\n```\n\u3042\u306a\u305f\u306f\u793e\u5185\u306e\u30c7\u30fc\u30bf\u57fa\u76e4\u30c1\u30fc\u30e0\u3067\u3001\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u66f8\u3044\u305fSELECT\u6587\u3092\n\u70b9\u691c\u3059\u308b\u62c5\u5f53\u8005\u3092\u624b\u4f1d\u3046\u7acb\u5834\u3067\u3059\u3002\n\u6e21\u3055\u308c\u305f\u300c\u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u300d\u306b\u6cbf\u3063\u3066SQL\u3092\u70b9\u691c\u3057\u3001\u76f4\u3057\u305f\u7248\u3068\u3001\n\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3092\u8fd4\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n\n\u3010\u53b3\u5b88\u4e8b\u9805\u3011\n- \u76f4\u3057\u306f\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u8f09\u3063\u3066\u3044\u308b\u9805\u76ee\u306b\u5f53\u305f\u308b\u3082\u306e\u3060\u3051\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n  \u4e00\u89a7\u306b\u7121\u3044\u597d\u307f\u306e\u66f8\u304d\u65b9\u3067\u76f4\u3055\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76f4\u3057\u3054\u3068\u306b rule_id\uff08N-01 \u3084 P-02\uff09\u3092\u5fc5\u305a\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- \u8868\u306e\u60c5\u5831\u306b\u8f09\u3063\u3066\u3044\u306a\u3044\u5217\u306e\u540d\u524d\u3092\u4f7f\u308f\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u696d\u52d9\u306e\u5b9a\u7fa9\uff08\u4f55\u3092\u58f2\u4e0a\u3068\u3059\u308b\u304b\u3001\u3069\u306e\u5e97\u8217\u30fb\u4f1a\u54e1\u3092\u5bfe\u8c61\u306b\u3059\u308b\u304b\uff09\u3092\u5909\u3048\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76ee\u7684\u306b\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u671f\u9593\u306e\u6761\u4ef6\u3092\u8db3\u3055\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n  \u671f\u9593\u306e\u6761\u4ef6\u304c\u7121\u3044\u3053\u3068\u304c\u554f\u984c\u306a\u3089\u3001notes \u306b\u6307\u6458\u3068\u3057\u3066\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- \u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u76f4\u3057\u306b\u306f result_may_change \u3092 true \u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n  LEFT JOIN \u306e\u76f8\u624b\u306e\u8868\u306e\u6761\u4ef6\u3092 ON \u3068 WHERE \u306e\u9593\u3067\u52d5\u304b\u3059\u76f4\u3057\u3001\n  SELECT * \u3092\u5217\u306e\u6307\u5b9a\u306b\u5909\u3048\u308b\u76f4\u3057\u3001DISTINCT \u3092\u5916\u3059\u76f4\u3057\u3001\n  \u96c6\u8a08\u306e\u4f4d\u7f6e\u3092\u52d5\u304b\u3059\u76f4\u3057\u306f\u3001\u5fc5\u305a true \u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n- \u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u66f8\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\u7d50\u679c\u304c\u540c\u3058\u304b\u3069\u3046\u304b\u306f\n  \u5225\u306e\u624b\u9806\u3067\u78ba\u304b\u3081\u307e\u3059\u3002\n- before \u306b\u306f\u5143\u306eSQL\u306e\u8a72\u5f53\u90e8\u5206\u3092\u4e00\u5b57\u4e00\u53e5\u305d\u306e\u307e\u307e\u5199\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n- \u7406\u7531\uff08reason\uff09\u306f\u3001\u4f9d\u983c\u8005\u304c\u6b21\u306b\u540c\u3058\u66f8\u304d\u65b9\u3092\u3057\u306a\u3044\u3067\u6e08\u3080\u3088\u3046\u306b\u3001\n  2\u6587\u4ee5\u5185\u3067\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n- SELECT\u6587\u4ee5\u5916\u306e\u6587\uff08INSERT\u3001UPDATE\u3001CREATE \u306a\u3069\uff09\u3092\u66f8\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\n- \u76f4\u3059\u7b87\u6240\u304c\u7121\u3051\u308c\u3070\u3001changes \u3092\u7a7a\u306b\u3057\u3066 revised_sql \u306b\u5143\u306eSQL\u3092\u5165\u308c\u3066\u304f\u3060\u3055\u3044\u3002\n\n\u3010\u70b9\u691c\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u3011{rules}\n\u3010SQL\u672c\u6587\u3011{sql}\n\u3010\u76ee\u7684\u3068\u671f\u9593\u3011{purpose}\n\u3010\u8868\u306e\u60c5\u5831\uff08\u5217\u3001\u578b\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3001\u30af\u30e9\u30b9\u30bf\uff09\u3011{table_info}\n\u3010\u5143\u306eSQL\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c\uff08\u51e6\u7406\u3055\u308c\u308b\u91cf\uff09\u3011{dry_run}\n```\n\n**\u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u3068\u66f8\u304b\u306a\u3044\u300d\u3092\u660e\u8a18\u3057\u306a\u3044\u3068\u3001\u7406\u7531\u306e\u307b\u307c\u3059\u3079\u3066\u306b\u4ed8\u304d\u307e\u3059\u3002** \u4f9d\u983c\u8005\u3092\u5b89\u5fc3\u3055\u305b\u308b\u66f8\u304d\u65b9\u3068\u3057\u3066\u81ea\u7136\u306b\u51fa\u3066\u304d\u307e\u3059\u3002**\u7981\u3058\u308b\u306e\u306f\u3001\u78ba\u304b\u3081\u3066\u3044\u306a\u3044\u3053\u3068\u3092\u78ba\u304b\u3081\u305f\u3088\u3046\u306b\u66f8\u304f\u3053\u3068\u3067\u3059\u3002**\n\n**`before` \u3092\u4e00\u5b57\u4e00\u53e5\u3067\u5199\u3055\u305b\u308b\u306e\u306f\u3001\u5f8c\u3067\u7167\u3089\u3059\u305f\u3081\u3067\u3059\u3002** \u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u5143\u306eSQL\u306e\u4e2d\u306b `before` \u306e\u6587\u5b57\u5217\u304c\u3042\u308b\u304b\u3092\u78ba\u304b\u3081\u3001**\u898b\u3064\u304b\u3089\u306a\u3044\u76f4\u3057\u306f\u4e00\u89a7\u304b\u3089\u5916\u3057\u3066\u5370\u3092\u4ed8\u3051\u307e\u3059\u3002**\n\n### \u51fa\u529b\u5f62\u5f0f\n\n**Claude API \u306e\u69cb\u9020\u5316\u51fa\u529b\u3067\u3001\u6b21\u306e\u5f62\u306eJSON\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002**\n\n```json\n{\n  \"revised_sql\": \"\",\n  \"changes\": [\n    {\n      \"rule_id\": \"P-02\",\n      \"category\": \"naming | performance\",\n      \"before\": \"\",\n      \"after\": \"\",\n      \"reason\": \"\",\n      \"result_may_change\": true\n    }\n  ],\n  \"notes\": [\n    { \"kind\": \"missing_date_filter | business_definition | other\", \"text\": \"\" }\n  ]\n}\n```\n\n**1\u3064\u76ee\u306e\u7406\u7531\u306f\u3001`rule_id` \u3067\u6307\u6458\u3092\u89b3\u70b9\u306e\u4e00\u89a7\u306b\u7d50\u3073\u4ed8\u3051\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** \u4e00\u89a7\u306b\u7121\u3044\u756a\u53f7\u306e\u76f4\u3057\u306f\u53d7\u3051\u4ed8\u3051\u307e\u305b\u3093\u3002**\u3069\u306e\u6c7a\u307e\u308a\u306b\u57fa\u3065\u304f\u76f4\u3057\u304b\u304c\u3001\u4f9d\u983c\u8005\u306b\u3082\u898b\u3048\u307e\u3059\u3002** \u7406\u7531\u306e\u5f8c\u308d\u306b\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u8a72\u5f53\u9805\u76ee\u3078\u306e\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u3066\u8fd4\u3057\u307e\u3059\u3002\n\n**2\u3064\u76ee\u306f\u3001`result_may_change` \u3067\u7a81\u304d\u5408\u308f\u305b\u306e\u8981\u5426\u3092\u6c7a\u3081\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** 1\u3064\u3067\u3082 true \u304c\u3042\u308c\u3070\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u7a81\u304d\u5408\u308f\u305b\u3092\u52d5\u304b\u3057\u307e\u3059\u3002\n\n**3\u3064\u76ee\u306f\u3001`notes` \u3092\u76f4\u3057\u3068\u5206\u3051\u3089\u308c\u308b\u3053\u3068\u3067\u3059\u3002** \u671f\u9593\u306e\u6761\u4ef6\u304c\u7121\u3044\u3053\u3068\u3084\u3001\u696d\u52d9\u306e\u5b9a\u7fa9\u306b\u95a2\u308f\u308b\u7591\u554f\u306f\u3001**\u76f4\u3055\u305a\u306b\u4f9d\u983c\u8005\u3078\u306e\u554f\u3044\u3068\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002**\n\n\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3001AI\u306e\u51fa\u529b\u306e\u5f8c\u306b\u6b21\u306e3\u3064\u3092\u6a5f\u68b0\u3067\u78ba\u304b\u3081\u3001\u70b9\u691c\u306e\u533a\u5206\u3092\u6c7a\u3081\u307e\u3059\u3002\n\n| \u533a\u5206 | \u6761\u4ef6 |\n|:--|:--|\n| \u8fd4\u5374\u53ef | \u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u6210\u529f\u3057\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u304c\u5143\u3088\u308a\u5897\u3048\u3066\u304a\u3089\u305a\u3001\u7a81\u304d\u5408\u308f\u305b\u304c\u4e0d\u8981\u304b\u5dee\u304c0\u884c |\n| \u8981\u78ba\u8a8d | \u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u305f\u3001`before` \u304c\u5143\u306eSQL\u306b\u898b\u3064\u304b\u3089\u306a\u3044\u30010\u30d0\u30a4\u30c8\u306e\u5370\u304c\u3042\u308b |\n| \u5dee\u3057\u623b\u3057 | \u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u5931\u6557\u3057\u305f |\n\n\u7a81\u304d\u5408\u308f\u305b\u306f\u3001\u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u306e\u4e21\u65b9\u306b**\u540c\u30581\u65e5\u5206\u306e\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u6761\u4ef6**\u3092\u8db3\u3057\u3066\u5b9f\u884c\u3057\u3001`EXCEPT DISTINCT` \u3067\u53cc\u65b9\u5411\u306e\u5dee\u306e\u884c\u6570\u3092\u6570\u3048\u307e\u3059\u3002\u5b9f\u884c\u306b\u306f `maximumBytesBilled` \u3092\u4ed8\u3051\u307e\u3059\u3002`jobs.query` \u306e\u8aac\u660e\u3067\u306f\u3001**\u3053\u306e\u4e0a\u9650\u3092\u8d85\u3048\u308b\u30af\u30a8\u30ea\u306f\u6599\u91d1\u304c\u304b\u304b\u3089\u305a\u306b\u5931\u6557\u3059\u308b**\u3068\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n\n```sql\n-- \u7a81\u304d\u5408\u308f\u305b\u306e\u5b9a\u578b\uff08{orig} \u3068 {revised} \u306f1\u65e5\u5206\u306e\u6761\u4ef6\u3092\u8db3\u3057\u305f\u3082\u306e\uff09\nWITH a AS ({orig}), b AS ({revised})\nSELECT\n  (SELECT COUNT(*) FROM (SELECT * FROM a EXCEPT DISTINCT SELECT * FROM b)) AS only_in_orig,\n  (SELECT COUNT(*) FROM (SELECT * FROM b EXCEPT DISTINCT SELECT * FROM a)) AS only_in_revised\n```\n\n**\u5217\u306e\u4e26\u3073\u304c\u5909\u308f\u308b\u76f4\u3057\u3067\u306f\u3001\u3053\u306e\u6bd4\u8f03\u304c\u901a\u308a\u307e\u305b\u3093\u3002** \u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3084\u9806\u3092\u5909\u3048\u305f\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u306f\u3001\u7a81\u304d\u5408\u308f\u305b\u306e\u524d\u306b\u3001\u5143\u306eSQL\u306e\u5217\u306e\u4e26\u3073\u306b\u5408\u308f\u305b\u3066\u76f4\u3057\u305f\u7248\u3092\u5305\u307f\u76f4\u3057\u307e\u3059\u3002\n\n### \u30b7\u30b9\u30c6\u30e0\u9023\u643a\n\n| \u3064\u306a\u304e\u5148 | \u65b9\u5f0f | \u5185\u5bb9 |\n|:--|:--|:--|\n| \u5171\u6709\u306e\u30d5\u30a9\u30fc\u30e0 | Apps Script \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc | \u4f9d\u983c\u306e\u53d7\u3051\u4ed8\u3051 |\n| BigQuery | Apps Script \u306e\u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\uff08`jobs.query`\uff09 | \u30e1\u30bf\u30c7\u30fc\u30bf\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u3001\u7a81\u304d\u5408\u308f\u305b\u306e\u5b9f\u884c |\n| Claude API | `UrlFetchApp` \u304b\u3089 Messages API | \u70b9\u691c\u3068\u76f4\u3057\u305f\u7248\u306e\u4f5c\u6210 |\n| \u70b9\u691c\u306e\u4e00\u89a7 | \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u306e\u8ffd\u8a18 | \u533a\u5206\u3001\u76f4\u3057\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u6bd4\u8f03 |\n| \u30c7\u30fc\u30bf\u62c5\u5f53 | Google Chat \u307e\u305f\u306f\u30e1\u30fc\u30eb | \u300c\u8981\u78ba\u8a8d\u300d\u300c\u5dee\u3057\u623b\u3057\u300d\u3092\u5148\u306b\u77e5\u3089\u305b\u308b |\n\nApps Script \u306e `UrlFetchApp` \u306f\u3001Google Workspace \u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u30671\u65e510\u4e07\u56de\u307e\u3067\u547c\u3079\u307e\u3059\u3002**\u6708240\u4ef6\u306e\u70b9\u691c\u306a\u3089\u4e0a\u9650\u306b\u5c4a\u304d\u307e\u305b\u3093\u3002** \u30c8\u30ea\u30ac\u30fc\u306e\u5408\u8a08\u306e\u5b9f\u884c\u6642\u9593\u306f1\u65e56\u6642\u9593\u307e\u3067\u3067\u30011\u4ef6\u306e\u70b9\u691c\u306f\u6570\u5341\u79d2\u3067\u7d42\u308f\u308b\u60f3\u5b9a\u3067\u3059\u3002\n\n\u4f9d\u983c\u8005\u3078\u306e\u8fd4\u5374\u306f\u3001**\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u4e00\u89a7\u306e\u884c\u304b\u3089\u9001\u308a\u307e\u3059\u3002** \u8fd4\u3059\u6587\u9762\u306b\u306f\u3001\u76f4\u3057\u305f\u7248\u3001\u76f4\u3057\u3054\u3068\u306e\u7406\u7531\u3068\u89b3\u70b9\u306e\u756a\u53f7\u3001\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u5909\u5316\uff08\u4f8b\uff1a\u5143 820GB \u2192 \u76f4\u3057\u305f\u7248 36GB\uff09\u3001`notes` \u306e\u554f\u3044\u3092\u4e26\u3079\u307e\u3059\u3002**\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u5909\u5316\u3092\u6570\u5b57\u3067\u8fd4\u3059\u3068\u3001\u4f9d\u983c\u8005\u304c\u76f4\u3057\u3092\u53d7\u3051\u5165\u308c\u308b\u7406\u7531\u306b\u306a\u308a\u307e\u3059\u3002**\n\n### \u4eba\u9593\u306e\u78ba\u8a8d\n\n1. **\u300c\u8981\u78ba\u8a8d\u300d\u3068\u300c\u5dee\u3057\u623b\u3057\u300d\u3092\u5148\u306b\u898b\u308b** \u2026 \u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u305f\u3082\u306e\u306f\u3001\u3069\u306e\u76f4\u3057\u304c\u5dee\u3092\u751f\u3093\u3060\u304b\u3092\u898b\u307e\u3059\n2. **`result_may_change` \u304c true \u306e\u76f4\u3057\u3092\u8aad\u3080** \u2026 \u5dee\u304c0\u884c\u3067\u3082\u30011\u65e5\u5206\u3067\u306f\u51fa\u306a\u304b\u3063\u305f\u3060\u3051\u306e\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002**\u6708\u672b\u3084\u795d\u65e5\u306e\u6761\u4ef6\u306b\u95a2\u308f\u308b\u76f4\u3057\u306f\u3001\u5225\u306e\u65e5\u3067\u3082\u7a81\u304d\u5408\u308f\u305b\u307e\u3059**\n3. **`notes` \u306e\u554f\u3044\u3092\u78ba\u304b\u3081\u308b** \u2026 \u671f\u9593\u306e\u6761\u4ef6\u3084\u696d\u52d9\u306e\u5b9a\u7fa9\u306e\u7591\u554f\u306f\u3001\u4f9d\u983c\u8005\u306b\u805e\u304f\u5f62\u3067\u8fd4\u3057\u307e\u3059\n4. **\u547d\u540d\u306e\u76f4\u3057\u306f\u6d41\u3057\u898b\u308b** \u2026 \u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u5909\u3048\u305f\u76f4\u3057\u306f\u3001\u5f8c\u308d\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3084\u30ec\u30dd\u30fc\u30c8\u304c\u5217\u306e\u540d\u524d\u3067\u53c2\u7167\u3057\u3066\u3044\u306a\u3044\u304b\u3092\u4f9d\u983c\u8005\u306b\u78ba\u304b\u3081\u307e\u3059\n5. **AI\u306e\u76f4\u3057\u3092\u8986\u3057\u305f\u3089\u8a18\u9332\u3059\u308b** \u2026 \u89b3\u70b9\u306e\u4e00\u89a7\u306e\u66f8\u304d\u65b9\u3092\u76f4\u3059\u6750\u6599\u306b\u3057\u307e\u3059\n\n**2\u756a\u76ee\u3092\u7701\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002** 1\u65e5\u5206\u306e\u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c0\u884c\u3067\u3082\u3001**\u6708\u3092\u307e\u305f\u3050\u6761\u4ef6\u3084\u3001\u7279\u5b9a\u306e\u66dc\u65e5\u306b\u3057\u304b\u7121\u3044\u30c7\u30fc\u30bf\u3067\u306f\u5dee\u304c\u51fa\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002** \u7a81\u304d\u5408\u308f\u305b\u306f\u300c\u5dee\u304c\u7121\u3044\u3053\u3068\u306e\u8a3c\u660e\u300d\u3067\u306f\u306a\u304f\u3001**\u300c\u5dee\u304c\u3042\u308b\u3053\u3068\u3092\u898b\u3064\u3051\u308b\u7db2\u300d**\u3067\u3059\u3002\n\n**\u76ee\u6a19\u306f\u3001240\u4ef6\u3092\u306a\u3089\u3057\u30661\u4ef65\u5206\u3067\u3059\u3002** \u300c\u8fd4\u5374\u53ef\u300d\u306f\u76f4\u3057\u3092\u6d41\u3057\u898b\u3066\u8fd4\u3057\u3001\u300c\u8981\u78ba\u8a8d\u300d\u306b\u6642\u9593\u3092\u4f7f\u3044\u307e\u3059\u3002\n\n### \u4f8b\u5916\u51e6\u7406\n\n| \u8d77\u304d\u308b\u3053\u3068 | \u5bfe\u5fdc |\n|:--|:--|\n| SELECT\u6587\u3067\u306a\u3044 | \u70b9\u691c\u305b\u305a\u3001\u300c\u70b9\u691c\u306e\u5bfe\u8c61\u5916\u300d\u3068\u4f9d\u983c\u8005\u306b\u8fd4\u3059 |\n| \u5143\u306eSQL\u304c\u69cb\u6587\u306e\u8aa4\u308a | \u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u8aa4\u308a\u306e\u6587\u3092\u8fd4\u3057\u3001\u76f4\u3057\u3066\u304b\u3089\u51fa\u3057\u76f4\u3057\u3066\u3082\u3089\u3046 |\n| \u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u6a29\u9650\u304c\u70b9\u691c\u7528\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u7121\u3044 | \u300c\u8981\u78ba\u8a8d\u300d\u3002\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u6a29\u9650\u306e\u4ed8\u4e0e\u304b\u3092\u5224\u65ad\u3059\u308b |\n| 0\u30d0\u30a4\u30c8\u304c\u8fd4\u3063\u305f\uff08\u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30fb\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\uff09 | \u8aad\u307f\u8fbc\u3080\u91cf\u306e\u6bd4\u8f03\u3092\u305b\u305a\u3001\u300c\u8981\u78ba\u8a8d\u300d |\n| `before` \u304c\u5143\u306eSQL\u306b\u898b\u3064\u304b\u3089\u306a\u3044 | \u305d\u306e\u76f4\u3057\u3092\u5916\u3057\u3001\u300c\u8981\u78ba\u8a8d\u300d |\n| \u7a81\u304d\u5408\u308f\u305b\u304c `maximumBytesBilled` \u3067\u6b62\u307e\u308b | \u671f\u9593\u3092\u3055\u3089\u306b\u77ed\u304f\u3059\u308b\u304b\u3001\u7a81\u304d\u5408\u308f\u305b\u3092\u4eba\u306b\u56de\u3059 |\n| 6\u5206\u3092\u8d85\u3048\u305d\u3046 | \u7a81\u304d\u5408\u308f\u305b\u3092\u5f8c\u56de\u3057\u306e\u5b9f\u884c\u306b\u5206\u3051\u308b |\n| \u69cb\u9020\u5316\u51fa\u529b\u304c `refusal` \u3084 `max_tokens` \u3067\u7d42\u308f\u308b | \u53d7\u3051\u4ed8\u3051\u305a\u3001`max_tokens` \u3092\u4e0a\u3052\u3066\u518d\u5b9f\u884c\u3002\u7d9a\u3051\u3070\u4eba\u3078 |\n\n### \u4fdd\u5b58\u30fb\u30ed\u30b0\n\n- \u4f9d\u983c\u306e\u65e5\u6642\u3001\u4f9d\u983c\u8005\u3001SQL\u672c\u6587\u3001\u76ee\u7684\u3068\u671f\u9593\n- \u6e21\u3057\u305f\u8868\u306e\u60c5\u5831\u3068\u3001\u305d\u306e\u3068\u304d\u306e\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u7248\n- \u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u7d50\u679c\uff08\u51e6\u7406\u3055\u308c\u308b\u91cf\uff09\n- Claude API \u306e\u51fa\u529b\u306e\u5168\u6587\u3068\u3001\u7167\u5408\u3067\u5916\u3057\u305f\u76f4\u3057\n- \u7a81\u304d\u5408\u308f\u305b\u306e\u6761\u4ef6\uff08\u65e5\u4ed8\uff09\u3068\u3001\u53cc\u65b9\u5411\u306e\u5dee\u306e\u884c\u6570\n- \u30c7\u30fc\u30bf\u62c5\u5f53\u306e\u6700\u7d42\u306e\u5224\u65ad\u3001\u8986\u3057\u305f\u76f4\u3057\u3001\u4f9d\u983c\u8005\u306b\u8fd4\u3057\u305f\u65e5\u6642\n\n**\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u7248\u3092\u6b8b\u3059\u306e\u306f\u3001\u6c7a\u307e\u308a\u304c\u5f8c\u304b\u3089\u5909\u308f\u308b\u305f\u3081\u3067\u3059\u3002** \u547d\u540d\u306e\u6c7a\u307e\u308a\u3092\u5909\u3048\u308b\u3068\u904e\u53bb\u306e\u76f4\u3057\u306e\u610f\u5473\u304c\u5909\u308f\u308a\u3001**\u5f53\u6642\u306e\u6c7a\u307e\u308a\u304c\u6b8b\u3063\u3066\u3044\u306a\u3044\u3068\u3001\u306a\u305c\u305d\u306e\u76f4\u3057\u3092\u3057\u305f\u304b\u304c\u8ffd\u3048\u307e\u305b\u3093\u3002**\n\n**\u4f9d\u983c\u8005\u3054\u3068\u306e\u6307\u6458\u306e\u591a\u3044\u89b3\u70b9\u3082\u3001\u6708\u306b1\u56de\u6570\u3048\u307e\u3059\u3002** \u540c\u3058\u89b3\u70b9\u3067\u6bce\u6708\u76f4\u3055\u308c\u3066\u3044\u308b\u4eba\u306b\u306f\u3001**\u70b9\u691c\u3067\u8fd4\u3059\u3088\u308a\u3001\u77ed\u3044\u52c9\u5f37\u4f1a\u3067\u4f1d\u3048\u305f\u307b\u3046\u304c\u65e9\u304f\u6e1b\u308a\u307e\u3059\u3002**","minimal_setup":"1. \u904e\u53bb2\u304b\u6708\u306b\u70b9\u691c\u3057\u305fSQL\u304b\u308920\u672c\u3092\u9078\u3076\uff08**\u76f4\u3057\u305f\u3089\u7d50\u679c\u304c\u5909\u308f\u3063\u3066\u3057\u307e\u3063\u305f\u4f8b\u3092\u542b\u3081\u308b**\uff09\n2. \u793e\u5185\u306eSQL\u306e\u66f8\u304d\u65b9\u306e\u6c7a\u307e\u308a\u3092\u3001\u756a\u53f7\u4ed8\u304d\u306e\u89b3\u70b9\u306e\u4e00\u89a7\uff08N-01\u301c\u3001P-01\u301c\uff09\u306b\u66f8\u304d\u76f4\u3059\n3. 1\u672c\u305a\u3064\u3001\u8aad\u3093\u3067\u3044\u308b\u8868\u306e\u5217\u306e\u4e00\u89a7\u3068\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u5217\u3092\u624b\u3067\u66f8\u304d\u51fa\u3059\n4. \u624b\u5143\u306eAI\u30b5\u30fc\u30d3\u30b9\u306b\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u30fbSQL\u30fb\u8868\u306e\u60c5\u5831\u3092\u6e21\u3057\u3001\u300c\u4e00\u89a7\u306e\u9805\u76ee\u306b\u5f53\u305f\u308b\u76f4\u3057\u3060\u3051\u3092\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u76f4\u3057\u3054\u3068\u306b\u756a\u53f7\u3068\u7406\u7531\u3092\u66f8\u304d\u3001\u7d50\u679c\u304c\u5909\u308f\u308a\u3046\u308b\u304b\u3092\u66f8\u3044\u3066\u304f\u3060\u3055\u3044\u3002\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u3068\u66f8\u304b\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u300d\u3068\u6307\u793a\u3059\u308b\n5. \u51fa\u3066\u304d\u305f\u76f4\u3057\u3092\u3001\u5f53\u6642\u30c7\u30fc\u30bf\u62c5\u5f53\u304c\u8fd4\u3057\u305f\u76f4\u3057\u3068\u6bd4\u3079\u3001\u76f4\u3057\u305f\u7248\u3092\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u304b\u3051\u308b\n\n| \u51fa\u3066\u304d\u305f\u5185\u5bb9 | \u5224\u65ad |\n|:--|:--|\n| \u5f53\u6642\u306e\u62c5\u5f53\u3068\u540c\u3058\u76f4\u3057\u304c\u51fa\u3066\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u901a\u3063\u305f | **\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3064\u306a\u3050** |\n| \u4e00\u89a7\u306b\u7121\u3044\u597d\u307f\u306e\u76f4\u3057\u304c\u6df7\u3056\u308b | \u6307\u793a\u3068\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u66f8\u304d\u65b9\u3067\u76f4\u308b\u3002**\u69cb\u6210\u306f\u6709\u52b9** |\n| \u7d50\u679c\u304c\u5909\u308f\u308b\u76f4\u3057\u306b\u5370\u304c\u4ed8\u304b\u306a\u3044 | **\u7a81\u304d\u5408\u308f\u305b\u3092\u5fc5\u305a\u5165\u308c\u308b\u524d\u63d0\u3067\u9032\u3081\u308b** |\n\n**3\u884c\u76ee\u304c\u51fa\u3066\u3082\u3001\u3084\u3081\u308b\u7406\u7531\u306b\u306f\u306a\u308a\u307e\u305b\u3093\u3002** \u7b2c7\u7ae0\u3067\u7a81\u304d\u5408\u308f\u305b\u3092\u6a5f\u68b0\u3067\u884c\u3046\u306e\u306f\u3001AI\u306e\u5370\u3092\u5f53\u3066\u306b\u3057\u306a\u3044\u305f\u3081\u3067\u3059\u3002","minimal_setup_short":"\u89b3\u70b9\u306e\u4e00\u89a7\u3068\u8868\u306e\u60c5\u5831\u3092\u624b\u3067\u4f5c\u308a\u3001\u624b\u5143\u306eAI\u3067SQL\u3092\u70b9\u691c\u3055\u305b\u308b \uff0f 1\u672c\u3054\u3068\u306e\u70b9\u691c\u3068\u76f4\u3057","semi_auto_setup":"\u4e0a\u8a18\uff0b\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3067\u52d5\u304d\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u30fb\u30c9\u30e9\u30a4\u30e9\u30f3\u30fb\u7a81\u304d\u5408\u308f\u305b\u30fb\u4e00\u89a7\u3078\u306e\u8a18\u9332\u307e\u3067\u884c\u3046 \uff0f \u70b9\u691c\u304b\u3089\u78ba\u8a8d\u306e\u624b\u524d\u307e\u3067","full_setup":"\u4e0a\u8a18\uff0b\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306eSQL\u3092\u4fdd\u5b58\u3059\u308b\u5834\u6240\u3092\u898b\u5f35\u308a\u3001\u7d44\u307f\u8fbc\u307e\u308c\u308b\u524d\u306b\u5fc5\u305a\u70b9\u691c\u3092\u901a\u3059 \uff0f \u70b9\u691c\u306e\u6f0f\u308c\u306e\u9632\u6b62\u307e\u3067","level_note":"**\u534a\u81ea\u52d5\u5316\u3067\u30011\u4ef615\u5206\u304c5\u5206\u306b\u306a\u308a\u3001\u3053\u306e\u6bb5\u968e\u304c\u672c\u8a18\u4e8b\u306e\u60f3\u5b9a\u3067\u3059\u3002** \u30c7\u30fc\u30bf\u62c5\u5f53\u306e\u624b\u5143\u306b\u6b8b\u308b\u306e\u306f\u3001\u76f4\u3057\u3068\u7a81\u304d\u5408\u308f\u305b\u306e\u7d50\u679c\u3092\u78ba\u304b\u3081\u3066\u8fd4\u3059\u4f5c\u696d\u3067\u3059\u3002\n**\u672c\u683c\u69cb\u6210\u306f\u3001\u70b9\u691c\u3092\u901a\u3055\u305a\u306b\u7d44\u307f\u8fbc\u307e\u308c\u308bSQL\u3092\u7121\u304f\u3059\u305f\u3081\u306e\u6bb5\u968e\u3067\u3059\u3002** \u6642\u9593\u306f\u5927\u304d\u304f\u5909\u308f\u308a\u307e\u305b\u3093\u304c\u3001**\u7b2c3\u7ae0\u306e\uff08a\uff09\u3067\u5f85\u3061\u304d\u308c\u305a\u306b\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u305fSQL\u304c\u3001\u70b9\u691c\u306e\u5916\u306b\u51fa\u306a\u304f\u306a\u308a\u307e\u3059\u3002** \u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u3055\u308c\u305f\u30af\u30a8\u30ea\u306e\u4e00\u89a7\u3092\u6bce\u65e5\u5f15\u304d\u3001\u70b9\u691c\u306e\u8a18\u9332\u306b\u7121\u3044SQL\u3092\u77e5\u3089\u305b\u308b\u5f62\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002\n**\u6bb5\u968e\u3092\u98db\u3070\u3055\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002** \u534a\u81ea\u52d5\u5316\u306e1\u304b\u6708\u3067\u3001\u89b3\u70b9\u306e\u4e00\u89a7\u306e\u66f8\u304d\u65b9\u306e\u3042\u3044\u307e\u3044\u3055\u3068\u3001\u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u3084\u3059\u3044\u76f4\u3057\u306e\u578b\u304c\u5206\u304b\u308a\u307e\u3059\u3002","troubleshooting":"| \u554f\u984c | \u5bfe\u7b56 |\n|:--|:--|\n| \u76f4\u3057\u3067\u7d50\u679c\u304c\u5909\u308f\u308b | `result_may_change` \u306b\u983c\u3089\u305a\u3001\u6027\u80fd\u306e\u76f4\u3057\u3092\u542b\u3080\u3068\u304d\u306f\u7a81\u304d\u5408\u308f\u305b\u308b |\n| \u300c\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u300d\u3068\u66f8\u304f | \u6307\u793a\u3067\u7981\u3058\u308b\u3002\u66f8\u304b\u308c\u3066\u3044\u3066\u3082\u7a81\u304d\u5408\u308f\u305b\u306f\u7701\u304b\u306a\u3044 |\n| \u5b9f\u5728\u3057\u306a\u3044\u5217\u3067\u76f4\u3059 | \u8868\u306e\u60c5\u5831\u3092\u6e21\u3057\u3001\u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u3067\u5f3e\u304f |\n| \u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u69cb\u6587\u306e\u8aa4\u308a\u3092\u8fd4\u3059 | `useLegacySql: false` \u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u304b\u3092\u5148\u306b\u898b\u308b |\n| 0\u30d0\u30a4\u30c8\u304c\u8fd4\u308b | \u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30fb\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u5370\u3092\u4ed8\u3051\u3001\u6bd4\u8f03\u3057\u306a\u3044 |\n| \u66f4\u65b0\u3092\u542b\u3080SQL\u304c\u6d41\u308c\u308b | \u524d\u51e6\u7406\u3067\u5f3e\u304f\u3002**\u70b9\u691c\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u66f8\u304d\u8fbc\u307f\u306e\u6a29\u9650\u3092\u6301\u305f\u305b\u306a\u3044** |\n| \u30c8\u30ea\u30ac\u30fc\u304c\u6b62\u307e\u308b | \u500b\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u3089\u306a\u3044\u3002\u5171\u6709\u306e\u4f5c\u696d\u7528\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f5c\u308b |\n| \u597d\u307f\u306e\u76f4\u3057\u304c\u6df7\u3056\u308b | \u89b3\u70b9\u306e\u4e00\u89a7\u306b\u7121\u3044 `rule_id` \u306e\u76f4\u3057\u3092\u53d7\u3051\u4ed8\u3051\u306a\u3044 |\n| \u51fa\u529b\u306e\u5217\u306e\u540d\u524d\u3092\u5909\u3048\u3066\u5f8c\u308d\u304c\u58ca\u308c\u308b | \u5217\u306e\u540d\u524d\u306e\u76f4\u3057\u306f\u3001\u53c2\u7167\u5148\u306e\u78ba\u8a8d\u3092\u4f9d\u983c\u8005\u306b\u6c42\u3081\u308b |\n\n**\u4e0a\u306e2\u884c\u304c\u3001\u3053\u306e\u69cb\u6210\u306e\u5931\u6557\u306e\u307b\u3068\u3093\u3069\u3067\u3059\u3002** \u3069\u3061\u3089\u3082\u3001AI\u304c\u7d50\u679c\u306e\u540c\u4e00\u6027\u3092\u4fdd\u8a3c\u3067\u304d\u308b\u3068\u6271\u3063\u305f\u3068\u304d\u306b\u8d77\u304d\u307e\u3059\u3002**\u540c\u4e00\u6027\u306f\u3001\u5b9f\u884c\u3057\u3066\u6570\u3048\u308b\u3082\u306e\u3067\u3059\u3002**","governance_notes":"**\u3053\u306e\u69cb\u6210\u3067\u6271\u3046\u30c7\u30fc\u30bf\uff1a** SQL\u672c\u6587\u3001\u8868\u3068\u5217\u306e\u540d\u524d\u3068\u578b\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u51e6\u7406\u91cf\u3001\u7a81\u304d\u5408\u308f\u305b\u3067\u6570\u3048\u305f\u5dee\u306e\u884c\u6570\u3067\u3059\u3002**\u8868\u306e\u4e2d\u8eab\uff08\u58f2\u4e0a\u30fb\u4f1a\u54e1\u306e\u5024\uff09\u306f Claude API \u306b\u9001\u308a\u307e\u305b\u3093\u3002**\n\n1. **\u9001\u308b\u306e\u306fSQL\u3068\u30e1\u30bf\u30c7\u30fc\u30bf\u3060\u3051\u306b\u3059\u308b** \u2026 \u7a81\u304d\u5408\u308f\u305b\u306e\u7d50\u679c\u306f\u884c\u6570\u3060\u3051\u3092\u6271\u3044\u3001**\u5dee\u306e\u884c\u305d\u306e\u3082\u306e\u3092 AI \u306b\u6e21\u3057\u307e\u305b\u3093**\n2. **SQL\u306e\u30b3\u30e1\u30f3\u30c8\u3084\u6761\u4ef6\u306e\u5024\u306b\u500b\u4eba\u306e\u60c5\u5831\u304c\u7121\u3044\u304b\u3092\u898b\u308b** \u2026 \u7279\u5b9a\u306e\u4f1a\u54e1\u756a\u53f7\u3084\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u6761\u4ef6\u306b\u66f8\u3044\u305fSQL\u306f\u3001**\u5024\u3092\u4f0f\u305b\u3066\u304b\u3089\u9001\u308b**\u304b\u3001\u70b9\u691c\u306e\u5bfe\u8c61\u5916\u306b\u3057\u307e\u3059\n3. **\u70b9\u691c\u7528\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u6a29\u9650\u3092\u7d5e\u308b** \u2026 \u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u95b2\u89a7\u3068\u3001\u7a81\u304d\u5408\u308f\u305b\u306b\u8981\u308b\u8868\u306e\u8aad\u307f\u53d6\u308a\u3060\u3051\u306b\u3057\u3001**\u66f8\u304d\u8fbc\u307f\u30fb\u8868\u306e\u4f5c\u6210\u306e\u6a29\u9650\u3092\u6301\u305f\u305b\u307e\u305b\u3093**\n4. **\u7a81\u304d\u5408\u308f\u305b\u306b\u6599\u91d1\u306e\u4e0a\u9650\u3092\u4ed8\u3051\u308b** \u2026 `maximumBytesBilled` \u3092\u5fc5\u305a\u6307\u5b9a\u3057\u3001\u4e0a\u9650\u3092\u8d85\u3048\u305f\u3089\u6b62\u307e\u308b\u3088\u3046\u306b\u3057\u307e\u3059\n5. **\u76f4\u3057\u305f\u7248\u3092\u81ea\u52d5\u3067\u7d44\u307f\u8fbc\u307e\u306a\u3044** \u2026 \u8fd4\u3059\u306e\u306f\u76f4\u3057\u305f\u7248\u306e\u6848\u307e\u3067\u3067\u3001**\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u306e\u306f\u4f9d\u983c\u8005\u3068\u30c7\u30fc\u30bf\u62c5\u5f53\u306e\u5224\u65ad\u3067\u3059**\n6. **\u8868\u3068\u5217\u306e\u540d\u524d\u306e\u6271\u3044\u3092\u898f\u7a0b\u3067\u78ba\u304b\u3081\u308b** \u2026 \u8868\u306e\u540d\u524d\u306b\u53d6\u5f15\u5148\u540d\u3084\u65bd\u7b56\u540d\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u304d\u306f\u3001\u5916\u90e8\u306e API \u306b\u9001\u3063\u3066\u3088\u3044\u304b\u3092\u5148\u306b\u6c7a\u3081\u307e\u3059\n\n\u8aa4\u308a\u304c\u8d77\u304d\u305f\u5834\u5408\u306e\u30ea\u30b9\u30af\u306f\u3001**\u7d50\u679c\u304c\u5909\u308f\u3063\u305f\u76f4\u3057\u3092\u4f7f\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3068\u3001SQL\u306b\u542b\u307e\u308c\u305f\u60c5\u5831\u304c\u5916\u306b\u51fa\u308b\u3053\u3068\u306e2\u3064\u3067\u3059\u3002** \u524d\u8005\u306f\u7a81\u304d\u5408\u308f\u305b\u3068\u4eba\u306e\u78ba\u8a8d\u3067\u3001\u5f8c\u8005\u306f\u9001\u308b\u7bc4\u56f2\u306e\u9650\u5b9a\u3067\u9632\u304e\u307e\u3059\u3002","recommended_for":"BigQuery \u306b\u30c7\u30fc\u30bf\u57fa\u76e4\u3092\u7f6e\u304d\u3001\u55b6\u696d\u4f01\u753b\u30fb\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u30fb\u5e97\u8217\u904b\u55b6\u306a\u3069\u306e\u696d\u52d9\u90e8\u9580\u306e\u62c5\u5f53\u8005\u304c\u81ea\u5206\u3067SQL\u3092\u66f8\u3044\u3066\u30c7\u30fc\u30bf\u3092\u629c\u304d\u51fa\u3057\u3066\u3044\u308b\u4f1a\u793e\u3002\u5b9a\u671f\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u7d44\u307f\u8fbc\u3080\u524d\u3084\u3001\u5927\u304d\u306a\u8868\u3092\u8aad\u3080\u524d\u306b\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u306e\u30c7\u30fc\u30bf\u62c5\u5f53\u304cSQL\u3092\u898b\u3066\u3044\u308b\u304c\u3001\u898b\u308b\u4eba\u304c2\u301c3\u540d\u306b\u9650\u3089\u308c\u3066\u5f85\u3061\u304c\u51fa\u3066\u3044\u308b\u5834\u5408\u3002\u793e\u5185\u306eSQL\u306e\u66f8\u304d\u65b9\u306e\u6c7a\u307e\u308a\uff08\u547d\u540d\u30fb\u5225\u540d\u30fb\u65e5\u4ed8\u306e\u6271\u3044\uff09\u3092\u6587\u66f8\u306b\u3067\u304d\u308b\u5834\u5408\u3002","not_recommended_for":"\u696d\u52d9\u90e8\u9580\u304cSQL\u3092\u66f8\u304b\u305a\u3001\u62bd\u51fa\u306f\u3059\u3079\u3066\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u304c\u884c\u3063\u3066\u3044\u308b\u5834\u5408\u3002\u66f4\u65b0\u30fb\u524a\u9664\u30fb\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3092\u4f34\u3046SQL\u306e\u70b9\u691c\uff08\u5b9f\u884c\u524d\u306e\u5b89\u5168\u78ba\u8a8d\u306f\u5225\u306e\u4ed5\u7d44\u307f\u304c\u8981\u308a\u307e\u3059\uff09\u3002\u8868\u306e\u540d\u524d\u3084\u5217\u306e\u540d\u524d\u305d\u306e\u3082\u306e\u304c\u5916\u90e8\u306b\u51fa\u305b\u306a\u3044\u60c5\u5831\u306b\u5f53\u305f\u308a\u3001\u751f\u6210AI\u306eAPI\u306b\u9001\u308b\u3053\u3068\u304c\u793e\u5185\u306e\u898f\u7a0b\u3067\u8a8d\u3081\u3089\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u3002\u306a\u304a\u3001\u629c\u304d\u51fa\u3057\u305f\u6570\u5b57\u304c\u696d\u52d9\u306e\u5b9a\u7fa9\u3068\u3057\u3066\u6b63\u3057\u3044\u304b\uff08\u58f2\u4e0a\u306b\u8fd4\u54c1\u3092\u542b\u3081\u308b\u304b\u7b49\uff09\u306e\u5224\u65ad\u306f\u3001\u3053\u306e\u69cb\u6210\u3067\u306f\u4ee3\u66ff\u3067\u304d\u307e\u305b\u3093\u3002","first_step":"**1\u9031\u76ee\uff1a\u89b3\u70b9\u306e\u4e00\u89a7\u3092\u4f5c\u308b**\n\n\u793e\u5185\u306eSQL\u306e\u66f8\u304d\u65b9\u306e\u6c7a\u307e\u308a\u3092\u3001**\u547d\u540d\uff08N-01\u301c\uff09\u3068\u6027\u80fd\uff08P-01\u301c\uff09\u306e\u756a\u53f7\u4ed8\u304d\u306e\u9805\u76ee\u306b\u66f8\u304d\u76f4\u3057\u307e\u3059\u3002** \u6027\u80fd\u306e\u5074\u306f BigQuery \u306e\u516c\u5f0f\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u304b\u3089\u3001\u81ea\u793e\u306e\u8868\u3067\u52b9\u304f\u3082\u306e\u3092\u9078\u3073\u307e\u3059\u3002\n\n**2\u9031\u76ee\uff1a20\u672c\u3067\u8a66\u3059**\n\n\u904e\u53bb\u306b\u70b9\u691c\u3057\u305fSQL\u304b\u308920\u672c\u3092\u9078\u3073\u3001\u624b\u5143\u306eAI\u3067\u70b9\u691c\u3055\u305b\u307e\u3059\u3002**\u76f4\u3057\u305f\u3089\u7d50\u679c\u304c\u5909\u308f\u3063\u305f\u4f8b\u306b\u3001\u5370\u304c\u4ed8\u304f\u304b\u3068\u3001\u7a81\u304d\u5408\u308f\u305b\u3067\u5dee\u304c\u51fa\u308b\u304b\u3092\u6700\u512a\u5148\u3067\u898b\u307e\u3059\u3002**\n\n**3\u9031\u76ee\uff1a\u30d5\u30a9\u30fc\u30e0\u304b\u3089\u30c9\u30e9\u30a4\u30e9\u30f3\u307e\u3067\u3092\u3064\u306a\u3050**\n\nApps Script \u3067\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3092\u53d7\u3051\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3001\u5143\u306eSQL\u3068\u76f4\u3057\u305f\u7248\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u3001\u4e00\u89a7\u3078\u306e\u8a18\u9332\u307e\u3067\u3092\u4f5c\u308a\u307e\u3059\u3002**\u3053\u306e\u6642\u70b9\u3067\u306f\u7a81\u304d\u5408\u308f\u305b\u3092\u52d5\u304b\u3055\u305a\u3001\u76f4\u3057\u3068\u8aad\u307f\u8fbc\u3080\u91cf\u306e\u5909\u5316\u3060\u3051\u3092\u898b\u307e\u3059\u3002**\n\n**4\u9031\u76ee\uff1a\u7a81\u304d\u5408\u308f\u305b\u3092\u8db3\u3059**\n\n1\u65e5\u5206\u306e\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3067\u306e\u7a81\u304d\u5408\u308f\u305b\u3068 `maximumBytesBilled` \u3092\u8db3\u3057\u3001\u533a\u5206\u3092\u51fa\u3057\u307e\u3059\u3002\n\n**2\u304b\u6708\u76ee\uff1a** \u3059\u3079\u3066\u306e\u4f9d\u983c\u3092\u3053\u306e\u6d41\u308c\u306b\u4e57\u305b\u3001\u300c\u8981\u78ba\u8a8d\u300d\u306e\u4ef6\u6570\u3068\u8986\u3057\u305f\u76f4\u3057\u3092\u6bce\u9031\u6570\u3048\u307e\u3059\u3002**3\u304b\u6708\u76ee\u4ee5\u964d\uff1a** \u4f9d\u983c\u8005\u3054\u3068\u306e\u6307\u6458\u306e\u591a\u3044\u89b3\u70b9\u3092\u6570\u3048\u3066\u52c9\u5f37\u4f1a\u306e\u984c\u6750\u306b\u3057\u30011\u4ef615\u5206\u304c\u4f55\u5206\u306b\u306a\u3063\u305f\u304b\u3092\u5b9f\u6e2c\u3057\u307e\u3059\u3002**\u540c\u3058\u6307\u6458\u304c\u6bce\u6708\u304f\u308a\u8fd4\u3055\u308c\u306a\u304f\u306a\u3063\u305f\u6642\u70b9\u3067\u3001\u3053\u306e\u69cb\u6210\u306f\u5b8c\u6210\u3067\u3059\u3002**\n\n---","related_usecases":["UC-1472","UC-0931","UC-0742","UC-0241"],"related_articles":[{"id":4088,"slug":"junni-keisoku-hendo-ai","title":"\u691c\u7d22\u9806\u4f4d\u306f\u6bce\u65e5\u30c1\u30a7\u30c3\u30af\u3059\u3079\u304d\uff1f\uff5c\u5909\u52d5\u306e\u898b\u65b9\u3068\u76f4\u3057\u65b9"},{"id":3912,"slug":"factcheck-taisei-content-ai","title":"\u8a18\u4e8b\u306e\u30d5\u30a1\u30af\u30c8\u30c1\u30a7\u30c3\u30af5\u5de5\u7a0b\uff5c\u8aa4\u60c5\u5831\u3092\u4e16\u306b\u51fa\u3055\u306a\u3044"},{"id":4995,"slug":"kokoku-unei-shukan","title":"\u5e83\u544a\u904b\u7528\u306e\u9031\u6b21\u30c1\u30a7\u30c3\u30af\u9805\u76ee\u4e00\u89a7\uff5c\u898b\u843d\u3068\u3057\u3092\u4ed5\u7d44\u307f\u3067\u9632\u3050"}],"sources":"| \u78ba\u8a8d\u3057\u305f\u5185\u5bb9 | \u60c5\u5831\u6e90 | \u78ba\u8a8d\u65e5 |\n|:--|:--|:--|\n| \u5fc5\u8981\u306a\u5217\u3060\u3051\u3092\u8aad\u3080\u3053\u3068\u3001`SELECT *` \u306b LIMIT \u3092\u4ed8\u3051\u3066\u3082\u8aad\u307f\u8fbc\u3080\u91cf\u306f\u5909\u308f\u3089\u306a\u3044\u3053\u3068\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3067\u7d5e\u308b\u3053\u3068\u3001\u7d50\u5408\u306e\u524d\u306b\u96c6\u8a08\u3059\u308b\u3053\u3068\u3001\u884c\u6570\u306e\u591a\u3044\u8868\u3092\u5148\u306b\u7f6e\u304f\u3053\u3068\u3001WITH\u53e5\u304c\u53c2\u7167\u306e\u305f\u3073\u306b\u8a55\u4fa1\u3055\u308c\u3046\u308b\u3053\u3068\u3001\u81ea\u5df1\u7d50\u5408\u306e\u4ee3\u308f\u308a\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u95a2\u6570\u3092\u4f7f\u3046\u3053\u3068 | [Google Cloud: Optimize query computation](https:\/\/docs.cloud.google.com\/bigquery\/docs\/best-practices-performance-compute) | 2026-10-14 |\n| \u30c9\u30e9\u30a4\u30e9\u30f3\u304c\u69cb\u6587\u306e\u78ba\u8a8d\u3068\u51e6\u7406\u91cf\u306e\u898b\u7a4d\u3082\u308a\u3092\u8fd4\u3057\u3001\u30b9\u30ed\u30c3\u30c8\u3092\u4f7f\u308f\u305a\u6599\u91d1\u304c\u304b\u304b\u3089\u306a\u3044\u3053\u3068\u3001\u884c\u30ec\u30d9\u30eb\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8868\u3067\u306f\u5e38\u306b0\u30d0\u30a4\u30c8\u3001\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3067\u306f\u4e0b\u9650\u3068\u3057\u30660\u30d0\u30a4\u30c8\u304c\u8fd4\u308b\u3053\u3068\u304c\u3042\u308b\u3053\u3068 | [Google Cloud: Run a query](https:\/\/docs.cloud.google.com\/bigquery\/docs\/running-queries) | 2026-10-14 |\n| `jobs.query` \u306e `dryRun`\u3001`totalBytesProcessed`\u3001`maximumBytesBilled`\uff08\u4e0a\u9650\u3092\u8d85\u3048\u308b\u3068\u6599\u91d1\u304c\u304b\u304b\u3089\u305a\u306b\u5931\u6557\uff09\u3001`useLegacySql` \u306e\u65e2\u5b9a\u304c true \u3067\u3042\u308b\u3053\u3068 | [Google Cloud: Method jobs.query](https:\/\/docs.cloud.google.com\/bigquery\/docs\/reference\/rest\/v2\/jobs\/query) | 2026-10-14 |\n| `INFORMATION_SCHEMA.COLUMNS` \u306e `is_partitioning_column`\u30fb`clustering_ordinal_position`\u3001\u8aad\u3080\u306e\u306b\u8981\u308b\u6a29\u9650\u3068\u5f79\u5272 | [Google Cloud: COLUMNS view](https:\/\/docs.cloud.google.com\/bigquery\/docs\/information-schema-columns) | 2026-10-14 |\n| Apps Script \u306e BigQuery \u62e1\u5f35\u30b5\u30fc\u30d3\u30b9\u304c\u6709\u52b9\u5316\u304c\u8981\u308a\u3001\u516c\u958b\u3055\u308c\u3066\u3044\u308b API \u3068\u540c\u3058\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30fb\u30e1\u30bd\u30c3\u30c9\u30fb\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u4f7f\u3046\u3053\u3068 | [Google Apps Script: BigQuery Service](https:\/\/developers.google.com\/apps-script\/advanced\/bigquery) | 2026-10-14 |\n| \u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u3067\u52d5\u304f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\u304c\u3042\u308a\u3001\u4f5c\u3063\u305f\u4eba\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u52d5\u304f\u3053\u3068 | [Google Apps Script: Installable triggers](https:\/\/developers.google.com\/apps-script\/guides\/triggers\/installable) | 2026-10-14 |\n| 1\u56de\u306e\u5b9f\u884c\u304c6\u5206\u307e\u3067\u3001Workspace \u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067 URL Fetch \u304c1\u65e510\u4e07\u56de\u3001\u30c8\u30ea\u30ac\u30fc\u306e\u5408\u8a08\u5b9f\u884c\u6642\u9593\u304c1\u65e56\u6642\u9593\u3067\u3042\u308b\u3053\u3068 | [Google Apps Script: Quotas](https:\/\/developers.google.com\/apps-script\/guides\/services\/quotas) | 2026-10-14 |\n| \u69cb\u9020\u5316\u51fa\u529b\u3092 `output_config.format` \u3067\u6307\u5b9a\u3059\u308b\u3053\u3068\u3001`refusal`\u30fb`max_tokens` \u3067\u7d42\u308f\u308b\u3068\u30b9\u30ad\u30fc\u30de\u306b\u5408\u308f\u306a\u3044\u3053\u3068\u304c\u3042\u308b\u3053\u3068 | [Claude: Structured outputs](https:\/\/platform.claude.com\/docs\/en\/build-with-claude\/structured-outputs) | 2026-10-14 |\n\n**\u76f4\u3057\u305f\u7248\u3092\u4f7f\u3046\u304b\u3069\u3046\u304b\u3068\u3001\u629c\u304d\u51fa\u3057\u305f\u6570\u5b57\u304c\u696d\u52d9\u306e\u5b9a\u7fa9\u3068\u3057\u3066\u6b63\u3057\u3044\u304b\u306e\u5224\u65ad\u306f\u3001\u30c7\u30fc\u30bf\u62c5\u5f53\u3068\u4f9d\u983c\u8005\u304c\u884c\u3063\u3066\u304f\u3060\u3055\u3044\u3002** \u672c\u8a18\u4e8b\u306f\u4e0a\u306e\u516c\u958b\u60c5\u5831\u3067\u78ba\u8a8d\u3067\u304d\u305f\u7bc4\u56f2\u3060\u3051\u3092\u6271\u3063\u3066\u3044\u307e\u3059\u3002\n\n**\u5b9f\u88c5\u30b9\u30c6\u30fc\u30bf\u30b9\uff1a\u69cb\u6210\u4f8b\u3002** \u516c\u958b\u4ed5\u69d8\u306b\u57fa\u3065\u3044\u3066\u8a2d\u8a08\u3057\u305f\u69cb\u6210\u3067\u3042\u308a\u3001\u5f53\u793e\u3067\u5b9f\u969b\u306b\u69cb\u7bc9\u30fb\u691c\u8a3c\u3057\u305f\u3082\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u5de5\u6570\u306e\u6570\u5024\u306f\u30e2\u30c7\u30eb\u6761\u4ef6\u306b\u3088\u308b\u8a66\u7b97\u3067\u3059\u3002","featured":false,"priority_score":50,"footnotes":""},"uc_ai_model":[123,122,124],"uc_ai_service":[],"uc_automation":[137],"uc_industry":[23,25,22,26],"uc_department":[48],"uc_task":[60,55],"uc_issue":[71,70,72],"uc_effect":[79,78,84],"uc_ai_function":[99],"class_list":["post-15356","ai_usecase","type-ai_usecase","status-publish","hentry","uc_ai_model-chatgpt","uc_ai_model-claude","uc_ai_model-gemini","uc_automation-apps-script","uc_industry-ec","uc_industry-it-saas","uc_industry-retail","uc_industry-finance","uc_department-it-dept","uc_task-review-check","uc_task-document-creation","uc_issue-short-staffed","uc_issue-person-dependent","uc_issue-check-errors","uc_effect-standardization","uc_effect-hours-saved","uc_effect-lower-training-cost","uc_ai_function-proofreading"],"_links":{"self":[{"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/ai_usecase\/15356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/ai_usecase"}],"about":[{"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/types\/ai_usecase"}],"author":[{"embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":0,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/ai_usecase\/15356\/revisions"}],"wp:attachment":[{"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/media?parent=15356"}],"wp:term":[{"taxonomy":"uc_ai_model","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_ai_model?post=15356"},{"taxonomy":"uc_ai_service","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_ai_service?post=15356"},{"taxonomy":"uc_automation","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_automation?post=15356"},{"taxonomy":"uc_industry","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_industry?post=15356"},{"taxonomy":"uc_department","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_department?post=15356"},{"taxonomy":"uc_task","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_task?post=15356"},{"taxonomy":"uc_issue","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_issue?post=15356"},{"taxonomy":"uc_effect","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_effect?post=15356"},{"taxonomy":"uc_ai_function","embeddable":true,"href":"https:\/\/debono.co.jp\/media\/wp-json\/wp\/v2\/uc_ai_function?post=15356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}