BigQuery slot and cost optimizer

This skill equips AI agents and cloud engineers with procedural heuristics to analyze BigQuery resource consumption, calculate slot hours, identify slot contention and queueing, mitigate Cartesian joins, and optimize unpartitioned table scans.

Trigger conditions and intent mapping

Activate this skill whenever the user asks to:

• "Optimize BigQuery query performance or reduce slot usage"
• "Find the most expensive queries in BigQuery"
• "Diagnose BigQuery slot contention or queueing"
• "Fix slow running BigQuery jobs or memory spillage"
• "Detect Cartesian joins or row count explosions in BigQuery"
• "Identify unpartitioned table scans or missing partition filters"

Prerequisites and environment setup

Before executing this skill, ensure the environment is configured with the necessary SDKs, permissions, and billing: