Can we implement RLS(row level security) in real time when data is getting streamed into destination

[ramankr48]

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.

[divyed]

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,

[datacoffee · Accepted solution]

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