Bigquery not accepting timestamp format

[Discover_AI]

I am trying to add data to a bigquery table and my submission date is make’s “now” variable but it gives me an error. Any idea how to fix this?

[L_Duperval]

You can try formatDate() to get a format that BigQuery understands.

I looked at the REST API here:

Data types  |  BigQuery  |  Google Cloud

And you might have to use something like formatDate(now, YYYY-MM-DD)

L

[Msquare_Automation]

Hi @Discover_AI

If the field requires timespamp instead of date. Try mapping the timeStamp:

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation