{"author_url":"https://blog.hatena.ne.jp/kwbtblog/","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","author_name":"kwbtblog","version":"1.0","blog_url":"https://www.ekwbtblog.com/","blog_title":"Welcome to new things","height":"190","url":"https://www.ekwbtblog.com/entry/2023/07/26/224234","title":"Memo for a slightly elaborate use of BigQuery (etc.)","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 description of how to use it for myself. We hav\u2026","published":"2023-07-26 22:42:34","categories":["BigQuery","GCP","Google Cloud Platform","SQL","data analysis"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ekwbtblog.com%2Fentry%2F2023%2F07%2F26%2F224234\" title=\"Memo for a slightly elaborate use of BigQuery (etc.) - 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>","type":"rich","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kwbtblog/20190725/20190725113224.png"}