Forum Discussion

JVDA98's avatar
JVDA98
Frequent Visitor
1 month ago

Onelake Storage Report

Hi All, I checked the OneLake storage Report for the first time, and it blew my mind... I have one warehouse that is > 1+ TB, while it only contains two (!!) tables. - 700K rows - 1.2M rows I di...
data warehouse
warehouse
v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 month ago

Hi JVDA98​,

Thank you for reaching out to Microsoft Fabric Community.

The high storage is most likely caused by the multiple UPDATE operations in the warehouse. The storage consumed is not based only on the current number of rows.

  • Changing the retention period from 30 days to 5 days is the correct approach to reduce historical storage.
  • The expired data is cleaned up asynchronously in the background, so the storage will not decrease immediately. There is no need to manually delete the files under OneLake they are managed by fabric warehouse.
  • Please allow the background cleanup to complete and then refresh the OneLake storage report. Also review the stored procedures and reduce unnecessary or repeated updates, as these can generate significant historical data and increase storage usage.

Thanks and regards,
Anjan Kumar Chippa