Question

Your data team runs ad hoc analytics on BigQuery using on-demand (per-TB) pricing. Last month a few analysts accidentally ran full-table scans on multi-terabyte tables, causing an unexpected spike in your bill. Leadership wants to prevent any single analyst from consuming an excessive amount of on-demand bytes while keeping the flexible on-demand model for exploratory work. What is the most effective way to enforce this?

Accepted Answer

Configure per-user and per-project custom query quotas (maximum bytes billed per day) at the project level

Answer

Purchase a flat-rate slot commitment and place all analysts in a single reservation

Answer

Enable BigQuery BI Engine to cache query results and reduce bytes scanned

Answer

Set a maximum bytes billed limit only in each individual analyst's saved query settings