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

Four Stars

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

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

Moderator

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

Hello,

What's your query in tBigQueryInput component?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.