I want to perform a delete operation from the SQL Code recipe to Snowflake table
Is it possible?
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';
SELECT * FROM TABLE;
Let me know if that helps!