How to run UPDATE statement via Snowflake connection
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bobokoko1
7 - Meteor
‎01-12-2023
02:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- In Database
- Tips and Tricks
- Workflow
3 REPLIES 3
apathetichell
19 - Altair
‎01-12-2023
03:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
‎01-12-2023
03:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the repsone. Do you have an example of how it would look with the tools?
apathetichell
19 - Altair
‎01-12-2023
04:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
