This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 89%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Unity Catalog-Error Creating Table ErrorClass=INVALID_STATE] Failed to access cloud storage: AbfsRestOperationException
I have managed to create my catalog and schema on unity catalog.
Added Storage Blob Contributor role to the unity catalog metastore in ADLS for the Access Connector for Azure Databricks.
however, when trying to create a table i received this error:
Error in SQL statement: UnityCatalogServiceException: [RequestId=db5e5795-bd62-4185-b97f-1d240ee5b73b ErrorClass=INVALID_STATE] Failed to access cloud storage: AbfsRestOperationException exceptionTraceId=094237f6-141c-44d7-85c7-104215baa913
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
I am experiencing the same issue using creating table on Unity Catalog
Hi hardrock,
Thank you for posting query in Microsoft Q&A Platform.
From error message, it seems there is an issue with accessing storage account.
Could you please confirm is this Azure data lake storage Gen2?
Also, could you please confirm you are using Azure managed identity here to grant roles? If yes, could you please try to grant Storage Blob Data Contributor role to your Azure managed Identity and see if that helps.
There may chances of we are missing or incorrectly confirmed something in databricks workspace or in storage account. Kindly go through below official documentation and cross check everything confirmed well.
https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/get-started
Hope this helps. Please let me know how it goes. Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
I am also experiencing this issue @hardrock @Tyler Frankenberg did you have any luck fixing this?
Hi Shaik,
yes i am using managed identity, azure databricks connector. i have also given the managed identity, storage blob contributor to the adls gen2 and the unity catalog container as well.
thats why i am confused, because all forums are suggesting to add this role when i already have.
Hi @ShaikMaheer-MSFT , yes im using managed identity and it has storage blob contributer to the ADLS GEN2.
however, im still having access issues with the same error. i am also using the global admin acc
Hi @hardrock, Just checking if below helps? If yes, consider hitting Accept Answer button. Accepted answers help community as well. Thank you.
No it doesn't help. I have unity catalog setup with MSI, I have given correct RBAC's to the connector to the storage account. I have also given the resource instance access to the connector in the firewall settings but it gives 403. Once I disable the storage account firewall, it works. But the whole point here is to not have firewall completely open.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 16%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Still hitting this problem 4 months later. I followed Han Raaijmakers link, did the curl steps, and still get this error message :-?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Hi @hardrock and the others,
I had the exact same issue and managed to fix it by 'upgrading' the Unity Calalog metastore using these instructions:
Good luck!
Hi @hardrock, Just checking if above helps? If yes, consider hitting Accept Answer button. Accepted answers help community as well.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 98%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
I was facing the same issue that I couldn't create a table after configuring the Unity catalog and I have done all the changes you have suggested above. The issue was because I hadn't enabled hierarchal namespace while making my storage. You have to enable the hierarchical namespace while making the storage and your issue will be resolved.
It's mentioned in the documentation too that Unlock Data Lake Storage capabilities by selecting the enable hierarchical namespace setting in the Advanced tab of the Create storage account page.
Hope so that i will resolve your error as it does mine's