bigquery-slot-cost-optimizer
Pass
Audited by Gen Agent Trust Hub on Sep 17, 2026
Risk Level: SAFECOMMAND_EXECUTIONEXTERNAL_DOWNLOADS
Full Analysis
- Local Script Execution: The skill utilizes a Python script,
scripts/slot_analyzer.py, to perform automated telemetry extraction from BigQuery'sINFORMATION_SCHEMA. This script is executed locally by the agent to calculate slot-hours and identify performance bottlenecks. - Official Library Dependencies: The skill requires the installation of
google-cloud-bigquery. This is an official, well-known client library provided by Google for interacting with BigQuery services. - IAM and Authentication Requirements: To function, the skill requires the user to authenticate via
gcloudand possess specific IAM roles (roles/bigquery.jobUserandroles/bigquery.resourceViewer). These are standard security practices for managing access to cloud resources. - SQL Analysis Surface: The
slot_analyzer.pyscript ingests and analyzes SQL query text from job history. This analysis is performed using static regular expression patterns to detect anti-patterns like Cartesian joins or unpartitioned scans. The script does not execute the analyzed SQL strings, mitigating risks associated with untrusted data processing.
Audit Metadata