Deleting obsolete tables and uploaded files in Data Pool

Question

Hi all,I have a question relating to “hygiene” in data pools.In my organisation we use manual data ingestion and upload files into our data pools. Over time, a large number of files and tables was added and created. I’d like to do a bit of house-keeping and remove obsolete/ unused files. How can I do that? I have analyst access.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Vladimir.Puskaric · Accepted Answer

Hi Navya,thanks for your response and highlighting the importance of dropping tables. Will definitely do that.What I didn’t fully understand is how to delete obsolete uplodaded files. Or do I just drop them, as well?I look forward to receiving your clarification. Thanks!Kind regards,Vladimir

Navya K · Answer

Hey there!Removing tables created from file uploads in Celonis requires action in the Transformation Workbench, as simply deleting the file from the UI is insufficient. While the UI removal only clears the file from the list, it does not free up storage or remove the associated table in the backend database. To permanently delete the table and reclaim storage space, you must navigate to Data Integration → Data Jobs → Transformations and execute a DROP TABLE "file_name"; statement, making sure to replace "file_name" with the exact name of the table created during the upload. For efficiency, particularly when dealing with many obsolete files, it is crucial to first review metadata to identify tables that are truly unused, and for bulk cleanup, you should generate and execute a list of individual DROP TABLE statements. If necessary, the entire data pool can be deleted, but all running jobs and dependencies must be stopped beforehand. Let me know if it helps!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded