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).
- Version
- v2
- License
- Apache-2.0
Pinned to revision 6f4818a4c525, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/bigquery-observability/SKILL.md
- skills/bigquery-observability/references/capacity_and_configuration_queries.md
- skills/bigquery-observability/references/compute_capacity_billable.md
- skills/bigquery-observability/references/compute_ondemand_billable.md
- skills/bigquery-observability/references/job_performance_queries.md
- skills/bigquery-observability/references/resource_contention_queries.md
- skills/bigquery-observability/references/schema_compute.md
- skills/bigquery-observability/references/schema_others.md
- skills/bigquery-observability/references/schema_storage.md
- skills/bigquery-observability/references/storage_footprints.md
Every link opens the file at its source, pinned to the revision this page describes.