QuestionQ71

VerifiedIntegrating applications with Google Cloud services

An analytics system runs queries against a BigQuery dataset. The SQL query runs in batch, passes the contents of a SQL file to the BigQuery CLI, and then redirects the BigQuery CLI output to another process. However, the BigQuery CLI returns a permission error when the queries run.

You want to fix the issue. What should you do?

Explanation

BigQuery query execution requires bigquery.jobs.create in the project where the job runs and read access to every referenced table or view. The BigQuery Job User role grants query-job creation, and the BigQuery Data Viewer role grants access to query the dataset data.

Learn more

Community Discussion

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