Implementing a custom script to scan and delete individual records older than 3 years, ensuring no current data is affected.

Using Delta Lake's VACUUM feature to automatically remove files not referenced by the Delta table, including those older than 3 years.

Identifying and dropping entire partitions that contain data older than 3 years, leveraging the partitioning schema for efficient data isolation.

Creating a separate Delta table for historical data and manually moving records older than 3 years to this table.