Forum Discussion
Policy Update: How configured property Managed Intentity
I want in an update policy to use in the Query property, a function that references tables in another KQL DB, it tells me that I should configure the policy with the manageidentity property but I can't find relevant information, does anyone have any idea how to do it?
Thanks
Hi Anonymous,
We sincerely appreciate your inquiry submitted through the Microsoft Fabric Community Forum.
Please kindly follow the steps outlined below, which may help resolve the issue:
- Enable a Managed Identity on your Cluster. You may use either a system-assigned or user-assigned managed identity. This identity facilitates secure cross-database access without the need for hardcoded credentials.
- Authorise the Managed Identity for Automated Flows. Configure your cluster or database policy to permit this identity for automation purposes.
- Grant Access to Referenced Databases. The managed identity must be granted at least viewer permissions on all external databases accessed by your query.
- Define the Update Policy Using the Managed Identity. While setting your update policy, ensure that the managed identity is referenced so it can securely access the external data.
Additionally, please refer to the following links for further information:
Run an update policy with a managed identity - Kusto | Microsoft Learn
Update policy overview - Kusto | Microsoft LearnIf you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
1 Reply
Hi Anonymous,
We sincerely appreciate your inquiry submitted through the Microsoft Fabric Community Forum.
Please kindly follow the steps outlined below, which may help resolve the issue:
- Enable a Managed Identity on your Cluster. You may use either a system-assigned or user-assigned managed identity. This identity facilitates secure cross-database access without the need for hardcoded credentials.
- Authorise the Managed Identity for Automated Flows. Configure your cluster or database policy to permit this identity for automation purposes.
- Grant Access to Referenced Databases. The managed identity must be granted at least viewer permissions on all external databases accessed by your query.
- Define the Update Policy Using the Managed Identity. While setting your update policy, ensure that the managed identity is referenced so it can securely access the external data.
Additionally, please refer to the following links for further information:
Run an update policy with a managed identity - Kusto | Microsoft Learn
Update policy overview - Kusto | Microsoft LearnIf you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.