Hi @mohit7 ,

A couple of questions to answer you better!

- Are you using UC managed storage?
- Can you check delta.logRetentionDuration, which defaults to 30days!(This would be the main reason why you are not able to time travel with your checkpoints!)
- VACUUM retention, which defaults to 7 days(controls removal of data files which are no longer referenced)

because log compaction is an internal Delta/Databricks mechanism which is distcint from data file compaction and isn't exposed the way auto-compact/optimzed writes are!