bigquery-optimization
Provides workflows to optimize BigQuery environments (capacity planning, editions), storage assets (partitioning, clustering, storage lifecycles, billing models), and SQL queries. Use when optimizing cost, modeling Edition migrations, rightsizing reservations, evaluating logical vs. physical storage, designing table partitioning/clustering, generating table DDL, migrating unpartitioned tables, managing partition expiration, optimizing individual SQL queries, or evaluating acceleration structures (search indexes, materialized views, BI Engine). Do not use for raw usage reporting (use bigquery-observability), query execution plan analysis, error troubleshooting, or diagnosing why a specific job was slow (use bigquery-troubleshooting).
- Version
- v1
- License
- Apache-2.0
Pinned to revision 6f4818a4c525, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/bigquery-optimization/SKILL.md
- skills/bigquery-optimization/references/bi_engine.md
- skills/bigquery-optimization/references/capacity_planning_editions.md
- skills/bigquery-optimization/references/materialized_views.md
- skills/bigquery-optimization/references/search_indexes.md
- skills/bigquery-optimization/references/sql_optimization.md
- skills/bigquery-optimization/references/storage_billing_models.md
- skills/bigquery-optimization/references/storage_lifecycle_management.md
- skills/bigquery-optimization/references/table_partitioning_clustering.md
Every link opens the file at its source, pinned to the revision this page describes.