Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
govindarajan_d
Solution Supplier
Solution Supplier

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

 

1 ACCEPTED SOLUTION
AndyDDC
Solution Sage
Solution Sage

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

View solution in original post

6 REPLIES 6
AndyDDC
Solution Sage
Solution Sage

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

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. 

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. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.