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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

Highlighted
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! 

Digan Parikh
Sales Engineer
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