Forum Discussion
Fabric Notebook to query KQL Database Using ManageIdentity
Hi abhiram342
Thanks for using Fabric Community.
Currently Managed Identity approach is not supported yet. You can use Workspace Identity if that helps. A Fabric workspace identity is an automatically managed service principal that can be associated with a Fabric workspace.
For more information please refer to this link:
https://learn.microsoft.com/en-us/fabric/security/workspace-identity
Hope this helps. Please let me know if you have any further queries.
Hi abhiram342 ,
I am not sure whether a Managed Identity approach exists for your matter. You could get the token via a service principal though. Here a similar use case where a token was fetched for the Fabric API. I suppose you could use that snippet, but with another scope (https://<yourKQLdatabaseURI>.z0.kusto.data.microsoft.com).
Of course, you would still need to securely retrieve the credentials for your service principal, probably from a Key Vault.
Let me know if this works 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks tackytechtom ! We don't want to maintain appSecret for app ( ex: rotation) hence looking for manage identity approach. Looks like it's not yet supported in fabric
Thanks,
Abhiram
Hi abhiram342
Thanks for using Fabric Community.
Currently Managed Identity approach is not supported yet. You can use Workspace Identity if that helps. A Fabric workspace identity is an automatically managed service principal that can be associated with a Fabric workspace.
For more information please refer to this link:
https://learn.microsoft.com/en-us/fabric/security/workspace-identity
Hope this helps. Please let me know if you have any further queries.
