Delta Table is not available in the Databricks SQL

dimsh
Contributor

Hi, there!

I'm trying to read a data (simple SELECT * FROM schema.tabl_a) from the "Queries" Tab inside the Databricks SQL platform, but always getting "org.apache.spark.sql.AnalysisException: dbfs:/.../.. doesn't exist" DescribeRelation true, [col_name#121543, data_type#121544, comment#12154 error.

What I've done:

-- Mount ADLS folder to DBFS one from the Databrikcs Engineering module

-- Created external table via simple DDL statement:

%sql
CREATE TABLE IF NOT EXISTS schema.table_a
USING DELTA 
LOCATION '/mnt/some_path/delta';

--Then I go to the Databrikcs SQL extension and try to get the data from the same table.

-- I've tried to get the data from the Databricks Engineering tool and it works well, instead of Databricks SQL one.

Any suggestions about that?