I want to keep a rolling 2 years of data in Celonis. So each month I would ideally like to delete the 1st month in Celonis and add the new month.
I do not want to reload the data each month - full load (as that would take too long for two years of data) and of course a delta load only adds change to the existing data.
+2You can create a SQL Transformation to delete older data
It can be as simple as below (example from SAP tables)
DELETE FROM VBAK WHERE DATEDIFF(MM, ERDAT, CURRENT_DATE()) > 24;
DELETE FROM VBAP WHERE DATEDIFF(MM, ERDAT, CURRENT_DATE()) > 24;
Thank you Gabriel - that does indeed look very simple. So that would mean 1 delete statement per table. Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
