Issue with Google Bigquery date type

[Anonymous]

Hi community,

With Talend Open Studio for Big Data (Version: 6.4.1), I succeed in loading a file from Google cloud storage  (or flat file) to a Bigquery table with tBigQueryOutput.

Nethertheless, the date fields are loaded in a Bigquery TIMESTAMP type or a STRING type.

I do not succeed to load a date field in a Bigquery DATE type.

I tried different ways with SQL instructions (parse_date...),  or with tJava, or with tMap to transform the fields in the correct format.

But at the end, Talend loading in a Bigquery timestamp type or string type, but not in Bigquery date type.

Have you ever encountered this problem ?

Do you have a solution, please ?

Thanks&regards,

Gilles

[Anonymous]

The goal is to store dates as type Date in BigQuery. This issue still exists, Date datatype is converted into Timestamp.