Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I want to perform a delete operation from the SQL Code recipe to Snowflake table
Is it possible?
Hi,
Yes, you should be able to utilize DELETE statements as part of your SQL recipe. However, you might need to treat them as separate statements. For example, something like:
DELETE FROM TABLE WHERE XXX = 'YY';
-- DKU_END_STATEMENT
SELECT * FROM TABLE;
Let me know if that helps!
Best,
Andrew