Comment
05-05-2025
11:40 AM
05-05-2025
11:40 AM
Hi @Louis_Frolio ,
Great question! I should have included a section on Dynamic Views. I could think of several instances where Dynamic Views may be a better fit:
1. Since RLS/CM tables can't be used in Delta Sharing, Dynamic views can be leveraged in those situations.
2. RLS can be a single UDF per table, if there is a situation when multiple UDFs need to be used, Dynamic Views need to be used.
3. When access control required cross-table dependencies or multiple stage filtering, one would need to use Dynamic Views.
Let me know if you can think of other scenarios where Dynamic Views are a better fit. 🙂