RLS CLS Update Situation - request for help

Here's my setup:

we have RLS/CLS tables and the access related data in those tables changes periodically.
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).
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?

1 comment