Transformations: Support VACUUM Command
Answered
Fivetran has a design limitation where the VACUUM command cannot be run against Redshift warehouses in particular, and presumably PostgreSQL warehouse as well.
All of the transformation scripts from this StackOverflow post have been tried but do not work. Furthermore, the Fivetran engineering team have also confirmed that this is a system limitation.
It would be very helpful to have the ability to schedule the vacuuming of tables using Transformations.
-
Official comment
Hi Jack,
Thanks for your feedback here. I will look further into this limitation to see if this is something that would be possible!
Would you have more context on how often you need to run VACUUM today? Are you currently doing this at regular intervals in Redshift, or is it after certain key events that occur?
Please sign in to leave a comment.
Comments
1 comment