Google Big Query Error: CSV table encountered too many errors, giving up. Row: 1 errors: 1

Question

I am trying to run a query on a 12 GB csv file loaded in Google big query, I cant run any query on the dataset. I am not sure if the dataset is loaded correctly. It shows as a table in the pane, but it is not present in the job history. Can anyone help on the same.

The dataset was loaded from a google storage bucket which has around 1.2MM records and 3728 variables

Job ID: p-g-us-adv-x-dat-aia-proto-1:bquijob_b951879_1540d02c1a4

Answer 1

Check your schema - it's possible that you forgot to include the schema for one of the columns - that's what happened to me!