Index on Post-Write Statement not working

CD
CD Registered Posts: 5 ✭✭✭✭

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.

Answers

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 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?

Setup Info
    Tags
      Help me…