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
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
Perfect, thanks for your help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
