Data engineering·Governance, privacy and meaning
the regional manager runs the same query as everyone else and only ever sees their own region's rows.
Row-level security
Also calledRLS, row filtering policy
A policy attached to a table that filters which rows a given principal may see. It lets one modelled table serve every audience instead of maintaining a copy per team, which is the alternative and the reason copies proliferate. The risk is subtle: an aggregate over filtered rows still looks like a complete answer, so a user can be confidently wrong without any indication that rows were removed.