Skip to main content
Question

Clean up and remove imported data tables

  • November 4, 2022
  • 2 replies
  • 36 views

Hi all,

 

I am looking to remove some old data tables from our data pool and clean up the data pool. What is the best way to achieve this?

 

When I run a script to drop the tables, I am unable to execute it and receive the following error

"Cannot drop Table AFKO because other objects depend on it"

 

I have removed it from the data model and performed a full reload on the data model.

 

Thanks,

Michael

2 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

Hi Michael,

 

The following errors might occur in Celonis, this is done to improve Transformation run times for Data Job.

 

You can use the following query to remove tables

 

DROP TABLE TABLE_NAME CASCADE;

 

There is a detailed article by Celonis on the same kindly find the attached link for more information

 

https://docs.celonis.com/en/drop-failed-due-to-dependencies.html#UUID-f38d04d2-7c3f-c7ea-2496-ca47483c12b8_id_DROPfailedduetodependencies-RootCause

 


  • Author
  • Level 2
  • November 4, 2022

Perfect, thanks for your help