Forum Discussion
Solved
Warehouse - VACUUM or RESTORE?
Hi All, In Lakehouse we have the option to VACUUM the data in a periodic manner and we can use Spark to do the same. We can also restore the table to older version if required. But is it poss...
Hi govindarajan_d it's all automatic in the Warehouse (which is a bit of a pain) so no exposure to vacuum or optimise.
nope, no way of restoring a warehouse table individually. Only way I can think of is creating a clone of a table at certain points to "snapshot" the table
Ok. Then I think compared to Warehouse, a Lakehouse would be better in that regards. Warehouse needs to add that property if it needs to compete with modern warehouses.