What should you do?

Your analytics system executes queries against a BigQuery dataset. The SQL query is executed in batch and passes the contents of a SQL file to the BigQuery CLI. Then it redirects the BigQuery CLI output to another process. However, you are getting a permission error from the BigQuery CLI when the queries are executed. You want to resolve the issue.

What should you do?
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.

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments