Question

Your finance team wants a weekly automated report attributing BigQuery on-demand query costs to individual users and teams so they can identify the most expensive recurring queries. You need a low-maintenance approach that does not require enabling additional export pipelines and can be scheduled to run without external tooling. What should you do?

Accepted Answer

Query the INFORMATION_SCHEMA.JOBS_BY_PROJECT view to aggregate total_bytes_billed by user_email and query, then wrap it in a scheduled query that writes results to a reporting table.

Answer

Enable Cloud Audit Logs export to a Cloud Storage bucket and build a Dataflow pipeline that parses the logs weekly to compute per-user cost.

Answer

Ask each user to manually record their query bytes from the BigQuery UI job history and submit them to a shared spreadsheet each week.

Answer

Enable the BigQuery billing export to a dataset and run a Data Fusion pipeline that joins billing rows to individual users by timestamp.