You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Similar to pre 1.2 grants, search optimizations have to be handled by post-hook, so a native configuration would be nice to have.
For long lived tables like incrementals, it's particularly interesting to not add the search optimization service on every incremental, as it appears to force an expensive full re-index of the table (vs the default behaviour that automatically adds to the index).
I wrote a little example of a macro that checks if the service exists before adding it here in case it's useful for someone doing this.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Similar to pre 1.2 grants, search optimizations have to be handled by post-hook, so a native configuration would be nice to have.
For long lived tables like incrementals, it's particularly interesting to not add the search optimization service on every incremental, as it appears to force an expensive full re-index of the table (vs the default behaviour that automatically adds to the index).
I wrote a little example of a macro that checks if the service exists before adding it here in case it's useful for someone doing this.
Beta Was this translation helpful? Give feedback.
All reactions