@Phani1  Check my POV:

- Follow the Delta purge lifecycle: DELETE → REORG TABLE APPLY (PURGE) → VACUUM
- Metadata + Automation: use a control table + Databricks Workflows for scalable, policy-based execution.
- Retention by layer + audit centrally: Bronze (long), Silver (controlled), Gold (frequent) with logs for governance.