This RADEN video shows how to detect ad hoc queries that may drive cost spikes during peak usage hour in Google BigQuery.
- Apply plan grading to identify potential inefficiencies and determine if most queries were scheduled and executed by service accounts, not ad hoc users.
- Identify any evidence if ad hoc queries were contributing to peak-hour cost increases.
- Learn how to isolate ad hoc queries more effectively, filtering by user accounts instead of service accounts.
