I was getting the exact same error when trying to work with a newly created metastore in Azure Databricks.

Ended up having to follow the 'upgrade' steps located here:

https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/azure-managed-ident...

Basically need to run the set of cURL commands to re-create the storage credential and hook it up to the metastore. These needed to be run as the Azure account admin.

Once I did that I was able to create tables.