Skip to content
Kitbay
Submit

bigquery-observability

Apache-2.0Updated on Nov 11, 202623,842GitHub stars

A Google skill for fetching BigQuery telemetry once the agent knows what it is looking for.

What the skill teaches

A Google skill for fetching BigQuery telemetry once the agent knows what it is looking for. It compares the three sources, INFORMATION_SCHEMA views, the jobs and reservation REST APIs, and Cloud Monitoring, and says when each fits. It then sets rules for writing efficient INFORMATION_SCHEMA queries with the right region and scope, and links reference files with ready queries for job performance, slot contention and queueing, reservation capacity and autoscaling, compute billing under on-demand and capacity pricing, and storage footprints. Root-cause work is left to the troubleshooting skill and SQL tuning to the optimisation skill. It is part of Google's skills repository.

Capabilities

  • Pick between INFORMATION_SCHEMA, REST API and Cloud Monitoring
  • Query job performance and slot contention
  • Report reservation capacity and utilisation
  • Audit billable compute and storage usage