DESCRIBE EXTERNAL LOCATION <your_external_location_name>;

External Location Name: metastore_root_location

Path: abfss://[email protected]/

Credential / Access Connector: dbac-dbm-id-dbr-neu-001

1 = Error when creating a new table using UI Error creating table Please check your Azure Firewall - Full error message: Your request failed with status FAILED: [BAD_REQUEST] This Azure storage request is not authorized. The storage account's 'Firewalls and virtual networks' settings may be blocking access to storage services. Please verify your Azure storage credentials or firewall exception settings.

[QUERY_RESULT_WRITE_TO_CLOUD_STORE_PERMISSION_ERROR] The workspace internal storage configuration prevents Databricks from accessing the cloud store. SQLSTATE: 42501

container = "" account = "" path = "<optional/subdir>" # "" if listing the root

uri = f"abfss://{container}@{account}.dfs.core.windows.net/{path}" display(dbutils.fs.ls(uri)) # If you see entries, READ is working

SQL to create table

CREATE SCHEMA IF NOT EXISTS my_catalog.my_schema;

CREATE TABLE my_catalog.my_schema.dummy_table (

id INT,

name STRING,

created_at TIMESTAMP

)

USING parquet

LOCATION '@metastore_root_location/dummy_table';

Error after assigning users to UC metastore [RequestId=0be41d10-5334-4743-adbf-e665f1641132 ErrorClass=INVALID_PARAMETER_VALUE.INVALID_PARAMETER_VALUE] Missing cloud file system scheme