Skip to content Skip to sidebar Skip to footer

Bigquery Error When Loading Timestamp

I am trying to load a CVS that has a field whose data is of type 'timestamp.' When I try to load that data into the table, I get the error: google.api.core.exceptions.BadRequest:

Solution 1:

Valid TIMESTAMP representations are detailed here: https://cloud.google.com/bigquery/data-types#legacy_sql_data_types

You can either use UNIX Timestamp (ie. 1408452095.220) or a Date/Time string (ie. "2014-08-19 07:41:35.220 -05:00").

Post a Comment for "Bigquery Error When Loading Timestamp"