{"published":"2021-12-23 08:30:00","blog_title":"yasuhisa's blog","url":"https://www.yasuhisay.info/entry/2021/12/23/083000","provider_url":"https://hatena.blog","description":"\u3053\u306e\u8a18\u4e8b\u306f\u3001BigQuery Advent Calendar 2021\u306e23\u65e5\u76ee\u306e\u8a18\u4e8b\u3067\u3059\u30028\u65e5\u76ee\u306e\u8a18\u4e8b\u3082\u66f8\u3044\u3066\u3044\u308b\u306e\u3067\u3001\u3053\u306eAdvent Calendar\u30672\u3064\u76ee\u306e\u8a18\u4e8b\u306b\u306a\u308a\u307e\u3059\u3002\u30e1\u30bf\u30c7\u30fc\u30bf\u5927\u597d\u304d\u4eba\u9593\u306a\u306e\u3067\u3001\u4eca\u65e5\u306e\u30cd\u30bf\u3082\u30e1\u30bf\u30c7\u30fc\u30bf\u95a2\u9023\u3067\u3059\u3002 \u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u304c\u77e5\u308a\u305f\u3044 \u53e4\u306e\u65b9\u6cd5: __TABLES__\u3092\u4f7f\u3046 INFORMATION_SCHEMA.PARTITIONS\u3092\u4f7f\u304a\u3046 \u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u304c\u77e5\u308a\u305f\u3044 \u30c7\u30fc\u30bf\u57fa\u76e4\u306e\u7ba1\u7406\u3092\u3084\u3063\u3066\u3044\u308b\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u304c\u77e5\u308a\u305f\u3044!\u3068\u3044\u3046\u3053\u3068\u306f\u591a\u3044\u3067\u3059\u3002\u5177\u4f53\u7684\u306b\u306f\u300c9\u6642\u307e\u3067\u306b\u30c7\u30fc\u30bf\u8ee2\u9001\u7d42\u308f\u3063\u3066\u3044\u306a\u3044\u3068\u307e\u305a\u3044\u304b\u3089\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u3068\u6642\u523b\u3092\u6bd4\u8f03\u3057\u3066\u76e3\u2026","categories":["BigQuery","\u30c7\u30fc\u30bf\u57fa\u76e4"],"author_name":"syou6162","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.yasuhisay.info%2Fentry%2F2021%2F12%2F23%2F083000\" title=\"\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u3092INFORMATION_SCHEMA.PARTITIONS\u304b\u3089\u8abf\u67fb\u3059\u308b - yasuhisa&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://www.yasuhisay.info/","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/syou6162/20211218/20211218135442.png","version":"1.0","type":"rich","width":"100%","author_url":"https://blog.hatena.ne.jp/syou6162/","height":"190","provider_name":"Hatena Blog","title":"\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u7d42\u66f4\u65b0\u65e5\u3092INFORMATION_SCHEMA.PARTITIONS\u304b\u3089\u8abf\u67fb\u3059\u308b"}