Not able to Access tables in Databricks Community Edition

MB1 — Sun, 15 May 2022 05:50:19 GMT

Hi Databricks Community,

I am using databricks community Edition and after I logout and login next time and try to query the tables that were created earlier , I get the below error

Error in SQL statement: AnalysisException: Table or view not found: students; line 1 pos 14;
'Project [*]
+- 'UnresolvedRelation [students], [], false

However when I check in _delta_logs , I still see files related to the tables.

%python
display(dbutils.fs.ls("./user/hive/warehouse/students/_delta_log/"))

And if I try to create the same table again , it gives the below error

%sql
CREATE TABLE students
  (id INT, name STRING, value DOUBLE);
 
 
Error in SQL statement: AnalysisException: Cannot create table ('`spark_catalog`.`default`.`students`'). The associated location ('dbfs:/user/hive/warehouse/students') is not empty but it's not a Delta table

Can someone please help me understand if I am missing anything

topic Not able to Access tables in Databricks Community Edition in DELETE

Not able to Access tables in Databricks Community Edition