On june 2024, Google introduced conditional access to Bigquery tables based on tags. This would be the best way to provide such privileges to a certain group of users.

Sources:
https://medium.com/codex/you-can-now-use-tags-for-bigquery-access-5b5c50fcf349
https://cloud.google.com/bigquery/docs/release-notes