topic Re: Error deleting a table in Data Engineering

Error deleting a table

ronaldolopes — Mon, 29 Aug 2022 17:37:44 GMT

I'm trying to delete a table that was created from a csv and due to the file deletion, I can't execute the deletion, with the following error: I'm new to Databricks and I don't know how to fix this. Some help?

Re: Error deleting a table

AmanSehgal — Wed, 31 Aug 2022 04:06:56 GMT

To delete the table, it's looking for underlying delta log file and because the file doesn't exist, it's throwing you that error.

Just drop the table.

drop table <table_name>

Re: Error deleting a table

jose_gonzalez — Fri, 09 Sep 2022 23:56:14 GMT

You have a managed table, so when you do 'drop table <table_name>' it will remove the underlining data + metadata. If this was an external table, then a "drop table <table_name>" will not remove the data associated to the table. I just thought about sharing this, to show the difference between managed and unmanaged (external) tables