In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date/Time changes while uploading to SnowFlake

JuliusB
5 - Atom

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

5 REPLIES 5
RobertOdera
13 - Pulsar

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
5 - Atom

Hi,

 

No, this doesn't help.

anupama_manme
5 - Atom

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

JuliusB
5 - Atom

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
8 - Asteroid

You can try Snowflake BULK load option while loading data

Labels
Top Solution Authors