Warehouse - VACUUM or RESTORE?

[govindarajan_d]

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 possible to do the same in Warehouse? Because I don't see that option even though Warehouse also stores the data in Delta format. 

[AndyDDC · Accepted solution]

Hi @govindarajan_d it's all automatic in the Warehouse (which is a bit of a pain) so no exposure to vacuum or optimise.

https://youtu.be/uKgXKAw00XM?si=hz1rllG1lJf5Hr9s

[govindarajan_d]

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. 

[AndyDDC]

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-fab....

[govindarajan_d]

Hi @AndyDDC,

Restore point restores all tables to a older version. So its not the same as Delta restore

[AndyDDC]

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

[govindarajan_d]

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.