SQL Server DateTime to Snowflake DateTime

talendstar — Sat, 16 Nov 2024 00:06:27 GMT

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

Re: SQL Server DateTime to Snowflake DateTime

Anonymous — Fri, 09 Jul 2021 09:23:27 GMT

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

topic SQL Server DateTime to Snowflake DateTime in Talend Studio

SQL Server DateTime to Snowflake DateTime

Re: SQL Server DateTime to Snowflake DateTime