QuestionQ109

VerifiedStoring the data

You are moving your data warehouse to BigQuery. All data has been migrated into tables within a dataset. Multiple users in your organization will use this data, but they must be able to view only particular tables according to their team membership. How should user permissions be configured?

Explanation

Authorized views expose only the selected table data while withholding direct access to the underlying source tables. BigQuery requires an authorized view to be in a dataset different from the source-data dataset. Authorizing those views against the source dataset and granting each team Data Viewer access only to its view dataset enforces team-specific access without granting access to the underlying dataset.

Learn more

Community Discussion

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