{"title":"bq query \u306e\u7d50\u679c\u3092Google Sheets\uff08Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u306b\u305d\u306e\u307e\u307e\u8cbc\u308a\u4ed8\u3051\u305f\u3044","categories":[],"height":"190","version":"1.0","provider_url":"https://hatena.blog","published":"2022-11-10 00:30:09","blog_url":"https://shase428.hatenablog.jp/","author_name":"shase428","blog_title":"\u30d3\u30c3\u30c8\u306e\u6d77","description":"\u30dd\u30a4\u30f3\u30c8 csv \u306f\u305d\u306e\u307e\u307e\u8cbc\u4ed8\u3051\u3089\u308c\u306a\u3044\uff081\u884c\u306b\u306a\u3063\u3066\u3057\u307e\u3046\uff09 tsv \u306f\u305d\u306e\u307e\u307e\u8cbc\u308a\u4ed8\u3051\u53ef\u80fd\uff08\u305f\u3060\u3057\u30012022\u5e7411\u6708\u73fe\u5728\u3001--format \u306b tsv \u306f\u306a\u3044\uff09 \u3069\u3046\u3059\u308b\u304b --format csv \u3057\u3066 tr \u3067 csv to tsv \u3057\u3066 pbcopy \u306b\u6e21\u3059 $ bq query --project_id foobar-project --use_legacy_sql=false --format csv \" select * from foobar-project.foobar-dataset.foobar-table \" | tr \",\" \"\\\\t\" | pbcopy","author_url":"https://blog.hatena.ne.jp/shase428/","width":"100%","url":"https://shase428.hatenablog.jp/entry/2022/11/10/003009","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshase428.hatenablog.jp%2Fentry%2F2022%2F11%2F10%2F003009\" title=\"bq query \u306e\u7d50\u679c\u3092Google Sheets\uff08Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u306b\u305d\u306e\u307e\u307e\u8cbc\u308a\u4ed8\u3051\u305f\u3044 - \u30d3\u30c3\u30c8\u306e\u6d77\" 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","image_url":null,"provider_name":"Hatena Blog"}