QuestionQ67

VerifiedData Management

You are designing an application that will work with several BigQuery datasets. You must grant the application's service account permissions to query and update tables in those datasets, and to list every dataset in a project from within the application. You want to adhere to the principle of least privilege. Which predefined IAM role(s) should be assigned to the service account?

Explanation

The BigQuery Job User role provides bigquery.jobs.create, which is required to run query jobs. The BigQuery Data Owner role grants all permissions on a dataset and its tables, including querying and updating table data; when granted at project scope, it also enables listing datasets in the project that the principal can access. This combination meets the required job-execution and dataset/table access capabilities without granting the broader BigQuery Admin role.

Learn more

Community Discussion

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