Individual skill
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).
skills/cloud/bigquery-optimization/SKILL.md
Source commit 7954818330e3c1b8e8e43d092b9a048b9ed867a8
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Network or broad shell
- Last checked
- Nov 11, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 23,914
- Repository last updated
- Nov 11, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- google Repository topic
- googlecloud Repository topic
- skills Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 9,521 bytesSKILL.mdcore · 9,521 bytesSKILL.mdcore · 9,521 bytesSKILL.mdcore · 9,521 bytesSKILL.mdcore · 9,521 bytesreferences/attribution.mddoc · 1,903 bytesreferences/bi_engine.mddoc · 7,439 bytesreferences/capacity_planning_editions.mddoc · 7,148 bytesreferences/materialized_views.mddoc · 5,022 bytesreferences/search_indexes.mddoc · 4,151 bytesreferences/sql_optimization.mddoc · 24,066 bytesreferences/storage_billing_models.mddoc · 6,381 bytesreferences/storage_lifecycle_management.mddoc · 2,274 bytesreferences/table_partitioning_clustering.mddoc · 15,714 bytes
Read excerpt
# BigQuery Optimization Workflow
## Attribution
**MUST READ**: Before executing any `gcloud`, REST API, or MCP command, you
MUST read [Usage Attribution](references/attribution.md). For commands executed
directly in the terminal (never in generated scripts, Terraform, or user code),
prefix `gcloud` with
`CLOUDSDK_METRICS_REQUEST_ATTRIBUTION="agent-skills/1.0 (skill:bigquery-optimization)"`
and append `agent-skills/1.0 (skill:bigquery-optimization)` to `User-Agent` headers.
## Prerequisites & Environment Setup
Before executing optimization analyses, evaluating editions, or applying DDL