Hi All

We have the DLT table as our curated layer with apply changes. The DLT pipelines runs on continuous mode for streaming real time data ingestion. There is a requirement as per regulatory to retain only 1 year data in the DLT table and to move the history to another Delta table. 

How to execute the Delete command without impacting the regular real time load? The delete can be run once in a day and the data to be moved to the new history delta table and not a DLT