I am trying to create a new external table (kind=delta) in Azure Data Explorer.
My code is standard:
.create-or-alter external table external_someexport
(col1:int, col2:int, mydate:datetime )
kind=delta
(
h@'https://mystorageaccount.dfs.core.windows.net/mydir/;managed_identity=system)'
)
Now I am getting a strange error pointing towards the use of managed identity:
"code": "Internal service error", "message": "Request aborted due to an internal service error.", "@type": "Kusto.Common.Svc.Exceptions.InvalidStorageConnectionStringsManagedIdentityException", "@message": "Invalid storage connection strings. When using managed identity authentication, all connection strings must reference the same managed identity."
What does that error mean ? I cannot change the MI at all in the code as it is just managed_identity=system. All my other tables are using the managed_identity=system, too.
The error message you’re seeing indicates that your external table references multiple connection strings, which not all use the same managed identity.
In the example you’re providing, that error message should not be returned. Are you certain it’s the same one that generated the error?
Thanks,
Shani