Fabric Notebook to query KQL Database Using ManageIdentity

[abhiram342]

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

[tackytechtom]

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/

[abhiram342]

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

[Anonymous · Accepted solution]

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.