SQL Delete Query

[sj0071992]

Hi,

I want to perform a delete operation from the SQL Code recipe to Snowflake table

Is it possible?

[ATsao]

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