Skip to content
Kitbay
Submit

bigquery-troubleshooting

Apache-2.0Updated on Nov 11, 202623,842GitHub stars

Google's skill for diagnosing BigQuery jobs that fail, run slowly or cost more than expected.

What the skill teaches

Google's skill for diagnosing BigQuery jobs that fail, run slowly or cost more than expected. It gives a step-by-step workflow for reading symptoms, isolating the bottleneck in a query plan or execution graph, and finding the root cause, plus a four-step funnel for cost spikes in on-demand spend, capacity slot autoscaling and storage growth. Reference files cover resource contention, configuration changes and plan stages. It expects the Cloud SDK, the BigQuery and Cloud Monitoring APIs and a signed-in account, and it hands SQL tuning and capacity planning to the optimisation skill. It is published in Google's skills repository.

Capabilities

  • Diagnose slow or failing BigQuery jobs
  • Read query plan stages to find bottlenecks
  • Trace cost spikes in compute and storage
  • Recommend remediation steps