tDB_Input snowflake cannot retrieve timestamp column

Ask a Question

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:

0 Replies