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.
How would you design row-level security for dashboards used by multiple client accounts?
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.
How would you design row-level security for dashboards used by multiple client accounts?
