Junk values displayed when using tBigQueryinput to access a timestamp column from a table present in googleBigQuery

[Anonymous]

Hi All,

I am using tBigQueryInput component to access a table from goolgeBigQuery which has a column called timestamp and the datatype is timestamp.Data stored in bigquery is like this 2017-08-10 15:23:53.369 UTC.But i get error as "Unparseable date: "1444885211.564"".In the input component,if i keep the date pattern as "yyyy-MM-dd", the i get some date values like this 1451-01-11,1447-06-14,1450-12-09.

Can you please tell where i am doing wrong in accessing the timestamp values.

Thanks,

Rajaneesh

[Anonymous]

Hello,

What's your query in tBigQueryInput component?

Best regards

Sabrina