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

ecerulm

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.

Alexandru

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.

Turribeach

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.