Hello Community,
I want to Load a csv which i have on google shared Drive into a Bigquery table.
What i checked:
-That schema is right
-its utf-8 encoded
When i try to upload it give me back to many errors but doesnt tell me what kind of errors. Just how many rows the csv had which is correct. (73)
Is it maybe that the csb is in binary type?
Any hint or other way to do it would be nice
There is an encoding issue when downloading certain files from Google Drive.
You can try using a “Convert encoding” module using the same input and output encoding, then you can use the output of this module in a subsequent module (like Parse CSV or JSON).
Alternatively, you can simply try using the toString built-in function in the mapped data field, something like this: toString(data) – however this method doesn’t work in some cases where the encoding actually has to be converted.
Thank you so much for helping. After making also the structure correct it worked!
No problem, glad I could help!
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
