Authorization Issue while creating first Unity cat...

AliviaB · ‎06-19-2025

Hi All,

We are setting up our new UC enabled databricks workspace. We have completed the metastore setup for our workspace and we have created new catalog and schema. But while creating a table we are getting authorization issue. Below is the table script and error message.

CREATE TABLE IF NOT EXISTS mycatalog.myschema.department

(

deptcode INT,

deptname STRING,

location STRING

);

Error:shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.contracts.exceptions.AbfsRestOperationException) Operation failed: "This request is not authorized to perform this operation.", 403, GET, https://mystorageaccount.dfs.core.windows.net/mycontainer?upn=false&resource=filesystem&maxResults=5..., AuthorizationFailure, , "This request is not authorized to perform this operation. RequestId:7acf4e05-901f-0099-461e-e095ff000000 Time:2025-06-18T06:55:52.8249225Z"

Additional Information: We are using Azure Databricks connector as system assigned managed identity to ad access to mystorageaccount at storage account level. We have provided Storage Account Contributor, Storage Blob Data Contributor, Storage Queue Data Contributor and Storage Table Data Contributor roles to the connector.

We have also whitelisted the Databricks IP into storage account.

Any help regarding this issue will be very helpful.

#

Thanks

cgrant · ‎06-20-2025

Are there locations specified for the catalog/table/schema? Or do you keep these at defaults?

Also, do you have a storage credential and external location set for mystorageaccount/mycontainer?

Authorization Issue while creating first Unity catalog table