What problem does it solve? BigQuery incidents—slow queries, cost spikes, and execution failures—require rapid root-cause diagnosis across performance bottlenecks, reservation saturation, and billing models. Manual telemetry collection and multi-stage reasoning consume hours. This Skill automates the diagnostic funnel to isolate the root cause and recommend remediation in minutes. ## Core Features & Use Cases - Performance Troubleshooting: Diagnose single-job stage bottlenecks (join explosions, shuffle spills, slot contention) and compare against historical baselines to isolate slowdowns. - Compute Cost Diagnosis: Pinpoint whether cost spikes stem from the "Bully Query" (unpartitioned scans), BQML training rates, RLS redaction, On-Demand volume surges, capacity commitment expirations, or autoscaler thrashing. - Storage Cost Investigation: Identify historical partition 90-day timer resets (the DML trap), unpartitioned table active traps, Time Travel and Fail-Safe churn on physical billing, and dropped table drain periods. - Configuration Audits: Track reservation slot capacity changes, commitment timelines, baseline reductions, and assignment reconfigurations correlated with performance regression windows. - Use Case: Your BigQuery bill jumped 40% overnight. Use this Skill to scan the last 7 days against the prior week, isolate whether the spike stems from On-Demand query volume, capacity commitment expiration, or storage tier promotion, then recommend concrete remediation (partition enforcement, commitment renewal, or Time Travel reduction). ## Quick Start Analyze why BigQuery queries have been running slower over the past two days by comparing today's performance metrics against the same timeframe from last week.