Is there a way to tell dataiku to use TRUNCATE TABLE instead of DROP TABLE for snowflake datasets?

ecerulm Registered Posts: 45 ✭✭

I want to have the same table, otherwise when table is dropped and recreated all the grants to the table (other users are granted select, etc to this table) will be gone as well.

Best Answer

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Answer ✓

    Hi @ecerulm
    The option is available at the connection level "truncate to clear data". This is ignored if the schema changes and table is still dropped.

    Screenshot 2024-01-24 at 11.00.47 AM.png


  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,726 Neuron

    You get around the drop issue by creating views on top (which you will need to automate) and granting the views which Dataiku will not drop.

Setup Info
      Help me…