Date/Time changes while uploading to SnowFlake

[JuliusB]

Hey all,

I am uploading datetime field to Snowflake (timestamp_ntz) and end up with all values changed by 7 hours. 

I believe an error is with timezones, but isn't that possible to have something like naive datetime in Alteryx? Using datetimeadd() sounds not like an option here.

Thanks a lot,

Julius

[RobertOdera]

Hi, @JuliusB 

Can you try all of the below and see if it works?

- DateTimeToLocal([timestamp_ntz])

It should convert to the local system timezone.

Cheers.

[JuliusB]

Hi,

No, this doesn't help.

[anupama_manme]

Did you solve this? If so, could you please advise.

[JuliusB]

Hi, @anupama_manme . Actually do not recall as this was long time ago. But DATETIME_NTZ datatype in Snowflake and forced entry as STRING from Alteryx should work. 

[NamrataDhiwar]

You can try Snowflake BULK load option while loading data