For saving APC consumption used data, how we can delete the loaded data for certain data pool which contains several processes in it. I want to delete one process data in the data pool.

Hi, what has worked for me is the following piece of code:

DROP TABLE IF EXISTS [Table] CASCADE;

Hi, APC consumption page is not real-time, delay about a day or so, If you already delete then you just need to wait for the APC page refresh. Studio data is different - it is store in data model (memory) which is different from the data pool / data scope.

So for APC consumption part, after deleting the tables for certain process I have done data load. So for reflecting it takes time right?

Yes, APC consumption page has refresh schedule.

Additional tips - while deletion can be your solution, I think ultimately you still need to review your design. Have you apply proper filter and only bring necessary data (eg. records and column)? How about sharing the data across data pool?

Vertica engine work differently for deletion, I recommend the https://academy.celonis.com/learning-paths/get-data-into-the-ems-1 especially "transformation best practice".

Thank you.

Thank you

Thank you