{"version":"1.0","author_name":"kwbtblog","provider_url":"https://hatena.blog","published":"2023-02-27 05:28:02","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kwbtblog/20190725/20190725113224.png","blog_url":"https://www.ekwbtblog.com/","width":"100%","blog_title":"Welcome to new things","height":"190","title":"Memo for slightly elaborate usage of BigQuery (table creation and data update)","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/kwbtblog/","categories":["BigQuery","GCP","Google Cloud Platform","SQL","data analysis"],"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","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ekwbtblog.com%2Fentry%2F2023%2F02%2F27%2F052802\" title=\"Memo for slightly elaborate usage of BigQuery (table creation and data update) - 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>","url":"https://www.ekwbtblog.com/entry/2023/02/27/052802"}