Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.Sign up
I guess a more robust approach would be to use JSON for uploading instead of CSV. jsonlite seems to work fine with UTF-8 on Windows (jeroen/jsonlite#42). Another advantage: I've run into problems with corner cases such as a one-row one-column data frame with an empty value, this probably won't be an issue when JSON is used.
And now worth considering if we should use DML: https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language (but probably slower than json)