What is the most effective method to manage user permissions in a BigQuery data warehouse for multiple teams, ensuring each team only accesses specific tables based on their team membership?

Real Exam

Create authorized views for each team in datasets created for each team. Grant data viewer access to the authorized views for the dataset where the data resides, and grant data viewer access to the datasets where the authorized views reside for the users/groups.

63.6%

Grant data viewer access to the users/groups at the table level for each table.

9.1%

Create SQL views for each team in the same dataset as the data and grant data viewer access to the SQL views for the users/groups.

9.1%

Create authorized views for each team in the same dataset as the data and grant data viewer access to the authorized views for the users/groups.

18.2%

Google Professional Data Engineer

Get started today

Comments

What is the most effective method to manage user permissions in a BigQuery data warehouse for multiple teams, ensuring each team only accesses specific tables based on their team membership?