QuestionQ120

VerifiedConfiguring access and security

Your company has a Google Cloud project that uses BigQuery for data warehousing. Your data science team changes frequently and has few members.

You need to allow members of this team to perform queries, following Google-recommended practices.

What should you do?

Explanation

Because group membership changes often, Google recommends creating a dedicated Google group (in Cloud Identity) and adding the data scientists to it, then granting IAM roles to the group rather than to individual user accounts. This avoids having to modify IAM policies each time a team member joins or leaves. To let members actually run queries (BigQuery jobs), the group must be granted the BigQuery Job User (roles/bigquery.jobUser) role, which grants permission to run jobs, including queries, within the project. The BigQuery Data Viewer (roles/bigquery.dataViewer) role only provides read access to data and metadata and does not include the bigquery.jobs.create permission needed to execute query jobs.

Learn more

Community Discussion

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