RLS CLS Update Situation - request for help
Here's my setup: 1. we have RLS/CLS tables and the access related data in those tables changes periodically. 2. I'm building a warehouse on top of these RLS/CLS tables that needs to use DirectLake (and hence they need to be in Table form, not a view form). 3. Since these are Tables (mentioned in #2) need to be updated whenever RLS/CLS tables change, I need to have a pipeline that runs as soon as the RLS/CLS tables change. My question is: How is it done normally when we need to use Direct Lake? Are there any trigger mechanisms that are best suited for this situation?