What problem does it solve? Optimizing BigQuery workloads requires deep understanding of capacity planning, storage billing models, table design, and query efficiency. This Skill automates cost analysis, architectural recommendations, and SQL rewrites to reduce slot time and data scanned. ## Core Features & Use Cases - Capacity & Editions Modeling: Evaluate On-Demand to Editions migrations and right-size reservations using the Slot Estimator. - Storage Optimization: Recommend physical vs. logical billing, design partitioning and clustering strategies, and manage retention policies. - SQL Query Optimization: Rewrite queries to reduce slot-time and data processed using 13+ proven optimization patterns. - Use Case: A company billing $50k/month on BigQuery runs a dashboard query that scans 2TB but returns only 50GB. Use this Skill to add partition filters, clustering, and materialized views to cut query costs by 70%. ## Quick Start Ask the skill to analyze your BigQuery dataset storage costs and recommend whether to migrate from on-demand billing to a 1-year edition commitment.