tDB_Input snowflake cannot retrieve timestamp column

[hamzaou]

I have a snowflake tDB_input block with this query:

select CREATION_DATE from MyTable;

when I try to do a run it always fails with this error:

net.snowflake.client.jdbc.SnowflakeSQLException: Cannot convert value in the driver from type:TIMESTAMP_NTZ to type:int.

the thing is nowhere do I try to convert this value. I can pull other columns just fine but any timestamp column always fails with that error.

this is the timestamp format: 2024-09-12 10:04:04.163

and this is how I setup the schema:

[gouravdubey5]

Hello,

This issue is typically related to how the Snowflake JDBC driver maps TIMESTAMP data types (TIMESTAMP_NTZ, TIMESTAMP_LTZ, TIMESTAMP_TZ) when Talend retrieves metadata via tDBInput.

In some cases, the driver does not expose these timestamp columns in a way that Talend can automatically interpret, which can cause the column to appear missing or unusable.

Recommended actions:

Ensure the latest Snowflake JDBC driver is installed and used in Talend Studio.

Re-define the schema manually in tDBInput and map the timestamp column to a compatible Talend type (for example Date).

If needed, explicitly cast the timestamp column in the SQL query (for example to VARCHAR) and handle the conversion in Talend.

Note:
This is a metadata/type-mapping issue rather than a problem with the Snowflake table itself. Updating the JDBC driver or explicitly casting the column usually resolves the issue.

Thanks,

Gourav