Storage need in Microsoft Fabric

[webchris]

Dear all

I have the following questions:

I remember that when one deletes data from a table with a delete statement instead of a truncate, that could lead to storage consumption issues. 

Now that Microsoft Fabric does not support "truncate table", I wonder whether my storage consumption will increase when I use "delete from" instead.

Thanks for feedback!

[AndyDDC · Accepted solution]

You can run VACUUM on your lakehouse tables to hard delete data. There's a default retention period of 7 days in the delta logs but you can reconfigure this to be more aggressive.

I believe Warehouse tables also have a default retention period of 7 days too 

[v-nikhilan-msft]

Hi @webchris 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the issue.
Otherwise, will respond back with the more details and we will try to help.
Thanks