Forum Discussion
Warehouse - VACUUM or RESTORE?
Hi govindarajan_d it's all automatic in the Warehouse (which is a bit of a pain) so no exposure to vacuum or optimise.
Ok. VACUUM and OPTIMIZE is kind of ok to have automatic maintenance.
How about RESTORE? If I can't do that, then it makes Warehouse less attractive option than lakehouse.
In terms of restore, you can use restore points https://blog.fabric.microsoft.com/en-US/blog/the-art-of-data-warehouse-recovery-within-microsoft-fabric/#:~:text=Restore%20points%20are%20recovery%20points,any%20given%20point%20in%20time.
Hi AndyDDC,
Restore point restores all tables to a older version. So its not the same as Delta restore
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.