Skip to main content

Fabric platform

New

Filter and RLS on OneLake shortcuts

Vote (4) Share
Frithjof Vassbø's profile image

Frithjof Vassbø on 09 Nov 2024 18:20:31

Make it possible to apply a Filter or RLS (Row Level Security) on OneLake shortcuts.


For example:


We have a central workspace which holds data for the entire organization. We have a giant fact table with data for all departments in the organization.


We would like to create shortcuts from each department's workspace to the central fact table, but we would like each shortcut to only have access to that department's data.


So we need the ability to apply filter or RLS to the shortcut.

Comments (1)
Frithjof Vassbø's profile image Profile Picture

R T on 11 Nov 2024 15:20:30

RE: Filter and RLS on OneLake shortcuts

Agreed. Having the ability to govern what gets propagated via shortcuts would be a massive help and also work toward a better "OneCopy" approach to data in OneLake. In cases where you want certain lakehouses/workspaces to only house specific data, the only current option is to basically duplicate data into a lakehouse.