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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous · Accepted solution]

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