szymon_dybczak
Esteemed Contributor III

So, since you're using databricks community edition I'm assuming that you're dealing with Hive metastore.
You can try following:

1. Go to Settings 

szymon_dybczak_0-1758130627296.png

2. Now go to Advance (2) and turn on DBFS File Browser (3)

szymon_dybczak_1-1758130708447.png

 

3. Now, click Catalog (4), then DBFS(5) and go to users -> hive -> warehouse and check if you can find the table that you want to delete (Country).

4. If the table is there, copy path to the table (just like I did for flattened_source table in screen below)

szymon_dybczak_3-1758131344216.png

 

5. Then remove all files using dbutils.fm.rm

dbutils.fs.rm(dir="dbfs:/user/hive/warehouse/invoices_bz", recurse=True)

6. Double check that there are no files in your ADLS related to Country table

7. Try to recreate it.