Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Design Row-Level Security Pipeline

HardPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Design Row-Level Security Pipeline. 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 need to log in / sign up to chat or submit.

Problem

Scenario

You are designing the data pipeline behind shared dashboards used by multiple client accounts in a B2B analytics product. Each client should only see rows tied to its own account, even when the same dashboard, semantic layer, and warehouse tables are reused across tenants. The team needs a design that supports self-service access, auditability, and safe backfills when client mappings change.

Question

How would you design row-level security for dashboards used by multiple client accounts?