Currently trying to connect a table on external location and it fails with error -

[UNAUTHORIZED_ACCESS] Unauthorized access: PERMISSION_DENIED: request not authorized SQLSTATE: 42501

which seems like a pretty straight forward error but unable to find permission issue as able to browse that same external location from catalog browser .

Able to create volume as well on that external location however while trying to create table like below -

CREATE TABLE IF NOT EXISTS main.default.ab_test
USING DELTA
LOCATION 'abfss://lake-container@account.dfs.core.windows.net/tenants/data/warehouse/testing';

it throws the error on permission
External location created on abfss://lake-container@account.dfs.core.windows.net/tenants/data/warehouse and able to browse the directory testing from catalog browser
This location has parquet files as well as delta log directory