Switch language한국어
Back to the list

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

TL;DR AI

Key summary

2 min read
  1. A client cut BigQuery spend by 72% in three weeks.

  2. They found the biggest savings by identifying high-cost queries in INFORMATION_SCHEMA, then partitioning and clustering tables.

  3. Replacing SELECT * with explicit columns reduced bytes scanned and improved latency.

  4. Unused scheduled queries and dashboard refresh jobs were disabled to stop wasteful recurring costs.

Read the original