CODEWITHSUNDEEP
google-bigqueryload-csv
user13419531
user13419531

Reputation:

BigQuery Could not parse '\N' as datetime for field BIRTH_DATE

I want to load a CSV file into BigQuery.There are columns where the types are DATETIME, but some missing values are '\N'. So when I use the BigQuery UI to load, got the following error:

Error while reading data, error message: Could not parse '\N' as datetime for field BIRTH_DATE (position 15) starting at location 1245

What's the best way to fix this problem? Thanks in advance

Upvotes: 0

Views: 531

Answers (0)

Related Questions