Index on Post-Write Statement not working

CD

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.

fchataigner2

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?