Analyze BigQuery Usage

This skill performs comprehensive analysis of BigQuery usage patterns, costs, and query performance for a given project. It identifies expensive queries, heavy users, and provides actionable optimization recommendations.

When to Use This Skill

This skill is automatically invoked by the /bigquery:analyze-usage command to perform usage analysis.

Prerequisites

• Google Cloud SDK (bq command-line tool) must be installed
• User must have BigQuery read access to the project
• User must be authenticated (gcloud auth login)
• User needs bigquery.jobs.list permission at minimum

Parameters