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

Asked May 04 '20 at 19:20

Active May 04 '20 at 19:20

Viewed 506 times

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

asked May 04 '20 at 19:20

1

Did you try loading as strings, and parsing in BigQuery later? – Felipe Hoffa May 04 '20 at 19:46
Hi Felipe, yes. I tried to load as strings. but it doesn't work that way. – May 04 '20 at 20:07
can you give us some sample data you'd like to ingest? – Felipe Hoffa May 04 '20 at 21:23
2020,MARTIN,6060,12678,\N,DEFF,\N,78000,VANICE,12,900,F,2017-09-17 13:36::21 This is one raw of that csv file – May 05 '20 at 03:22
If when the DATETIME is null, \N is placed instead of a date. Why couldn't you load the column as _string_ ? – Alexandre Moraes May 05 '20 at 07:29

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

0 Answers0