I want to write an automation which deletes records from a certain DE after the present date is 3 months after their date_added attribute. I know this is possible with DELETE FROM and DATEADD() in SQL, but I can only write SELECT statements in the SQL Query option within Automation Studio. How do I build this automation now? Thanks in advance.

  • Is the deletion based on rolling 3 months period within individual record level? – Brad Sapkota Mar 14 '18 at 21:32

Instead of using an automation, I would rather utilise the Data Retention policy for that particular DE. This feature can remove individual records after a specified number of days, without any SQL activities.

This of course under the assumption of, that your date_added corresponds to the timestamp of the entry being created in the said DE

  • I solved it by using the Data Retention policy on the data extension. Thanks! – Rutger Mar 15 '18 at 8:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.