Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.

Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.
A . Connect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the amount of queries per user.
B. In the BigQuery interface, execute a query on the JOBS table to get the required information.
C. Use ‘bq show’ to list all jobs. Per job, use ‘bq Is’ to list job information and get the required information.
D. Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query
operation to get the required information.

Answer: D

Explanation:

https://cloud.google.com/bigquery/docs/managing-jobs

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments