Hi @JothyGanesan ,

You can write a notebook that will be responsible for archiving all the data that is older than 1 year. Then you can run a process that will delete the data from DLT table. How to do this is described at following article:

Transform data with pipelines - Azure Databricks | Microsoft Learn

One question, is your table a source from some downstream tables as well? Do you need to propagate those deletes to other tables?