Alteryx Designer Desktop Discussions

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

How to run UPDATE statement via Snowflake connection

bobokoko1
7 - Meteor

I'm getting an error when I put in the below statement that it doesn't doesn't recongize Update in IN-DB. Is there a tool that would do this or a different statement. 

 

 

Update
"TABLE C" as a
SET
StopSell = Stop_Sell_Type
FROM "TABLE A" ss
JOIN "TABLE B" ssd
ON ss.ID = ssdr.STOP_SELL_ID

3 REPLIES 3
apathetichell
19 - Altair

You cannot do what you are trying to do via In-DB. You can use presql/postsql in an oncanvas tool (input data/output data/dynamic input).

bobokoko1
7 - Meteor

Thank you for the repsone. Do you have an example of how it would look with the tools? 

Labels
Top Solution Authors