{"id":3455,"date":"2023-06-02T18:42:56","date_gmt":"2023-06-02T09:42:56","guid":{"rendered":"https:\/\/blog.since2020.jp\/?p=3455"},"modified":"2023-06-02T18:42:56","modified_gmt":"2023-06-02T09:42:56","slug":"%e3%80%90sql%e6%96%87%e4%b8%8d%e8%a6%81%e3%80%91bigquery%e3%81%a7%e7%b0%a1%e5%8d%98%e3%81%ab%e7%b5%b1%e8%a8%88%e6%83%85%e5%a0%b1%e3%82%92%e7%a2%ba%e8%aa%8d%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/since2020.jp\/media\/%e3%80%90sql%e6%96%87%e4%b8%8d%e8%a6%81%e3%80%91bigquery%e3%81%a7%e7%b0%a1%e5%8d%98%e3%81%ab%e7%b5%b1%e8%a8%88%e6%83%85%e5%a0%b1%e3%82%92%e7%a2%ba%e8%aa%8d%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\/","title":{"rendered":"\u3010SQL\u6587\u4e0d\u8981\u3011BigQuery\u3067\u7c21\u5358\u306b\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<p>BigQuery\u306f\u3001\u30af\u30e9\u30a6\u30c9\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3042\u308a\u3001\u9ad8\u901f\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u3068\u5206\u6790\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u7d71\u8a08\u60c5\u5831\u306f\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3084\u30c6\u30fc\u30d6\u30eb\u306b\u95a2\u3059\u308b\u91cd\u8981\u306a\u6d1e\u5bdf\u3092\u63d0\u4f9b\u3057\u3001\u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316\u3084\u30c7\u30fc\u30bf\u306e\u7406\u89e3\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001SQL\u6587\u3092\u4f7f\u7528\u305b\u305a\u306b\u3001BigQuery\u4e0a\u3067\u7c21\u5358\u306b\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n<h2>\u306f\u3058\u3081\u306b<\/h2>\n\u6bce\u56deSQL\u6587\u3092\u66f8\u3044\u3066BigQuey\u306b\u3042\u308b\u30c7\u30fc\u30bf\u306e\u30e6\u30cb\u30fc\u30af\u6570\u3084\u6700\u5927\u5024\u3001\u6700\u5c0f\u5024\u306a\u3069\u3092\u8abf\u3079\u3066\u3044\u307e\u305b\u3093\u304b\uff1f\u307e\u305f\u3001Looker Stadio\u3067\u53ef\u8996\u5316\u3057\u3066\u78ba\u8a8d\u3057\u3066\u3044\u308b\u65b9\u3082\u3044\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\r\n\r\n\u4eca\u56de\u306f<strong>SQL\u6587\u306a\u3057\u306b2\u30b9\u30c6\u30c3\u30d7\u3067\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5<\/strong>\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\n\n<h2>\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u304b\u3089\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u8abf\u3079\u308b\u3092\u62bc\u3059<\/h2>\nBigQuery\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u4e0b\u5199\u771f\u306e\u3088\u3046\u306a\u753b\u9762\u304c\u958b\u304b\u308c\u307e\u3059\u3002\u305d\u3057\u3066\u3001\u300c\u30a8\u30ad\u30b9\u30dd\u30fc\u30c8\u300d\u2192\u300c\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u8abf\u3079\u308b\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002\r\n\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-64.png\" alt=\"\" width=\"1155\" height=\"564\" class=\"alignnone size-full wp-image-3458\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-64.png 1155w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-64-300x146.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-64-1024x500.png 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-64-768x375.png 768w\" sizes=\"(max-width: 1155px) 100vw, 1155px\" \/>\r\n\r\n\u300c\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u8abf\u3079\u308b\u300d\u3092\u62bc\u3059\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u753b\u9762\u304c\u958b\u304b\u308c\u307e\u3059\u3002\r\n\r\n\u6700\u5f8c\u306b\u5217\u306e\u7d71\u8a08\u60c5\u5831\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002\r\n\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-65.png\" alt=\"\" width=\"865\" height=\"682\" class=\"alignnone size-full wp-image-3457\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-65.png 865w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-65-300x237.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/Untitled-65-768x606.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/>\r\n\r\n\u3053\u306e\u3088\u3046\u306b\u5217\u306e\u7d71\u8a08\u60c5\u5831\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\r\n\r\n&nbsp;\n\n<h2>\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u3066\u5217\u306e\u7d71\u8a08\u60c5\u5831\u3092\u898b\u308c\u308b<\/h2>\n\u3053\u308c\u306e\u4fbf\u5229\u306a\u3068\u3053\u308d\u306f\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u305f\u5f8c\u306b\u7d71\u8a08\u60c5\u5831\u3092\u898b\u308c\u308b\u3053\u3068\u3067\u3059\u3002\u5217\u306b\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u305f\u5f8c\u306b\u5217\u306e\u7d71\u8a08\u60c5\u5831\u3092\u300c\u66f4\u65b0\u300d\u307e\u305f\u306f\u518d\u3073\u300c\u5217\u306e\u7d71\u8a08\u60c5\u5831\u300d\u3092\u62bc\u3057\u307e\u3059\u3002\r\n\u4f8b\u3048\u3070A\u5217\u304c\u7a7a\u767d\u3067\u306a\u3044\u5834\u5408\u306e\u7d71\u8a08\u60c5\u5831\u3092\u898b\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\n\n<h2>\u307e\u3068\u3081<\/h2>\n\uff11\uff0eBigQuery\u306e\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3001\u300c\u30a8\u30ad\u30b9\u30dd\u30fc\u30c8\u300d\u2192\u300c\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u8abf\u3079\u308b\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\r\n\r\n\uff12\uff0e\u300c\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u8abf\u3079\u308b\u300d\u753b\u9762\u304c\u958b\u304d\u307e\u3059\u3002\r\n\r\n\uff13\uff0e\u5217\u306e\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u307e\u3059\u3002\r\n\r\n\uff14\uff0e\u300c\u5217\u306e\u7d71\u8a08\u60c5\u5831\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\r\n\r\n\uff15\uff0e\u30b7\u30fc\u30c8\u304c\u8868\u793a\u3055\u308c\u3001\u5217\u306e\u7d71\u8a08\u60c5\u5831\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\r\n\r\n\u3053\u306e\u65b9\u6cd5\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u5229\u7528\u3057\u3066BigQuery\u306e\u30c7\u30fc\u30bf\u306e\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u3066\u7279\u5b9a\u306e\u6761\u4ef6\u306e\u5217\u306e\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\r\n\r\n\u4ee5\u4e0a\u304c\u3001\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3068\u30b7\u30fc\u30c8\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u306e\u7d71\u8a08\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5\u306e\u307e\u3068\u3081\u3067\u3059\u3002\r\n\r\n\u3054\u53c2\u8003\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002","protected":false},"excerpt":{"rendered":"<p>BigQuery\u306f\u3001\u30af\u30e9\u30a6\u30c9\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3042\u308a\u3001\u9ad8\u901f\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u3068\u5206\u6790\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u7d71\u8a08\u60c5\u5831\u306f\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3084\u30c6\u30fc\u30d6\u30eb\u306b\u95a2\u3059\u308b\u91cd\u8981\u306a\u6d1e\u5bdf\u3092\u63d0\u4f9b\u3057\u3001\u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316\u3084\u30c7\u30fc\u30bf\u306e\u7406\u89e3\u306b [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":2995,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","swell_btn_cv_data":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[1246],"tags":[457,143,39],"class_list":["post-3455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-infrastructure","tag-bigquey","tag-gcp","tag-39"],"_links":{"self":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/3455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/comments?post=3455"}],"version-history":[{"count":0,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/3455\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media\/2995"}],"wp:attachment":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media?parent=3455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/categories?post=3455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/tags?post=3455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}