Google BigQuery : "string_field_0" when I load data from Storage

Question

I'm trying to use BigQuery's autodetect feature to load a semi-colon separated file from GCS, but it doesn't seem to be properly detecting my data and it names just one column as string_field_0

What am I doing wrong?

Answer 1

Please see this post, I think this is a problem on BigQuery side: https://medium.com/google-cloud/bigquery-create-table-from-google-sheets-causing-incorrect-column-names-string-field-0-134f6ecd3fc8