SQL Server DateTime to Snowflake DateTime

[talendstar]

I am loading a table from SQL Server into Snowflake that contains columns with DateTime data type. Date format in SQL Server is yyyy-mm-dd hh:mm:ss . However when I pass the value to Snowflake I only get the date portion yyyy-mm-dd 00:00:00 - even though the column on Snowflake end is also datetime. in SQL Server time stamp is generally a timestamp and not a value like 00:00:00.

I have also tried using parseDate function (by making SQL Server field string) as well as formatDate functions but not getting traction.

If someone could guide me on this. Thanks

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are? Are you using any dynamic schema feature in your workflow?

In advanced settings of SnowflakeOutput component, please check "Custom DB type" checkbox and check how to change default mapping from Talend Date to Snowflake Timestamp or DateTime.

 

Best regards

Sabrina