Error: The associated location ... is not empty but it's not a Delta table

Chris_Konsur
New Contributor III

I try to create a table but I get this error: AnalysisException: Cannot create table ('`spark_catalog`.`default`.`citation_all_tenants`'). The associated location ('dbfs:/user/hive/warehouse/citation_all_tenants') is not empty but it's not a Delta table

I checked the table location dbutils.fs.ls('dbfs:/user/hive/warehouse/') and there is the table with size= 0.

FileInfo(path='dbfs:/user/hive/warehouse/citation_all_tenants/', name='citation_all_tenants/', size=0, modificationTime=1678202578000),

I tried to delete table using this command dbutils.fs.rm('dbfs:/user/hive/warehouse/citation_all_tenants',recurse=True) but it does not remove it. My question is how to how to delete and recreate the table?