Skip to main content
Question

Automate deletion of old data

  • August 16, 2022
  • 4 replies
  • 13 views
B
Level 4

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

4 replies

D
Level 0

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

B
Level 4
  • bhasker.sathy
  • Author
  • Level 4
  • August 25, 2022

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

R
Celonaut
Please see the following discussion for how to purge data. https://www.celopeers.com/s/question/0D507000012vXdiCAE/is-there-an-automated-mechanism-to-delete-past-historical-data-from-celonis
B
Level 4

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).

 

 

Community Code of ConductAccessibility statement