Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When executing batch SQL queries against a BigQuery dataset by passing a SQL file to the BigQuery CLI and redirecting the output, you encounter a permission error. How should you resolve this issue?
A
Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
B
Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
C
Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI.
D
Create a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.
