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(22.400000000000002, 63%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I fallowed the docs https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/get-started but I can not make the table in workspace main catalog. why the error occur?
the error message is that
Error in SQL statement: UnityCatalogServiceException: [RequestId=1f3c07ef-0876-4d8c-a0ed-a3ba70842f95 ErrorClass=INVALID_STATE] Failed to access cloud storage: AbfsRestOperationException exceptionTraceId=e00354de-3968-4dd7-9bd1-9715e6d28264
com.databricks.backend.common.rpc.SparkDriverExceptions$SQLExecutionException: com.databricks.sql.managedcatalog.UnityCatalogServiceException: [RequestId=1f3c07ef-0876-4d8c-a0ed-a3ba70842f95 ErrorClass=INVALID_STATE] Failed to access cloud storage: AbfsRestOperationException exceptionTraceId=e00354de-3968-4dd7-9bd1-9715e6d28264
at com.databricks.managedcatalog.ErrorDetailsHandler.wrapServiceException(ErrorDetailsHandler.scala:33)
at com.databricks.managedcatalog.ErrorDetailsHandler.wrapServiceException$(ErrorDetailsHandler.scala:23)
at com.databricks.managedcatalog.ManagedCatalogClientImpl.wrapServiceException(ManagedCatalogClientImpl.scala:91)
at com.databricks.managedcatalog.ManagedCatalogClientImpl.recordAndWrapException(ManagedCatalogClientImpl.scala:3021)
at com.databricks.managedcatalog.ManagedCatalogClientImpl.createStagingTable(ManagedCatalogClientImpl.scala:511)
at com.databricks.sql.managedcatalog.ManagedCatalogCommon.defaultTablePath(ManagedCatalogCommon.scala:234)
at com.databricks.sql.managedcatalog.ManagedCatalogSessionCatalog.defaultTablePath(ManagedCatalogSessionCatalog.scala:934)
at com.databricks.sql.transaction.tahoe.catalog.DeltaCatalog.$anonfun$createDeltaTable$9(DeltaCatalog.scala:178)
at scala.Option.getOrElse(Option.scala:189)
at com.databricks.sql.transaction.tahoe.catalog.DeltaCatalog.$anonfun$createDeltaTable$1(DeltaCatalog.scala:178)
at com.databricks.spark.util.FrameProfiler$.record(FrameProfiler.scala:80)
at com.databricks.sql.transaction.tahoe.metering.DeltaLogging.recordFrameProfile(DeltaLogging.scala:265)
at com.databricks.sql.transaction.tahoe.metering.DeltaLogging.recordFrameProfile$(DeltaLogging.scala:263)
at com.databricks.sql.transaction.tahoe.catalog.DeltaCatalog.recordFrameProfile(DeltaCatalog.scala:85)
at com.databricks.sql.transaction.tahoe.catalog.DeltaCatalog.com$databricks$sql$transaction$tahoe$catalog$DeltaCatalog$$createDeltaTable(DeltaCatalog.scala:113)
at com.databricks.sql.transaction.tahoe.catalog.DeltaCatalog$StagedDeltaTableV2.$anonfun$commitStagedChanges$1(DeltaCatalog.scala:758)
at com.databricks.spark.util.FrameProfiler$.record(FrameProfiler.scala:80)
at com.databricks.sql.transaction.tahoe.metering.DeltaLogging.recordFrameProfile(DeltaLogging.scala:265)
at com.databricks.sql.transaction.tahoe.metering.DeltaLogging.recordFrameProfile$(DeltaLogging.scala:263)
My Query is
Create table main.default.test as select * from samples.nyctaxi.trips
the table samples.nyctaxi.trips is exist.
and I attache the error capture.
please check about it.
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello @최 규호 ,
Welcome to the MS Q&A platform.
The error message suggests that a failure occurred in a SQL statement due to a problem accessing cloud storage. An issue could cause by the firewall settings or an invalid state of the storage account.
Can you please check your firewall settings and also ensure the storage account is in a valid state.
hi BhargavaGunnam-MSFT I checked about it. i tested stnadard v2 and premium both cases. and Didn't use Storage account Firewall. I Set the network setting all Internet. and I assigned the Connector to Storage Account Blob Contributer.
But It still occured.
please check about it.
12345
Hello @최 규호 ,
Thank you for the reply. Currently, I am checking with my internal team on this issue. I will get back to you as soon as I hear from them.
Hello @최 규호 ,
I am still waiting for a response from my internal team. If this is a priority request, please submit a support request so the support engineer can directly work with you to collect the logs to troubleshoot the issue further. Please let me know if you need any help with the support request.
Hello @Bhargava-MSFT
I will wait the answer. I think it is very critical issue but I did just test. and I wanna know why the error occur.
thank you.
Hello @최 규호 ,
Here is an update from my team on this issue.
This could be due to incorrect credentials or incorrect configuration of the connection to the storage account.
Please check the credentials and configuration settings to ensure they are correct. Also, please check if there is any problem with the permissions.
If the issue persists, please log a support ticket for further investigation. If you don't have a support plan, we can enable one-time free support for you to work closely on this matter.
I am looking forward to hearing from you.
Hello @Bhargava-MSFT
I knew the reason. It cannot get the creadential_id of azure_maneged_identity If I create by GUI.
I think It is bug of Azure data bricks. please check it.
[If Just Create by GUI]
[Right One]
Hello @최 규호 ,
I am checking to see if you got a chance to look into my earlier response. Please let me know if you have any further questions.
Hello BhargavaGunnam-MSFT this issue was solved. I think Databricks updated. thank you for your helps.
Thank you, 최 규호