Forum Discussion

Peter_23's avatar
Peter_23
Advocate V
10 months ago
Solved

vacuum mode dont work

Hi community, I try to understand vaccum in delta table, I have a table with this history.     I ran the maintenance  with 7 days from window commands. 🙂   I run the code in notebook. d...
data engineering
Lakehouse
Notebook
Spark Job Definition
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    10 months ago

    Hi Peter_23,

    We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

    Thank you.

BhaveshPatel's avatar
BhaveshPatel
Super User
10 months ago

Hi Peter_23 

 

You can use below vaccum commands to retain the period as you would like. For Microsoft, they can keep vaccum for 7 days but you can change programmatically using python.. 

 

spark.sql("set spark.databricks.delta.retentionDurationCheck.enabled = false")
spark.sql("VACUUM DimDate RETAIN 8 HOURS")