karthik_p
Databricks Partner

@Hubert Dudek​ Ya you are right, when we enable UC and create external table using external location, we are able to view using select stameent from notebook (we need to run access key code), but when we add access key to cluster or sql warehouse and login to data-->hive_metastore, we are able to see table, but when we click on table we are getting issue.

please find below query

CREATE EXTERNAL TABLE test.hiveextmount

USING delta

LOCATION 'abfss://testcontainer@testexternalstore.dfs.core.windows.net/tables'

SELECT * from CSV.`abfss://testcontainer@testexternalstore.dfs.core.windows.net/tables`;

as per data bricks if we enable UC also and if we are not specifying catalog, we should be able to create external/managed tables in hive_metastore which is default metastore. we are able to view old tables that we created using mount when we are on wasbs type. after changing wasbs to abfss and using above query when we create table then we started seeing issue.

if we create table under new catalog which 3 level namespace, that works fine. but as a backup we are cheking for hive_metastore also, as UC has lot of limitations

karthik.p