'Getting "unexpected error" message when trying to create table on BigQuery
I get an "unexpected error" message every time I try to create a table on BigQuery. I've tried inputting and omitting the schema and made sure that the file was compatible with csv format.
Solution 1:[1]
I was having the same issue.
I did a couple of things to clean up the csv file and I was then able to upload it successfully
- Remove commas from any numerical data
- If using auto detect for schema remove any spaces between headings
- Remove header data completely and define schema
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Traceee |