Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

SQL Delete Query

sj0071992
Neuron
Neuron
SQL Delete Query

Hi,

 

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

Is it possible?

 

0 Kudos
1 Reply
ATsao
Dataiker
Dataiker

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

0 Kudos