{"width":"100%","provider_name":"Hatena Blog","categories":["BigQuery","GCP","Google Cloud Platform","SQL","data analysis"],"type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kwbtblog/20190725/20190725113224.png","author_url":"https://blog.hatena.ne.jp/kwbtblog/","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ekwbtblog.com%2Fentry%2F2023%2F02%2F26%2F044727\" title=\"Memo on how to use BigQuery in a slightly more elaborate way (views, materialized views, table functions) - Welcome to new things\" 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.ekwbtblog.com/","version":"1.0","author_name":"kwbtblog","description":"I usually use Google BigQuery only for simple aggregate SQL, but there are many other useful functions besides aggregate SQL. However, since I don't use it often and when I do try to use it, I start by looking for a manual, so I'll put together a brief usage guide for myself. This section summarizes\u2026","published":"2023-02-26 04:47:27","title":"Memo on how to use BigQuery in a slightly more elaborate way (views, materialized views, table functions)","blog_title":"Welcome to new things","height":"190","url":"https://www.ekwbtblog.com/entry/2023/02/26/044727"}