SkillOfficial
bigquery-optimization
Apache-2.0Updated on Nov 11, 202623,842GitHub stars
A Google skill with workflows for lowering BigQuery cost and speeding it up.
What the skill teaches
A Google skill with workflows for lowering BigQuery cost and speeding it up. It covers modelling a move from on-demand pricing to Editions and right-sizing reservations, choosing logical or physical storage billing, designing partitioning and clustering with ready DDL templates, setting partition expiry for inactive data, tuning single SQL queries, and judging when search indexes, materialised views or BI Engine help. Before work starts it asks for the Cloud SDK, the BigQuery and Reservation APIs, sign-in and suitable IAM roles. It pairs with Google's observability and troubleshooting skills but can be used alone. It is a SKILL.md with reference files.
Capabilities
- Model a move from on-demand pricing to Editions
- Recommend logical or physical storage billing
- Generate partitioning and clustering DDL
- Optimise individual SQL queries
- Evaluate search indexes, materialised views and BI Engine
Install
- Run this to add it to Any client:
npx skills add google/skills
What's inside
- references/attribution.md
- references/bi_engine.md
- references/capacity_planning_editions.md
- references/materialized_views.md
- references/search_indexes.md
- references/sql_optimization.md
- references/storage_billing_models.md
- references/storage_lifecycle_management.md
- references/table_partitioning_clustering.md
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | BigQuery | |
| Publisher | source | |
| Official status | Officialpublished in Google's own GitHub organisation; Google develops BigQuery | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 11, 202623,842 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
Sources
- Skill file (SKILL.md)github.com/google/skillsNov 10, 2026
- README (README.md)github.com/google/skills · Backs: Official statusNov 12, 2026
- Licence file (LICENSE)github.com/google/skills · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/google/skills · Backs: Publisher, Activity, LicenceNov 11, 2026
- Folder in the repository (bigquery-optimization)github.com/google/skills · Backs: Includes scriptsNov 10, 2026