Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
abhiram342
Employee
Employee

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

1 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.

View solution in original post

3 REPLIES 3
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

Top Kudoed Authors