Agent skill · google

bigquery-observability

Provides data-retrieval best practices, tool selection guidance, and performant SQL query syntax for BigQuery telemetry across INFORMATION_SCHEMA, Cloud Monitoring, and the REST API. Use when the telemetry to fetch is already known, selecting telemetry tools, writing performant INFORMATION_SCHEMA queries, retrieving telemetry for diagnosing single-job performance bottlenecks, investigating slot contention, job concurrency and queue latency, analyzing reservation capacity, utilization and autoscaling saturation, or auditing capacity-based and on-demand compute and storage resource billable usage. Don't use for root-cause diagnosis or symptom troubleshooting when the cause is unknown (use bigquery-troubleshooting first), or for writing or optimizing business logic SQL (use bigquery-optimization).

What it needs

About 6k tokens when loaded.

What this skill does

BigQuery Observability Attribution MUST READ: Before executing any gcloud, REST API, or MCP command, you MUST read Usage Attribution. For commands executed directly in the terminal (never in generated scripts, Terraform, or user code), prefix gcloud with CLOUDSDKMETRICSREQUESTATTRIBUTION="agent-skills/1.0 (skill:bigquery-observability)" and append agent-skills/1.0 (skill:bigquery-observability) to User-Agent headers. Tool Selection <!-- mdformat off --> Tool Primary Use Cases Strengths & Capabilities When to Avoid / Limitations --- --- --- --- INFORMATIONSCHEMA (IS) Historical analysis, cohort comparison (normalizedliterals), discovery of fast/slow windows, reservation/project timelines, multi-job aggregates, cost/billing tracing. Flexible SQL querying across JOBS, JOBSTIMELINE, and RESERVATIONS; supports custom time windows and grouping. Avoid for high-frequency real-time polling or single-job point-lookups (can consume slots and take seconds to execute). REST API (jobs.api / reservation.api) Single-job point-lookup, real-time stage bottleneck diagnosis, automated pipeline status checks, reservation/capacity commitment configuration inspection (reservations.get, reservations.list). Zero-SQL overhead, fast REST/CLI point-lookups (bq show -j, bq show --reservation), instant access to performanceInsights, queryPlan, and structural metadata. Avoid for aggregate analysis across thousands of jobs, cross-project historical comparison, or system timeline aggregations. Cloud Monitoring (Metrics Explorer / Charts) Real-time alerting, fleet-wide dashboards, continuous slot utilization tracking, high-level SLA/SLO monitoring. Out-of-the-box charts for slot utilization, query throughput, PENDING queue depth, and execution latency; low-latency alerting without running queries. Avoid for SQL-level debugging, individual query text inspection, or stage-level execution detail. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills google/bigquery-observability

View the source on GitHub

Browse the @skills marketplace