DROP some tables in the event collection, via the DROP TABLE command.

In addition to dropping tables you can consider loading only data of the past year instead of multiple years.

@paul.velth and @joren.kamer12 : I have deleted entire Data Job which caused this issue and deleted it's extraction, transformation and data model. Still same issue.

Just found data consumption details but not sure why it's still up even if I have deleted Data Connection and Data Pool. Any idea ?

Hello Archit,

Normally Celonis only audits your data once a day, so tomorrow it should be fine.

Best Regards,

Paul Velthuis

Hi Archit,

First, you can filter in the data consumption tab the most consuming table - in your case it seems to be P2P_LFA1.

Then i would reconsider extraction method for this table, and maybe limit the data size by using filtering or inner join between rest of your data and the LFA1 table.

Second, you can clean the data (delete table) by using below SQL code in the any transformation statement:

For example: DROP TABLE IF EXISTS P2P_LFA1; will drop table P2P_LFA1 if it exists, if not, it won't do anything.

If you need further help, just let me know. 😉

Best Regards,

Mateusz Dudek