Skip to main content

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

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!