r/bigquery • • 15h ago

What’s the best way to build a BigQuery dashboard for business users? Row access is the part I’m stuck on though

1 Upvotes

So I’m putting together a dashboard on top of BigQuery for our team who don’t write SQL.

We have six regions, and each regional manager should see just their own rows. I guess they still need filters and drill-downs that work.

Where would you put that rule? In BigQuery with row access policies or authorized views, in the dashboard tool, or both? And does that change if every query runs through one shared service account?

On top of that, I’m also worried about the costs. As far as I remember, on-demand queries bill by bytes processed, so I don’t want every filter click scanning the whole table.

What setup kept access and costs easy to understand for you?