{"categories":["BigQuery","Dataform","GCP"],"url":"https://memo.geso.site/entry/2024/09/28/232150","version":"1.0","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/g/gesoges0/20240928/20240928231002.png","provider_name":"Hatena Blog","title":"Dataform\u3068BigQuery\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u306e\u8a18\u6cd5\u304c\u7570\u306a\u308b\u7f60\u3092\u8e0f\u3093\u3060","published":"2024-09-28 23:21:50","width":"100%","author_url":"https://blog.hatena.ne.jp/gesoges0/","height":"190","type":"rich","author_name":"gesoges0","blog_url":"https://memo.geso.site/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmemo.geso.site%2Fentry%2F2024%2F09%2F28%2F232150\" title=\"Dataform\u3068BigQuery\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u306e\u8a18\u6cd5\u304c\u7570\u306a\u308b\u7f60\u3092\u8e0f\u3093\u3060 - \u3081\u3082\u3061\u3087\u30fc\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u7d50\u8ad6 BigQuery\u306eSQL\u3068Dataform\u306esqlx\u306f\u30b3\u30e1\u30f3\u30c8\u306e\u9069\u7528\u304c\u7570\u306a\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002\u3053\u308c\u3089\u306fBigQuery\u3067\u3082Dataform\u3067\u3082\u30b3\u30e1\u30f3\u30c8\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u3059\u3002 -- SELECT 1 /* SELECT 1 */ #\u306b\u3088\u308b\u30b3\u30e1\u30f3\u30c8\u306f\u3001BigQuery\u3067\u306f\uff08\u6a19\u6e96SQL\u5c0e\u5165\u524d\u306e\u30b3\u30e1\u30f3\u30c8\u8a18\u6cd5\u3067\uff09\u30b3\u30e1\u30f3\u30c8\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u5b9f\u884c\u3067\u304d\u307e\u305b\u3093\u304c\u3001Dataform\u3067\u306f\u30af\u30a8\u30ea\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u308b\u3088\u3046\u3067\u3059\u3002 # SELECT 1 \u30d6\u30ed\u30c3\u30af\u30b3\u30e1\u30f3\u30c8\u306e\u6253\u3061\u6d88\u3057\u306f\u3001BigQuery\u3067\u306f\u30af\u30a8\u30ea\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u5b9f\u884c\u3067\u304d\u307e\u3059\u304c\u3001Dataform\u3067\u306f\u30b3\u30e1\u30f3\u30c8\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308cSQL\u306b\u30b3\u30f3\u30d1\u30a4\u30eb\u3067\u304d\u306a\u3044\u3088\u3046\u3067\u3059\u3002 # /*\u2026","provider_url":"https://hatena.blog","blog_title":"\u3081\u3082\u3061\u3087\u30fc"}