Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

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

Solved!
ecerulm
Level 4
Is there a way to tell dataiku to use TRUNCATE TABLE instead of DROP TABLE for snowflake datasets?

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. 



0 Kudos
1 Solution
AlexT
Dataiker

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

View solution in original post

0 Kudos
2 Replies
AlexT
Dataiker

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

0 Kudos
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.

Labels

?
Labels (2)

Setup info

?
A banner prompting to get Dataiku