cyberneticlibrary

Optimize BigQuery costs and usage

bigquery-cost-optimizationskillsetup L11
Ocean1346/bigquery-expert
What it does

Optimize BigQuery pricing and spending

Best for

Switching between on-demand and slots pricing with cost-per-query benchmarking.

Inputs
  • · Query or workload description
Outputs
  • · Cost analysis and optimization recommendations
Requires
  • · Google Cloud BigQuery API
Preconditions
  • · Google Cloud project with BigQuery enabled
Failure modes
  • · Query syntax error
  • · Quota exceeded
  • · Table not found
Trust signals
  • · Official pricing reference
  • · Cost estimation with --dry_run
  • · Query execution plans