I keep getting these errors while trying to load a a dataset into bigquery sandbox.
I got this error first when I tried making use of the auto detect option for the schema of the dataset.
Failed to create table: Error while reading data, error message: Could not parse '4/12/2016 7:21:00 AM' as TIMESTAMP for field Time (position 1) starting at location 15 with message 'Invalid time zone: AM'
Then i got this when i input bq_partition in the edit as text option for the schema
Failed to create table: Error while reading data, error message: Too many values in row starting at position: 0. Found 3 column(s) while expected 1.