{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/swfz/20220522/20220522184356.png","categories":["GoogleCloudPlatform","BigQuery","AWK","CSV"],"author_url":"https://blog.hatena.ne.jp/swfz/","published":"2022-05-22 18:44:27","type":"rich","blog_title":"notebook","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fswfz.hatenablog.com%2Fentry%2F2022%2F05%2F22%2F184427\" title=\"\u6539\u884c\u542b\u3080\u30c7\u30fc\u30bf\u304c\u3042\u308bCSV\u3092BigQuery\u306bload\u3059\u308b - notebook\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"swfz","provider_name":"Hatena Blog","description":"\u4eca\u307e\u3067CSV\u3092BigQuery\u306bload\u3059\u308b\u3053\u3068\u304c\u305d\u3093\u306a\u306b\u306a\u304b\u3063\u305f\u306e\u3067(\u3060\u3044\u305f\u3044JSON\u3067load\u3057\u3066\u305f)\u6539\u884c\u304c\u542b\u307e\u308c\u3066\u3044\u308bCSV\u3092load\u3059\u308b\u306e\u306b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u5fc5\u8981\u306a\u306e\u3092\u77e5\u3089\u306a\u304b\u3063\u305f \u4eca\u56de\u306f\u8abf\u3079\u308b\u904e\u7a0b\u3092\u305b\u3063\u304b\u304f\u306a\u306e\u3067\u6b8b\u3057\u3066\u304a\u304f load\u6642\u306e\u30a8\u30e9\u30fc \u4f55\u3082\u77e5\u3089\u305a\u306bload\u3057\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc Error while reading data, error message: CSV table references column position 9, but line starting at position:2815 contains only 3 columns. \u30ab\u30e9\u30e0\u6570\u304c\u3042\u3063\u3066\u3044\u306a\u3044 GCS\u4e0a\u2026","provider_url":"https://hatena.blog","height":"190","blog_url":"https://swfz.hatenablog.com/","version":"1.0","title":"\u6539\u884c\u542b\u3080\u30c7\u30fc\u30bf\u304c\u3042\u308bCSV\u3092BigQuery\u306bload\u3059\u308b","width":"100%","url":"https://swfz.hatenablog.com/entry/2022/05/22/184427"}