AC-004
Dynamic Views for Row and Column Filtering
MEDIUMAccess ControlLow Complexity1-2 hours per view
Description
Use dynamic views to implement row-level and column-level security using SQL logic, providing a lightweight alternative to ABAC policies for teams that need fine-grained filtering without the complexity of governed tags
Prerequisites
- →Unity Catalog enabled
- →Source tables registered in Unity Catalog
- →Understanding of which rows/columns to filter per group
Impact Analysis
Security
Improves security posture
75%
Compliance
Meets compliance requirements
70%
Complexity
Implementation complexity
25%
Cost
Resource cost impact
5%
Required Permissions
Catalog Owner or Schema Owner