Index on Post-Write Statement not working

CD
Level 2
Index on Post-Write Statement not working

Hello,

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
fchataigner2
Dataiker

Hi,

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