Skip to main content
Question

Data Consumption Limit Exceeded in my training cloud. How can I free up some space ?

  • December 28, 2021
  • 8 replies
  • 13 views
A
Level 6
Forum|alt.badge.img+9

In my training cloud one of the vendor details table(LFA1) got many records due to which my data consumption limit is already exceeded. How can I free up some space ?

8 replies

P
Level 8
  • paul.velth
  • Level 8
  • December 28, 2021

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

J
Level 5

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

A
Level 6
Forum|alt.badge.img+9
  • archit.agraw
  • Author
  • Level 6
  • December 29, 2021

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

A
Level 6
Forum|alt.badge.img+9
  • archit.agraw
  • Author
  • Level 6
  • December 29, 2021

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 ?

 

image.png

P
Level 8
  • paul.velth
  • Level 8
  • December 30, 2021

Hello Archit,

 

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

 

Best Regards,

Paul Velthuis

A
Level 6
Forum|alt.badge.img+9
  • archit.agraw
  • Author
  • Level 6
  • December 30, 2021

Hello Archit,

 

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

 

Best Regards,

Paul Velthuis

HI Paul, It’s started from yesterday and it’s same till now. As per your suggestion it should be up today but it’s not. Can we clean this data from my training cloud ? [EY logo] Archit Agrawal | Intelligent Automation | GDS Consulting Ernst & Young 8th Floor, Summit B, Brigade Metropolis, Whitefield Road, Mahadevapura Post, 560048, Bangalore, India Mobile: +91 9601581825 | archit.shankarlal.agrawal@gds.ey.com Website: http://www.ey.com
M
Level 4

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

A
Level 6
Forum|alt.badge.img+9
  • archit.agraw
  • Author
  • Level 6
  • January 2, 2022

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

HI Mateusz, Thanks for providing detailed steps. It was already resolved. [EY logo] Archit Agrawal | Intelligent Automation | GDS Consulting Ernst & Young 8th Floor, Summit B, Brigade Metropolis, Whitefield Road, Mahadevapura Post, 560048, Bangalore, India Mobile: +91 9601581825 | archit.shankarlal.agrawal@gds.ey.com Website: http://www.ey.com
Community Code of ConductAccessibility statement