Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Index on Post-Write Statement not working

Level 2
Index on Post-Write Statement not working


I saw that the recommendation for adding indexes on a table is to add them on the Post-Write statement. However, for some reason when I put the statement for the creation of the index, it does nothing when I build the PosgreSQL dataset.

Is there anything I am doing wrong or some kind of button that I have to activate so the Post-write statement works?

I also checked the creation statement on a SQL code recipe and it works there.

0 Kudos
1 Reply


pre- and post-write statement on a SQL dataset are executed without needing to activate anything, unless you run a sql script recipe (not a sql query recipe), because these recipe assume total control on the SQL statements issued.

Can you attach screenshots of the Settings > Advanced tab of your dataset? And can you check pg_indexes to see if your index is indeed missing?

0 Kudos