QuestionQ110

VerifiedDesigning for security and compliance

A BigQuery project contains several users. For auditing, you need to determine how many queries each user executed during the past month. What should you do?

Explanation

The project-level INFORMATION_SCHEMA.JOBS view contains metadata for all BigQuery jobs in a project, including user_email, creation_time, and job_type. Filtering it to last-month QUERY jobs and grouping by user_email produces the per-user query counts; its job history retention covers the requested period.

Learn more

Community Discussion

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