community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Update and insert to Snowflake DB using IN DB

Asteroid

Hi Experts,

 

Need some inputs i am building an workflow to Update and insert data from Oracle Db to  Snowflake DB using IN DB. Please help me this.

 

Thanks,

Shasank

Asteroid
Alteryx Partner

I have the same issue, any help would be welcome...

In my case, despite the Alter fucntion sI set in Alteryx's Pre-SQL, I am still gettin gerrors due to time stamp formats:

expecting TIMESTAMP_NTZ(9) but got TIMESTAMP_LTZ(9)

Alteryx
Alteryx

@Tharashasank @fpinchon Can you please try and set both the TIMESTAMP_TYPE_MAPPING and CLIENT_TIMESTAMP_TYPE to TIMESTAMP_NTZ. That should do the trick! 

Alteryx Partner

What worked for me is to insert as a Pre Create SQL Statement the following:

alter session set client_timestamp_type_mapping=timestamp_ntz;

 

It was not super intuitive, but now it works wonderfully!

 

I captured my whole experience here:

http://insightsthroughdata.com/how-to-load-data-in-bulk-to-snowflake-with-alteryx/ 

 

Cheers,

Frederic

Labels