Hi,
Does Celonis have best practices on how to automate the deletion of old day (say data older than 1 year)? I understand that I can write my custom scripts with delete statements and execute them. However, given the underlying data model (that also has relationships) and timestamp definitions in each table, is there a way to leverage that and easily automate deletion of old data (ex : older than a year)?
Thanks,
Bhasker
Hello,
The easiest way is just to write SQL transformation that will be run on daily basis (or weekly) and just delete data older then X.
Best Regards,
Mateusz Dudek
Thanks @deleted deleted for the details !
Definitely an option. But I was wondering if there is an efficient way to write those SQL scripts. Ex : Given the underlying data model, is it possible to leverage the relationships (FKs) and do something like 'cascaded delete' from the top-most parent? For standalone objects I guess there is no option but to write individual delete scripts.
Thanks again !
Bhasker
Thank you @robert.mcgin ...however, it looks like the end solution was a manual delete. If automatic delete is needed, then it'll result in full load (and that can be very time consuming).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
