Your question is Secure Row-Level Dashboard Pipelines. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are building the data pipeline behind a reporting dashboard for a B2B SaaS product. Different user groups can only see rows tied to their account, region, or business unit, and some metrics must be hidden entirely from certain roles. The dashboard reads from curated warehouse tables, so the pipeline has to apply access rules before data reaches the serving layer.
How do you handle row-level security or restricted views in a reporting dashboard?