SQL Delete Query

sj0071992
sj0071992 Partner, Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2022, Neuron 2023 Posts: 131 Neuron
in General Discussion

Hi,

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

Is it possible?

· Share on FacebookShare on Twitter

Answers

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭
    edited July 17

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…