{"author_url":"https://blog.hatena.ne.jp/ggen-msasaki/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.g-gen.co.jp%2Fentry%2Fquery-samples-for-bigquery-information-schema\" title=\"BigQuery\u306eINFORMATION_SCHEMA\u5411\u3051\u30b5\u30f3\u30d7\u30eb\u30af\u30a8\u30ea\u96c6 - G-gen Tech Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"BigQuery\u306eINFORMATION_SCHEMA\u5411\u3051\u30b5\u30f3\u30d7\u30eb\u30af\u30a8\u30ea\u96c6","url":"https://blog.g-gen.co.jp/entry/query-samples-for-bigquery-information-schema","provider_name":"Hatena Blog","categories":["BigQuery","Google Cloud","\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u30fb\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3\u30fb\u4e8b\u4f8b"],"type":"rich","published":"2025-09-03 09:00:00","blog_title":"G-gen Tech Blog","provider_url":"https://hatena.blog","blog_url":"https://blog.g-gen.co.jp/","description":"G-gen\u306e min \u3067\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001BigQuery \u306e INFORMATION_SCHEMA \u306b\u5bfe\u3059\u308b\u30af\u30a8\u30ea\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u30b3\u30b9\u30c8\u7ba1\u7406\u3001\u958b\u767a\u306e\u52b9\u7387\u5316\u3001\u904b\u7528\u306e\u305f\u3081\u306b\u6d3b\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u4ed5\u69d8 INFORMATION_SCHEMA \u3068\u306f \u6599\u91d1 \u5fc5\u8981\u306a\u6a29\u9650 \u5236\u7d04\u4e8b\u9805 \u6ce8\u610f\u70b9 \u30b3\u30b9\u30c8\u30fb\u30ea\u30bd\u30fc\u30b9\u7ba1\u7406 \u9ad8\u984d\u30af\u30a8\u30ea\u3092\u7279\u5b9a\u3059\u308b \u30e6\u30fc\u30b9\u30b1\u30fc\u30b9 SQL \u30b9\u30ed\u30c3\u30c8\u4f7f\u7528\u91cf\u306e\u63a8\u79fb\u3092\u5206\u6790\u3057\u3001\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3092\u7279\u5b9a\u3059\u308b \u30e6\u30fc\u30b9\u30b1\u30fc\u30b9 SQL \u7d44\u7e54\u5168\u4f53\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u4f7f\u7528\u91cf\u3092\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u5225\u306b\u628a\u63e1\u3059\u308b \u30e6\u30fc\u30b9\u30b1\u30fc\u30b9 SQL \u958b\u767a\u30fb\u30c7\u30d0\u30c3\u30b0\u52b9\u7387\u5316 \u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u60c5\u5831\u3092\u7d20\u65e9\u304f\u78ba\u8a8d\u3059\u308b \u30e6\u30fc\u30b9\u30b1\u30fc\u30b9 SQL \u30c6\u30fc\u30d6\u30eb\u306e DDL\uff08\u30c6\u30fc\u2026","height":"190","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/g/ggen-sugimura/20250903/20250903090010.jpg","version":"1.0","author_name":"ggen-msasaki","width":"100%"}