r/bigquery • • Jan 23 '22

Problem creating a table using CSV

I'm a beginner at BQ and have been struggling to create a table out of CSV. I'm using the console, added the Schema, then the error happens.

Failed to create table: Error while reading data, error message: Could not parse '2018/12/21' as DATE for field pg_start_dt (position 3) starting at location 0 with message 'Unable to parse'

For the date is there any rules that I need to follow? I couldn't find it anywhere.

0 Upvotes

4 comments sorted by

View all comments

4

u/Woffice Jan 23 '22

It looks like the date format that Bigquery is looking for is YYYY-MM-DD according to this: https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv