Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,514 questions
Not able to create the CREATE STORAGE CREDENTIAL as storage credential is not recognized command in azure databricks
![](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(163.2, 44%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
padam
0
Reputation points
I am trying to create the external location using the command . when I run the command then it does not recognize the storage credential then i can't run the external location command also. please help so that i can run the migrate table command in ucx.
CREATE STORAGE CREDENTIAL my_storage_credential WITH IDENTITY = 'ManagedIdentity';
CREATE EXTERNAL LOCATION ucx_external_loc
URL 'abfss://******@storageucx.dfs.core.windows.net/ucx/'
WITH CREDENTIAL my_storage_credential;
Azure Databricks
{count} votes
-
![](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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator2025-06-27T01:56:07.02+00:00 It looks like you're encountering an error because the
CREATE STORAGE CREDENTIALcommand isn't recognized. This typically happens when the Unity Catalog (UC) isn't enabled or the command is being run in the wrong context.Here are few troubleshooting steps that might help you.
Unity Catalog Requirement
The
CREATE STORAGE CREDENTIALcommand is supported only in Unity Catalog. Please confirm that,- Your workspace is attached to a Unity Catalog metastore (check under Admin Console > Metastore).
- You're using a SQL Warehouse, not a classic cluster.
- You're not working in the default
hive_metastore.
To confirm you’re in the right context, run:
SELECT current_catalog(), current_schema();If you see
hive_metastore, switch to a SQL Warehouse attached to Unity Catalog.Permissions required
You need the following:
CREATE STORAGE CREDENTIALandCREATE EXTERNAL LOCATIONprivileges on the metastore.In Azure, the workspace-managed identity (or any user-assigned managed identity you're referencing) must have the following roles on the Storage Account or container:
- Storage Blob Data Reader
- Storage Blob Data Contributor
Correct SQL Syntax (Example)
Once you're in the right context:
CREATE STORAGE CREDENTIAL my_storage_credential WITH IDENTITY = 'ManagedIdentity'; CREATE EXTERNAL LOCATION ucx_external_loc URL 'abfss://******@storageucx.dfs.core.windows.net/ucx/' WITH CREDENTIAL my_storage_credential;If using a user-assigned managed identity, specify its resource ID like this:
WITH IDENTITY = 'ManagedIdentity' ON '<<resource-id>>';Still Not Working?
Run the following in your SQL Warehouse to confirm UC context:
SHOW STORAGE CREDENTIALS;If this fails too, it's a strong indicator that you're not in a UC-enabled workspace or warehouse. In that case, please confirm:
- You're in the SQL persona using a SQL Warehouse
- The warehouse is attached to Unity Catalog
I hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
-
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
2025-06-27T19:22:44.66+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
padam 0 Reputation points
2025-06-28T05:57:51.0866667+00:00 I had tried the way as you mentioned but it still does not recognize the command for Storage Credentials. Thanks
Sign in to comment
Sign in to answer