CODEWITHSUNDEEP
google-bigquerygoogle-cloud-storage
Laurent TEMO
Laurent TEMO

Reputation: 83

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

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?

enter image description here

enter image description here

Upvotes: 4

Views: 5082

Answers (2)

Ethan Yanjia Li
Ethan Yanjia Li

Reputation: 766

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

Upvotes: 2

Graham Polley
Graham Polley

Reputation: 14791

Your data has semicolons. BigQuery only support either comma, pipe or tab when using the schema auto detect feature. It's documented here.

So, you'll either have to manually specify it, or transform your data using one of those supported separators I listed above.

Upvotes: 1

Related Questions