topic Not able to insert timestamp or date into snowflake as NTZ format in Talend Studio

Not able to insert timestamp or date into snowflake as NTZ format

Anonymous — Sat, 16 Nov 2024 03:34:03 GMT

I am trying to insert a timestamp value from an input table in snowflake to an output table in snowflake. Getting error

"Expression type does not match column data type, expecting TIMESTAMP_NTZ(9) but got TIMESTAMP_LTZ(9) for column ABC"

I am using JDBC components.

Re: Not able to insert timestamp or date into snowflake as NTZ format

Anonymous — Fri, 17 Jan 2020 05:23:46 GMT

Please help me out ! if anyone have some solution for this problem, It's an roadblock for my ETL Job.

Re: Not able to insert timestamp or date into snowflake as NTZ format

Anonymous — Fri, 17 Jan 2020 06:07:12 GMT

Hi, I am also facing the same issue. I tried giving SQL query in the additional columns, but that did not resolve the issue since it is unable to identify the input column.

Please let me know if you get a resolution.

Re: Not able to insert timestamp or date into snowflake as NTZ format

Anonymous — Mon, 02 Mar 2020 09:44:50 GMT

Hi Team,

I too faced the same issue. The solution is to change the datatype of column from timestamp_ntz to timestamp_tz and vice versa. This will solve the problem. Always keep the data type as timestamp_tz to ensure the exactly same date value is being recieved as in the source.

Using timestamp_ntz converts it into UTC timestamp.

Thanks,

Harshul Dhamu