I have a big sendable data extension (hundreds of millions records) in marketing cloud that has multiple primary keys. The DE is live, and new records are being written constantly.
I need to delete some records by referencing a date attribute within the data extension, for the records that are over a certain amount of days will need to get deleted, let's say 30 days for example.
I need to run a deletion script in marketing cloud but the only approach I can think of is to match a certain filter using SSJS in a DE irrespective of the primary key. However, I think this approach has the limitations of 2500 rows and I am not sure if it is possible to customize the code to handle more and how.
I am still developing my SSJS knowledge, I will be very grateful for a low-level solution, but any suggestions of what would be the best approach to handle this will be appreciated. Thanks