{"id":23776,"date":"2025-11-15T11:15:38","date_gmt":"2025-11-15T11:15:38","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=23776"},"modified":"2025-11-15T11:15:38","modified_gmt":"2025-11-15T11:15:38","slug":"bigquery-%e3%81%ae-dry-run-%e3%81%a8%e5%ae%9f%e9%9a%9b%e3%81%ae%e3%82%b9%e3%82%ad%e3%83%a3%e3%83%b3%e9%87%8f%e3%81%8c%e7%95%b0%e3%81%aa%e3%82%8b%e3%82%b1%e3%83%bc%e3%82%b9%e3%81%be%e3%81%a8%e3%82%81","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/23776\/","title":{"rendered":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081"},"content":{"rendered":"\n<\/p>\n<div>\n<h2 id=\"%E8%A8%98%E4%BA%8B%E3%81%AE%E5%86%85%E5%AE%B9\" data-line=\"0\" class=\"code-line\">\n \u8a18\u4e8b\u306e\u5185\u5bb9<\/h2>\n<p data-line=\"2\" class=\"code-line\">BigQuery \u306e dry run \u306f\u5b9f\u884c\u524d\u306b\u30af\u30a8\u30ea\u30b9\u30ad\u30e3\u30f3\u91cf\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\u305f\u3060\u3057\u69d8\u3005\u306a\u30b1\u30fc\u30b9\u3067 dry run \u3067\u63d0\u793a\u3055\u308c\u308b\u30b9\u30ad\u30e3\u30f3\u91cf\u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308a\u307e\u3059\u3002<br \/>\u3053\u306e\u8a18\u4e8b\u3067\u306f dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u4e56\u96e2\u3057\u3066\u3044\u308b\u30b1\u30fc\u30b9\u3092\u691c\u8a3c\u3057\u3066\u307e\u3068\u3081\u307e\u3057\u305f\u3002<\/p>\n<h2 id=\"%E8%A8%98%E4%BA%8B%E3%82%92%E6%9B%B8%E3%81%84%E3%81%9F%E5%8B%95%E6%A9%9F\" data-line=\"6\" class=\"code-line\">\n \u8a18\u4e8b\u3092\u66f8\u3044\u305f\u52d5\u6a5f<\/h2>\n<p data-line=\"8\" class=\"code-line\">\u6700\u8fd1 AI \u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u306b BigQuery \u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u3092\u4efb\u305b\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u9ad8\u30b3\u30b9\u30c8\u306a\u30af\u30a8\u30ea\u3092\u9023\u6295\u3055\u308c\u308b\u3068\u56f0\u308b\u305f\u3081\u3001\u30b3\u30b9\u30c8\u306b\u5fdc\u3058\u3066\u51e6\u7406\u3092\u5206\u5c90\u3059\u308b\u3053\u3068\u3092\u8003\u3048\u3066\u3044\u307e\u3059\u3002<br \/>\u305d\u306e\u6642\u306b dry run \u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u3042\u308b\u7a0b\u5ea6\u30b3\u30b9\u30c8\u3092\u4e88\u6e2c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\u3057\u304b\u3057 dry run \u3068\u5b9f\u969b\u306e\u30b3\u30b9\u30c8\u304c\u4e56\u96e2\u3059\u308b\u5834\u5408\u304c\u3042\u308b\u3053\u3068\u3092\u7d4c\u9a13\u3057\u3066\u304a\u308a\u3001\u3053\u308c\u3092\u6a5f\u306b\u4e00\u901a\u308a\u8abf\u3079\u3066\u304a\u304d\u305f\u3044\u3068\u601d\u3044\u3001\u3064\u3044\u3067\u306b\u8abf\u3079\u305f\u5185\u5bb9\u3092\u8a18\u4e8b\u3068\u3057\u3066\u516c\u958b\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<h2 id=\"dry-run-%E3%81%A8%E3%81%AF\" data-line=\"12\" class=\"code-line\">\n dry run \u3068\u306f<\/h2>\n<p data-line=\"14\" class=\"code-line\">\u7c21\u5358\u306b dry run \u306e\u6a5f\u80fd\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p data-line=\"16\" class=\"code-line\"><a target=\"_blank\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/running-queries?hl=ja#dry-run\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">BigQuery \u306e\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a>\u306b\u3088\u308b\u3068\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<blockquote data-line=\"18\" class=\"code-line\">\n<ul data-line=\"18\" class=\"code-line\">\n<li data-line=\"18\" class=\"code-line\">\u30aa\u30f3\u30c7\u30de\u30f3\u30c9 \u30e2\u30fc\u30c9\u3067\u306e\u6599\u91d1\u306e\u898b\u7a4d\u3082\u308a<\/li>\n<li data-line=\"19\" class=\"code-line\">\u30af\u30a8\u30ea\u306e\u691c\u8a3c<\/li>\n<li data-line=\"20\" class=\"code-line\">\u30ad\u30e3\u30d1\u30b7\u30c6\u30a3 \u30e2\u30fc\u30c9\u3067\u30af\u30a8\u30ea\u306b\u3088\u3063\u3066\u51e6\u7406\u3055\u308c\u305f\u304a\u304a\u3088\u305d\u306e\u30d0\u30a4\u30c8\u6570<\/li>\n<\/ul>\n<p data-line=\"22\" class=\"code-line\">\u30c9\u30e9\u30a4\u30e9\u30f3\u306f\u30af\u30a8\u30ea\u30b9\u30ed\u30c3\u30c8\u3092\u4f7f\u7528\u3057\u306a\u3044\u305f\u3081\u3001\u30c9\u30e9\u30a4\u30e9\u30f3\u306e\u5b9f\u884c\u306b\u5bfe\u3057\u3066\u306f\u8ab2\u91d1\u3055\u308c\u307e\u305b\u3093\u3002\u30c9\u30e9\u30a4\u30e9\u30f3\u306b\u3088\u3063\u3066\u8fd4\u3055\u308c\u305f\u898b\u7a4d\u3082\u308a\u3092\u6599\u91d1\u8a08\u7b97\u30c4\u30fc\u30eb\u3067\u4f7f\u7528\u3059\u308b\u3068\u3001\u30af\u30a8\u30ea\u306e\u8cbb\u7528\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<p data-line=\"24\" class=\"code-line\">\u3053\u306e\u3088\u3046\u306b\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3067\u304d\u308b\u304b\u691c\u8a3c\u3057\u305f\u308a\u3001\u6599\u91d1\u3092\u898b\u7a4d\u3082\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u305f\u3081\u3001AI \u306e\u751f\u6210\u3057\u305f\u30af\u30a8\u30ea\u3092\u691c\u8a3c\u3059\u308b\u306e\u306b\u3082\u3063\u3066\u3053\u3044\u306e\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n<p data-line=\"26\" class=\"code-line\">dry run \u306f BigQuery \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 <code>\u3053\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u25ef\u25ef B \u304c\u51e6\u7406\u3055\u308c\u307e\u3059\u3002<\/code> \u3068\u8868\u793a\u3055\u308c\u308b\u4ed6\u3001 bq \u30b3\u30de\u30f3\u30c9\u3084\u5404\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30e9\u30a4\u30d6\u30e9\u30ea\u304b\u3089\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<h2 id=\"%E4%B8%8B%E6%BA%96%E5%82%99\" data-line=\"28\" class=\"code-line\">\n \u4e0b\u6e96\u5099<\/h2>\n<p data-line=\"30\" class=\"code-line\">\u307e\u305a\u306f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"32\"><span class=\"token operator\">-<\/span> \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u4f5c\u6210\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">SCHEMA<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test<span class=\"token punctuation\">`<\/span><\/span>\nOPTIONS<span class=\"token punctuation\">(<\/span>\n  location <span class=\"token operator\">=<\/span> <span class=\"token string\">'asia-northeast1'<\/span><span class=\"token punctuation\">,<\/span>\n  default_partition_expiration_days <span class=\"token operator\">=<\/span> <span class=\"token boolean\">NULL<\/span>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"41\" class=\"code-line\">\u7d9a\u3044\u3066\u30b5\u30f3\u30d7\u30eb\u306e\u57fa\u672c\u3068\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\u5f8c\u307b\u3069\u691c\u8a3c\u306b\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u3042\u308b\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u30c6\u30fc\u30d6\u30eb\u306b\u3057\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"44\">\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token operator\">OR<\/span> <span class=\"token keyword\">REPLACE<\/span> <span class=\"token keyword\">TABLE<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span>\n<span class=\"token keyword\">PARTITION<\/span> <span class=\"token keyword\">BY<\/span>\n  usage_date\nCLUSTER <span class=\"token keyword\">BY<\/span> category_id\nOPTIONS <span class=\"token punctuation\">(<\/span>partition_expiration_days <span class=\"token operator\">=<\/span> <span class=\"token boolean\">NULL<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token keyword\">DATE<\/span><span class=\"token punctuation\">(<\/span>TIMESTAMP_ADD<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">TIMESTAMP<\/span> <span class=\"token string\">'2025-01-01 00:00:00'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">INTERVAL<\/span> x <span class=\"token keyword\">SECOND<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> usage_date<span class=\"token punctuation\">,<\/span>\n  TIMESTAMP_ADD<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">TIMESTAMP<\/span> <span class=\"token string\">'2025-01-01 00:00:00'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">INTERVAL<\/span> x <span class=\"token keyword\">SECOND<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> usage_timestamp<span class=\"token punctuation\">,<\/span>\n  <span class=\"token function\">MOD<\/span><span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">,<\/span> <span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> category_id<span class=\"token punctuation\">,<\/span>\n  CONCAT<span class=\"token punctuation\">(<\/span><span class=\"token string\">'value_'<\/span><span class=\"token punctuation\">,<\/span> CAST<span class=\"token punctuation\">(<\/span><span class=\"token function\">MOD<\/span><span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">,<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> STRING<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> value_text <span class=\"token keyword\">FROM<\/span> UNNEST<span class=\"token punctuation\">(<\/span>GENERATE_ARRAY<span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1000000<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> x \n<span class=\"token keyword\">CROSS<\/span> <span class=\"token keyword\">JOIN<\/span> <span class=\"token punctuation\">(<\/span>\n  <span class=\"token keyword\">SELECT<\/span>\n    y\n  <span class=\"token keyword\">FROM<\/span>\n    UNNEST<span class=\"token punctuation\">(<\/span>GENERATE_ARRAY<span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> y <span class=\"token punctuation\">)<\/span> \n <span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"64\" class=\"code-line\">\u3053\u308c\u30671\u5104\u884c\u306e 3GB \u304f\u3089\u3044\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u51fa\u6765\u4e0a\u304c\u308a\u307e\u3057\u305f\u3002<\/p>\n<p data-line=\"66\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/82da0c667358-20251024.png\" alt=\"\u30c6\u30fc\u30d6\u30eb\u306e\u6982\u8981\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"68\" class=\"code-line\">\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u898b\u308b\u3068\u3053\u3093\u306a\u611f\u3058\u3067\u3059\u3002<br \/><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/3f6bfed740c7-20251024.png\" alt=\"\u30c6\u30fc\u30d6\u30eb\u306e\u30d7\u30ec\u30d3\u30e5\u30fc\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"71\" class=\"code-line\">usage_date \u306b\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3092\u3001category_id \u306b\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u3092\u5165\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"73\" class=\"code-line\">\u3053\u306e\u5f8c\u3082\u5fc5\u8981\u306a\u30b5\u30f3\u30d7\u30eb\u304c\u3042\u308c\u3070\u90fd\u5ea6\u30c6\u30fc\u30d6\u30eb\u7b49\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p data-line=\"75\" class=\"code-line\">\u306a\u304a\u3001\u30b9\u30af\u30b7\u30e7\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u304c\u66f8\u3044\u3066\u3042\u3063\u305f\u308a\u96a0\u3055\u308c\u305f\u308a\u3057\u3066\u307e\u3059\u304c\u691c\u8a3c\u5f8c\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306f\u524a\u9664\u3057\u305f\u306e\u3067\u66f8\u3044\u3066\u3042\u3063\u3066\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<h2 id=\"dry-run-%3E-%E5%AE%9F%E9%9A%9B\" data-line=\"77\" class=\"code-line\">\n dry run &gt; \u5b9f\u969b<\/h2>\n<h3 id=\"%E3%82%AF%E3%83%A9%E3%82%B9%E3%82%BF%E5%8C%96%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB\" data-line=\"79\" class=\"code-line\">\n \u30af\u30e9\u30b9\u30bf\u5316\u30c6\u30fc\u30d6\u30eb<\/h3>\n<p data-line=\"81\" class=\"code-line\"><a target=\"_blank\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/clustered-tables?hl=ja\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30af\u30e9\u30b9\u30bf\u5316\u30c6\u30fc\u30d6\u30eb\u306e\u6982\u8981<\/a>\u306b\u6b21\u306e\u8a18\u8f09\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<blockquote data-line=\"83\" class=\"code-line\">\n<p data-line=\"83\" class=\"code-line\">\u30af\u30e9\u30b9\u30bf\u5316\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u5834\u5408\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u524d\u306f\u30b9\u30ad\u30e3\u30f3\u3055\u308c\u308b\u30b9\u30c8\u30ec\u30fc\u30b8 \u30d6\u30ed\u30c3\u30af\u6570\u304c\u4e0d\u660e\u306a\u305f\u3081\u3001\u6b63\u78ba\u306a\u30af\u30a8\u30ea\u8cbb\u7528\u306e\u898b\u7a4d\u308a\u3092\u5f97\u3089\u308c\u307e\u305b\u3093\u3002\u6700\u7d42\u7684\u306a\u8cbb\u7528\u306f\u3001\u30af\u30a8\u30ea\u306e\u5b8c\u4e86\u5f8c\u306b\u3001\u30b9\u30ad\u30e3\u30f3\u3055\u308c\u305f\u7279\u5b9a\u306e\u30b9\u30c8\u30ec\u30fc\u30b8 \u30d6\u30ed\u30c3\u30af\u306b\u57fa\u3065\u3044\u3066\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<p data-line=\"85\" class=\"code-line\">\u4e0a\u8a18\u306e\u901a\u308a\u5b9f\u969b\u306e\u898b\u7a4d\u3082\u308a\u304c\u5f97\u3089\u308c\u307e\u305b\u3093\u3002<\/p>\n<p data-line=\"87\" class=\"code-line\">\u3068\u3044\u3046\u3053\u3068\u3067\u5b9f\u969b\u306b\u30af\u30a8\u30ea\u3092\u767a\u884c\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"89\"><span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span>\n<span class=\"token keyword\">WHERE<\/span>\n  category_id <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"98\" class=\"code-line\">dry run \u3067\u306f\u5168\u91cf\u30b9\u30ad\u30e3\u30f3\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"100\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/3495a51dfbfd-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"102\" class=\"code-line\">\u5b9f\u969b\u306b\u306f1\u3064\u306e\u30af\u30e9\u30b9\u30bf\u306e\u307f\u304c\u8ab2\u91d1\u3055\u308c5\u5206\u306e1\u7a0b\u5ea6\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"104\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/a13dc84bed58-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"106\" class=\"code-line\">\u6570\u5206\u7d4c\u904e\u5f8c\u306b\u518d\u5ea6\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001dry run\u306e\u7d50\u679c\u306b\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u304c\u8003\u616e\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p data-line=\"108\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/3ebdd4c33d58-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"110\" class=\"code-line\">\u5b58\u5728\u3057\u306a\u3044\u30af\u30e9\u30b9\u30bf\u3092\u6307\u5b9a\u3057\u3088\u3046\u3068\u3059\u308b\u3068 0B \u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p data-line=\"112\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/4f042a9462e4-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"114\" class=\"code-line\">category_id = 1 \u306b\u5bfe\u3057\u3066\u3082\u3068\u3082\u3068\u3053\u306e\u30af\u30e9\u30b9\u30bf\u306b\u5165\u3063\u3066\u3044\u305f\u306e\u3068\u540c\u3058\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u307f\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"116\"><span class=\"token keyword\">INSERT<\/span> <span class=\"token keyword\">INTO<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span>\n  <span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token keyword\">DATE<\/span><span class=\"token punctuation\">(<\/span>TIMESTAMP_ADD<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">TIMESTAMP<\/span> <span class=\"token string\">'2025-01-01 00:00:00'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">INTERVAL<\/span> x <span class=\"token keyword\">SECOND<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> usage_date<span class=\"token punctuation\">,<\/span>\n  TIMESTAMP_ADD<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">TIMESTAMP<\/span> <span class=\"token string\">'2025-01-01 00:00:00'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">INTERVAL<\/span> x <span class=\"token keyword\">SECOND<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> usage_timestamp<span class=\"token punctuation\">,<\/span>\n  <span class=\"token function\">MOD<\/span><span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">,<\/span> <span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> category_id<span class=\"token punctuation\">,<\/span>\n  CONCAT<span class=\"token punctuation\">(<\/span><span class=\"token string\">'value_'<\/span><span class=\"token punctuation\">,<\/span> CAST<span class=\"token punctuation\">(<\/span><span class=\"token function\">MOD<\/span><span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">,<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> STRING<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> value_text\n<span class=\"token keyword\">FROM<\/span>\n  UNNEST<span class=\"token punctuation\">(<\/span>GENERATE_ARRAY<span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1000000<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> x\n<span class=\"token keyword\">CROSS<\/span> <span class=\"token keyword\">JOIN<\/span> <span class=\"token punctuation\">(<\/span>\n  <span class=\"token keyword\">SELECT<\/span>\n    y\n  <span class=\"token keyword\">FROM<\/span>\n    UNNEST<span class=\"token punctuation\">(<\/span>GENERATE_ARRAY<span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> y <span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">WHERE<\/span> <span class=\"token function\">MOD<\/span><span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">,<\/span> <span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span> <span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"134\" class=\"code-line\">\u3053\u306e\u76f4\u5f8c\u306b dry run \u3067 category_id = 2 \u3092\u898b\u3066\u307f\u308b\u3068\u3001\u3082\u3068\u3082\u3068 category_id = 2 \u306b\u5165\u3063\u3066\u3044\u305f\u30c7\u30fc\u30bf\u91cf + category_id = 1 \u306b\u5165\u308c\u305f\u30c7\u30fc\u30bf\u91cf\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"136\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/672ae77013eb-20251026.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"138\" class=\"code-line\">\u5b58\u5728\u3057\u306a\u3044 category_id \u3092\u6307\u5b9a\u3059\u308b\u3068\u3001\u5148\u7a0b category_id = 1 \u306b\u5165\u308c\u305f\u30c7\u30fc\u30bf\u91cf\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"140\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/e1a59dfee793-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"142\" class=\"code-line\">\u3057\u3070\u3089\u304f\u6642\u9593\u3092\u304a\u3044\u3066\u304b\u3089\u518d\u5ea6\u898b\u308b\u3068\u5b9f\u969b\u306e\u5024\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p data-line=\"144\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/0e73bd7d3ddd-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"146\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/94265228116a-20251024.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"148\" class=\"code-line\">\u304a\u305d\u3089\u304f\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e<a target=\"_blank\" href=\"https:\/\/cloud.google.com\/blog\/ja\/products\/data-analytics\/understanding-the-bigquery--column-metadata-cmeta-index\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">BigQuery \u306e\u5185\u90e8: \u5217\u30e1\u30bf\u30c7\u30fc\u30bf \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08CMETA\uff09\u306e\u529b<\/a>\u306b\u8a18\u8f09\u3057\u3066\u3044\u308b\u3088\u3046\u306a\u3053\u3068\u304c\u95a2\u4fc2\u3057\u3066\u3044\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h3 id=\"inner-join-%E3%81%A7%E3%83%91%E3%83%BC%E3%83%86%E3%82%A3%E3%82%B7%E3%83%A7%E3%83%B3%E5%88%97%E3%81%8C%E7%B5%9E%E3%82%8A%E8%BE%BC%E3%81%BE%E3%82%8C%E3%82%8B\" data-line=\"150\" class=\"code-line\">\n INNER JOIN \u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u5217\u304c\u7d5e\u308a\u8fbc\u307e\u308c\u308b<\/h3>\n<p data-line=\"152\" class=\"code-line\">INNER JOIN \u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u5217\u304c\u7d5e\u308a\u8fbc\u307e\u308c\u308b\u5834\u5408\u3001\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u304c\u52b9\u3044\u3066\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u306f\u6e1b\u308a\u307e\u3059\u3002<\/p>\n<p data-line=\"154\" class=\"code-line\">\u3057\u304b\u3057 dry run \u3067\u306f\u305d\u308c\u304c\u53cd\u6620\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"156\">\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token operator\">OR<\/span> <span class=\"token keyword\">REPLACE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.join_right_small<span class=\"token punctuation\">`<\/span><\/span>\n<span class=\"token keyword\">AS<\/span>\n<span class=\"token keyword\">SELECT<\/span>\n  x <span class=\"token keyword\">AS<\/span> category_id<span class=\"token punctuation\">,<\/span>\n  DATE_ADD<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">DATE<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'2025-01-01'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">INTERVAL<\/span> x <span class=\"token keyword\">DAY<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> usage_date\n<span class=\"token keyword\">FROM<\/span>\n  UNNEST<span class=\"token punctuation\">(<\/span>GENERATE_ARRAY<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> x<span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"167\">\n<span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span> <span class=\"token keyword\">AS<\/span> t1\n<span class=\"token keyword\">INNER<\/span> <span class=\"token keyword\">JOIN<\/span> \n   <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.join_right_small<span class=\"token punctuation\">`<\/span><\/span> <span class=\"token keyword\">AS<\/span> t2\n<span class=\"token keyword\">USING<\/span><span class=\"token punctuation\">(<\/span>usage_date<span class=\"token punctuation\">)<\/span>\n<span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"179\" class=\"code-line\">dry run \u3067\u306f\u5168\u91cf\u5206\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br \/><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/6ee05540793f-20251024.png\" alt=\"INNER JOIN \u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u5217\u3067\u7d5e\u308a\u8fbc\u3093\u3060\u30af\u30a8\u30ea\u306e dry run\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"182\" class=\"code-line\">\u5b9f\u969b\u306b\u306f\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u5217\u3067\u7d5e\u3089\u308c\u3066\u3044\u308b\u5206\u306f\u30b3\u30b9\u30c8\u304c\u304b\u304b\u3063\u3066\u3044\u307e\u305b\u3093\u3002<br \/><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/3bac67140a3e-20251024.png\" alt=\"INNER JOIN \u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u5217\u3067\u7d5e\u308a\u8fbc\u3093\u3060\u30af\u30a8\u30ea\u306e\u5b9f\u969b\u306e\u7d50\u679c\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<h3 id=\"%E3%82%AD%E3%83%A3%E3%83%83%E3%82%B7%E3%83%A5%E3%81%8C%E5%8A%B9%E3%81%84%E3%81%A6%E3%81%84%E3%82%8B\" data-line=\"186\" class=\"code-line\">\n \u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u52b9\u3044\u3066\u3044\u308b<\/h3>\n<p data-line=\"188\" class=\"code-line\">\u4e00\u5ea6\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u304a\u3044\u3066\u3001\u3082\u3046\u4e00\u5ea6\u5b9f\u884c\u3057\u3088\u3046\u3068\u3059\u308b\u3068 dry run \u306f\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u8003\u616e\u305b\u305a\u306b\u898b\u7a4d\u3082\u308a\u3092\u51fa\u3057\u307e\u3059\u304c\u3001\u5b9f\u969b\u306b\u306f\u8ab2\u91d1\u3055\u308c\u308b\u30d0\u30a4\u30c8\u6570\u306f 0 B \u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"189\"><span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"195\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/dc8f7803dda7-20251023.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"197\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/9fdaae262895-20251023.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<h2 id=\"dry-run-%3C-%E5%AE%9F%E9%9A%9B\" data-line=\"200\" class=\"code-line\">\n dry run<br \/>\n<\/h2>\n<p data-line=\"202\" class=\"code-line\">dry run \u3088\u308a\u3082\u5b9f\u969b\u306e\u30b3\u30b9\u30c8\u306e\u307b\u3046\u304c\u9ad8\u3044\u306e\u3067\u7279\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<h3 id=\"%E5%A4%96%E9%83%A8%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB\" data-line=\"204\" class=\"code-line\">\n \u5916\u90e8\u30c6\u30fc\u30d6\u30eb<\/h3>\n<p data-line=\"206\" class=\"code-line\">\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u306f 0 B \u3068\u63a8\u5b9a\u3055\u308c\u307e\u3059\u304c\u5b9f\u969b\u306b\u306f\u8ab2\u91d1\u3055\u308c\u307e\u3059\u3002<\/p>\n<p data-line=\"208\" class=\"code-line\"><a target=\"_blank\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/running-queries?hl=ja#dry-run\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u306e\u30c9\u30e9\u30a4\u30e9\u30f3<\/a>\u306b\u3082\u6b21\u306e\u8a18\u8f09\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<blockquote data-line=\"210\" class=\"code-line\">\n<p data-line=\"210\" class=\"code-line\">\u6ce8: \u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u9023\u643a\u30af\u30a8\u30ea\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u3067\u3001\u884c\u304c\u8fd4\u3055\u308c\u3066\u3082 0 \u30d0\u30a4\u30c8\u306e\u4e0b\u9650\u304c\u5831\u544a\u3055\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u5b9f\u969b\u306e\u30af\u30a8\u30ea\u304c\u5b8c\u4e86\u3059\u308b\u307e\u3067\u3001\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u3067\u51e6\u7406\u3055\u308c\u308b\u30c7\u30fc\u30bf\u306e\u91cf\u304c\u78ba\u5b9a\u3067\u304d\u306a\u3044\u305f\u3081\u3067\u3059\u3002\u9023\u643a\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u3053\u306e\u30c7\u30fc\u30bf\u306e\u51e6\u7406\u306b\u5f15\u304d\u7d9a\u304d\u8cbb\u7528\u304c\u304b\u304b\u308a\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<p data-line=\"212\" class=\"code-line\">\u9069\u5f53\u306aCSV\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-csv\"><code class=\"language-csv code-line\" data-line=\"214\"><span class=\"token value\">usage_date<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">category_id<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">user_id<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">value<\/span>\n<span class=\"token value\">2025-01-01<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">u001<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">100<\/span>\n<span class=\"token value\">2025-01-02<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">2<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">u002<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">200<\/span>\n<span class=\"token value\">2025-01-03<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">u003<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">300<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"221\" class=\"code-line\">\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"222\"><span class=\"token keyword\">CREATE<\/span> <span class=\"token operator\">OR<\/span> <span class=\"token keyword\">REPLACE<\/span> EXTERNAL <span class=\"token keyword\">TABLE<\/span> <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.external_csv_example<span class=\"token punctuation\">`<\/span><\/span>\nOPTIONS <span class=\"token punctuation\">(<\/span>\n  format <span class=\"token operator\">=<\/span> <span class=\"token string\">'CSV'<\/span><span class=\"token punctuation\">,<\/span>\n  uris <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">'gs:\/\/verification-dryrun-test\/sample.csv'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n  skip_leading_rows <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"231\" class=\"code-line\">\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"232\"><span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.external_csv_example<span class=\"token punctuation\">`<\/span><\/span>\n<span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"240\" class=\"code-line\">0 B\u3068\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p data-line=\"242\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/4365d933909d-20251023.png\" alt=\"dry run \u306e\u7d50\u679c\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"244\" class=\"code-line\">\u5b9f\u969b\u306b\u306f\u8ab2\u91d1\u3055\u308c\u307e\u3059\u3002<\/p>\n<p data-line=\"246\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/9f32dbfd8a22-20251023.png\" alt=\"\u5b9f\u884c\u7d50\u679c\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<h3 id=\"ddl-%E3%82%B9%E3%83%86%E3%83%BC%E3%83%88%E3%83%A1%E3%83%B3%E3%83%88%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B\" data-line=\"248\" class=\"code-line\">\n DDL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b<\/h3>\n<p data-line=\"250\" class=\"code-line\">DDL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u3068\u305d\u306e\u5f8c\u306f\u63a8\u5b9a\u304c\u5b9f\u884c\u3055\u308c\u307e\u305b\u3093\u3002<br \/>\u4e00\u4f8b\u3068\u3057\u3066\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u9014\u4e2d\u306b CREATE TEMP TABLE \u5b9f\u884c\u3059\u308b\u30af\u30a8\u30ea\u3092\u8a66\u3057\u307e\u3059\u3002<\/p>\n<div class=\"code-block-container\">\n<pre class=\"language-sql\"><code class=\"language-sql code-line\" data-line=\"253\"><span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TEMP<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>temp_table<span class=\"token punctuation\">`<\/span><\/span><span class=\"token punctuation\">(<\/span>num INT64<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span>\n<span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token number\">1<\/span> <span class=\"token keyword\">AS<\/span> num<span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">SELECT<\/span>\n  <span class=\"token operator\">*<\/span>\n<span class=\"token keyword\">FROM<\/span>\n  <span class=\"token identifier\"><span class=\"token punctuation\">`<\/span>verification-475911.dryrun_test.partitioned_clustered_table<span class=\"token punctuation\">`<\/span><\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<\/div>\n<p data-line=\"273\" class=\"code-line\">\u672c\u6765\u3067\u3042\u308c\u30703\u56de\u547c\u3073\u51fa\u3057\u3066\u3044\u308b\u306e\u306710GB\u7a0b\u5ea6\u306e\u30b9\u30ad\u30e3\u30f3\u304c\u60f3\u5b9a\u3055\u308c\u307e\u3059\uff08\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u8003\u616e\u306a\u3057\uff09\u304c\u3001dry run \u3067\u306f 7 GB \u7a0b\u5ea6\u306b\u306a\u3063\u3066\u304a\u308a\u3001 <code>CREATE TEMP TABLE<\/code> \u5f8c\u306f dry run \u304c\u8d70\u3063\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n<p data-line=\"275\" class=\"code-line\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/zenn-user-upload\/e853a1c6af5b-20251025.png\" alt=\"\" class=\"md-img\" loading=\"lazy\"\/><\/p>\n<p data-line=\"277\" class=\"code-line\">\u4ed6\u306b\u3082<a target=\"_blank\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/multi-statement-queries?hl=ja#dryrun_multi_statement_queries\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30de\u30eb\u30c1\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8 \u30af\u30a8\u30ea\u306e\u30c9\u30e9\u30a4\u30e9\u30f3<\/a>\u306b\u306fDML\u3092\u4f7f\u7528\u3057\u305f\u30b1\u30fc\u30b9\u3084CALL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u305f\u5834\u5408\u306a\u3069\u306e\u30b1\u30fc\u30b9\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u305c\u3072\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2 id=\"%E7%B5%82%E3%82%8F%E3%82%8A%E3%81%AB\" data-line=\"279\" class=\"code-line\">\n \u7d42\u308f\u308a\u306b<\/h2>\n<p data-line=\"281\" class=\"code-line\">\u4eca\u56de\u691c\u8a3c\u3057\u305f\u4ee5\u5916\u306b\u3082 dry run \u3068\u5b9f\u969b\u304c\u4e56\u96e2\u3057\u3066\u3044\u308b\u30b1\u30fc\u30b9\u306f\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<br \/>dry run \u306e\u7d50\u679c\u3060\u3051\u3067\u30af\u30a8\u30ea\u5229\u7528\u91cf\u3092\u5b8c\u5168\u306b\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\u305f\u3081\u3001BigQuery \u306e API \u5236\u9650\u3092\u304b\u3051\u305f\u308a\u5b9a\u671f\u7684\u306b\u5b9f\u969b\u306e\u5229\u7528\u91cf\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n<p data-line=\"284\" class=\"code-line\">\u4ed6\u306b\u3082 dry run \u3068\u5b9f\u969b\u304c\u4e56\u96e2\u3059\u308b\u30b1\u30fc\u30b9\u304c\u3042\u308c\u3070\u305c\u3072\u30b3\u30e1\u30f3\u30c8\u4e0b\u3055\u3044\u3002<\/p>\n<\/div>\n\n<br \/><a href=\"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408\">\u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\u8a18\u4e8b\u306e\u5185\u5bb9 BigQuery \u306e dry run \u306f\u5b9f\u884c\u524d\u306b\u30af\u30a8\u30ea\u30b9\u30ad\u30e3\u30f3\u91cf\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u69d8\u3005\u306a\u30b1\u30fc\u30b9\u3067 dry run \u3067\u63d0\u793a\u3055\u308c\u308b\u30b9\u30ad\u30e3\u30f3\u91cf\u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u3067\u306f dry ru [&hellip;]","protected":false},"author":1,"featured_media":23777,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-23776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-tec"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"og:description\" content=\"\u8a18\u4e8b\u306e\u5185\u5bb9 BigQuery \u306e dry run \u306f\u5b9f\u884c\u524d\u306b\u30af\u30a8\u30ea\u30b9\u30ad\u30e3\u30f3\u91cf\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u69d8\u3005\u306a\u30b1\u30fc\u30b9\u3067 dry run \u3067\u63d0\u793a\u3055\u308c\u308b\u30b9\u30ad\u30e3\u30f3\u91cf\u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u3067\u306f dry ru [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408\" \/>\n<meta property=\"og:site_name\" content=\"\u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-15T11:15:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"info@pokecon.jp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"info@pokecon.jp\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/23776\\\/\"},\"author\":{\"name\":\"info@pokecon.jp\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"headline\":\"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081\",\"datePublished\":\"2025-11-15T11:15:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/23776\\\/\"},\"wordCount\":97,\"image\":{\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/1763205338_og-base-w1200-v2.png\",\"articleSection\":[\"\u4f01\u696d\u30c6\u30c3\u30af\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/23776\\\/\",\"url\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408\",\"name\":\"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/1763205338_og-base-w1200-v2.png\",\"datePublished\":\"2025-11-15T11:15:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#primaryimage\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/1763205338_og-base-w1200-v2.png\",\"contentUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/1763205338_og-base-w1200-v2.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/zenn.dev\\\/qubena\\\/articles\\\/b83fbf53b24408#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\",\"name\":\"\u30dd\u30b1\u30b3\u30f3\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\",\"name\":\"info@pokecon.jp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"caption\":\"info@pokecon.jp\"},\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/author\\\/infopokecon-jp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408","og_locale":"ja_JP","og_type":"article","og_title":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3","og_description":"\u8a18\u4e8b\u306e\u5185\u5bb9 BigQuery \u306e dry run \u306f\u5b9f\u884c\u524d\u306b\u30af\u30a8\u30ea\u30b9\u30ad\u30e3\u30f3\u91cf\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u69d8\u3005\u306a\u30b1\u30fc\u30b9\u3067 dry run \u3067\u63d0\u793a\u3055\u308c\u308b\u30b9\u30ad\u30e3\u30f3\u91cf\u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u3067\u306f dry ru [&hellip;]","og_url":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408","og_site_name":"\u30dd\u30b1\u30b3\u30f3","article_published_time":"2025-11-15T11:15:38+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png","type":"image\/png"}],"author":"info@pokecon.jp","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"info@pokecon.jp","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"2\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#article","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/23776\/"},"author":{"name":"info@pokecon.jp","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"headline":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081","datePublished":"2025-11-15T11:15:38+00:00","mainEntityOfPage":{"@id":"https:\/\/pokecon.jp\/job\/23776\/"},"wordCount":97,"image":{"@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png","articleSection":["\u4f01\u696d\u30c6\u30c3\u30af"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/pokecon.jp\/job\/23776\/","url":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408","name":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081 - \u30dd\u30b1\u30b3\u30f3","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#primaryimage"},"image":{"@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png","datePublished":"2025-11-15T11:15:38+00:00","author":{"@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"breadcrumb":{"@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#primaryimage","url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png","contentUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/11\/1763205338_og-base-w1200-v2.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/zenn.dev\/qubena\/articles\/b83fbf53b24408#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/pokecon.jp\/job\/"},{"@type":"ListItem","position":2,"name":"BigQuery \u306e dry run \u3068\u5b9f\u969b\u306e\u30b9\u30ad\u30e3\u30f3\u91cf\u304c\u7570\u306a\u308b\u30b1\u30fc\u30b9\u307e\u3068\u3081"}]},{"@type":"WebSite","@id":"https:\/\/pokecon.jp\/job\/#website","url":"https:\/\/pokecon.jp\/job\/","name":"\u30dd\u30b1\u30b3\u30f3","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pokecon.jp\/job\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997","name":"info@pokecon.jp","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","caption":"info@pokecon.jp"},"url":"https:\/\/pokecon.jp\/job\/author\/infopokecon-jp\/"}]}},"_links":{"self":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/23776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/comments?post=23776"}],"version-history":[{"count":1,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/23776\/revisions"}],"predecessor-version":[{"id":23778,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/23776\/revisions\/23778"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media\/23777"}],"wp:attachment":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media?parent=23776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/categories?post=23776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/tags?post=23776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}