Metastore Root Storage (Managed Location)

• This is a mandatory storage path if you want to create managed catalogs.
• It’s essentially the “default warehouse” location where Unity Catalog can create tables, databases, and managed data.
• Path must exist in your Azure Data Lake Storage Gen2 container. Simply having a Data Connector is not enough.

Proposed solution try the below

Create a Storage Credential

I would recommend use service principal as it enables RBAC-based access.

Set Metastore Root Storage (Mandatory if you want Managed Catalogs)

• In Admin Console → Metastore → Settings → Storage Root,

Create the Catalog

Once the storage root or an external location is ready:

• Managed catalog (uses metastore root):

If you skip the location and the metastore root isn’t set, you’ll get the error you saw.