Skills · SkillData & AIData pipelinesReviewed

bigquery-optimization

Workflows to optimize BigQuery cost and performance: capacity planning and editions, storage, partitioning and clustering, and SQL queries.

View on GitHub

Kind: Skill
Works with: Any agent
Languages: SQL
Source: Google skills (Google Cloud and more) @ 92776fbf3875
Path: skills/cloud/bigquery-optimization/SKILL.md
Jobs: Review, Implementation
Topics: Data pipelines

Credit

Made by: google
Original: github.com/google/skills/blob/92776fbf3875a5ee7424124e398956a…
License: Apache-2.0

Listed by Skill Manifest; not made by us.

InstallInstall it with npx.

npx skills add google/skills

Install factsScanned 2 Nov 2026

Adds: .claude/skills/bigquery-optimization/ (the skill folder)
10 file(s) the skill refers to
Runs scripts: Yes
shell block in the text
Uses the network: Yes
downloads npm packages
Needs secrets: Yes
GOOGLE_APPLICATION_CREDENTIALS
Reads environment variables: GOOGLE_APPLICATION_CREDENTIALS
Source revision: 92776fbf3875
Licence: Apache-2.0
Last activity: 1 Nov 2026
Review: Reviewed

Found by a static scan of the stored text; nothing is run. “None found” is not a guarantee, so read what you install before you run it.

Only the main file is read; other files in the folder are not scanned

# 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
modifications:

1.  **Google Cloud SDK**: Ensure the
    [Google Cloud SDK](https://cloud.google.com/sdk/docs/install) is installed
    and configured.
2.  **Project Selection**: Set the active Google Cloud project:

    ```bash
    gcloud config set project {project_id}
    ```

3.  **API Enablement**: Ensure BigQuery and BigQuery Reservation APIs are
    enabled:

    ```bash
    gcloud services enable \
        bigquery.googleapis.com bigqueryreservation.googleapis.com
    ```

4.  **Authentication**: Authenticate the environment:
    *   CLI tools and `bq` commands: `gcloud auth login`
…