QuestionQ85

VerifiedStoring the data

You need to store your team’s shared tables in one dataset so the data is readily available to multiple analysts. The data must be readable by analysts but not modifiable by them. At the same time, you need to give analysts individual workspaces in the same project where they can create and store tables for their own use, without those tables being accessible to other analysts. What should you do?

Explanation

BigQuery Data Viewer grants read access to the shared dataset without allowing table modifications. Assigning BigQuery Data Editor separately at the dataset level gives each analyst write access only to their own dataset, preserving isolation from other analysts’ tables.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!