Forum Discussion
Fabric Notebook to query KQL Database Using ManageIdentity
Hi Team,
We want to process data from Kusto Database using fabric notebook with Managed Identity Auth. I referred this blog Use Fabric notebooks with data from a KQL database - Microsoft Fabric | Microsoft Learn and don't see option for User Or System Assigned Managed Identity. Currenlty, it's using my identity to generate token and we want to use either User Assigned Managed Identity. Please Provide your suggestions. ( we want to add User Assigned Managed Identity as Reader role on Kusto Database)
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.
3 Replies
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.
