bigquery-slot-cost-optimizer
Analyzes Google Cloud BigQuery slot consumption, query costs
by googleFree
Description
BigQuery slot and cost optimizer is an agent skill that gives agents and cloud engineers a set of heuristics for finding and fixing expensive or slow BigQuery work. It analyzes resource consumption, calculates slot hours, identifies slot contention and queueing, and looks for query patterns that waste capacity. Among the issues it targets are Cartesian joins and row count explosions, which multiply data far beyond what a query needs, and unpartitioned table scans or missing partition filters, which read far more data than necessary. It also covers jobs that run slowly or spill memory. The skill has a list of trigger conditions, so the agent loads it when you ask it to optimize query performance or reduce slot use, find the most expensive queries, diagnose contention, fix slow jobs, or detect Cartesian joins. Before it runs, it requires the SDKs, permissions and billing setup described in its prerequisites section. The data it reads comes from INFORMATION_SCHEMA. It is aimed at engineers who run BigQuery at scale and need to control both speed and spending. It is published by Google on skills.sh under the google skills repository, with about 21.3K stars and about 1.2K installs. The skills.sh listing shows Gen Agent Trust Hub and Socket passing, with Snyk showing Warn.…
Highlights
- Calculates slot hours and finds contention
- Flags Cartesian joins and row explosions
- Finds unpartitioned scans and missing partition filters
- Diagnoses slow jobs and memory spill
- Reads cost data from INFORMATION_SCHEMA
Ratings & Reviews
No ratings yet
Be the first to rate bigquery-slot-cost-optimizer.
People also visit
bigquery-observability
Provides data-retrieval best practices, tool selection guidance
agent-platform-eval-flywheel
Measures and improves the quality of AI models and agents on Google Cloud
agent-platform-rag-engine-management
Manage and query Agent Platform RAG Engine Corpora
bigquery-slot-cost-optimizer FAQ
What does the skill find?
Expensive or slow BigQuery work, including slot contention, Cartesian joins, unpartitioned table scans and memory spill.
What data does it use?
INFORMATION_SCHEMA, which it queries for slot consumption and query costs.
What do I need before using it?
The SDKs, permissions and billing setup listed in its prerequisites section.
What triggers it?
Requests such as optimizing query performance, finding the most expensive queries, diagnosing queueing or detecting Cartesian joins.
How do I install it?
Run npx skills add https://github.com/google/skills --skill bigquery-slot-cost-optimizer.
What are the best bigquery-slot-cost-optimizer alternatives?
Popular alternatives to bigquery-slot-cost-optimizer include bigquery-observability, vercel-optimize and agent-platform-deploy. See all bigquery-slot-cost-optimizer alternatives