{"image_url":null,"url":"https://totem3.hatenablog.jp/entry/2024/02/01/023941","version":"1.0","provider_url":"https://hatena.blog","title":"BigQuery Emulator\u3068\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf","width":"100%","provider_name":"Hatena Blog","author_name":"totem_3","published":"2024-02-01 02:39:41","height":"190","categories":[],"blog_title":"\u30a8\u30f3\u30b8\u30cb\u30a2\u3067\u3059\u3088\uff01","blog_url":"https://totem3.hatenablog.jp/","type":"rich","author_url":"https://blog.hatena.ne.jp/totem_3/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftotem3.hatenablog.jp%2Fentry%2F2024%2F02%2F01%2F023941\" title=\"BigQuery Emulator\u3068\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf - \u30a8\u30f3\u30b8\u30cb\u30a2\u3067\u3059\u3088\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"BigQuery\u306e\u30af\u30a8\u30ea(Google SQL\u69cb\u6587)\u306b\u306fParameterized Query\u3068\u3044\u3046\u6a5f\u80fd\u304c\u3042\u308a\u3001\u30af\u30a8\u30ea\u306b\u4efb\u610f\u306e\u5f0f\u3092\u57cb\u3081\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 cloud.google.com \u4e0a\u8a18\u306e\u30da\u30fc\u30b8\u3088\u308a\u5f15\u7528\u3059\u308b\u3068\u4ee5\u4e0b\u306e@gender\u3084@states\u306e\u3088\u3046\u306b\u3001@\u8b58\u5225\u5b50\u306e\u5f62\u5f0f\u3067\u30af\u30a8\u30ea\u3092\u66f8\u304d\u3001\u5b9f\u884c\u6642\u306b\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3057\u307e\u3059\u3002\u3053\u308c\u306fNamed Parameter(\u540d\u524d\u4ed8\u304d\u30d1\u30e9\u30e1\u30fc\u30bf)\u3068\u547c\u3070\u308c\u307e\u3059\u3002 SELECT name, SUM(number) AS count FROM `bigquery-public-data.usa_names.usa_1910_2013` WHERE gender = @\u2026"}