Forum Discussion
Can we implement RLS(row level security) in real time when data is getting streamed into destination
Hi Community Members,
Can we implement real time RLS in real time intelligence, when data is getting streamed into the eventhouse or lakehouse or any supported destination ? Is it possible to implement in the transformation phase or later part
Like i have one use case where i am getting real time data and i need to store those data into the destination say lakehouse but also maiantaining thr security (RLS), and then I am using this data to make the real time dashboard, where the refresh will happen very often while maintaining the data security.
Hi
Yes, RLS is indeed possible in Eventhouse. You can use the approach described in the docs from Microsoft.
I've found the link right here :Security roles - Kusto | Microsoft Learn
Especially the Row Level Security part of the docs (Row level security policy - Kusto | Microsoft Learn) is a good source to get you started...
2 Replies
Hi
Yes, RLS is indeed possible in Eventhouse. You can use the approach described in the docs from Microsoft.
I've found the link right here :Security roles - Kusto | Microsoft Learn
Especially the Row Level Security part of the docs (Row level security policy - Kusto | Microsoft Learn) is a good source to get you started...Hello ramankr48 ,
Yes you can implement RLS in eventhouse. Best to implement once you load data into eventhouse and want to use data for reporting or analytical purpose.KQL allows you to define Row-Level Security policies on tables within your Eventhouse. These policies are expressed as KQL queries that filter the data based on certain conditions.
you can follow below link :
https://learn.microsoft.com/en-us/kusto/management/row-level-security-policy?view=microsoft-fabric
Warm Regards,
