Understanding Google’s BigQuery Pricing Changes: Essential Cost Optimization Tips

Sharon Borenstein FinOps Engineer @ GlobalDots
3 Min read

Recently, Google announced substantial changes to its BigQuery service, which came into effect on July 5, 2023. This blog post is dedicated to helping you understand these modifications and the potential impact they could have on your GCP’s costs, thereby enabling you to make informed decisions during your FinOps journey. 

Google BigQuery is an enterprise-level, serverless and highly scalable multi-cloud data warehouse that offers fast SQL queries and interactive analysis of massive datasets. BigQuery is designed to process queries on large datasets using Google’s infrastructure. Its serverless approach abstracts the underlying infrastructure, allowing you to focus on analyzing data and finding insights.

Reduce your AWS costs by over 50%

Discover your Cloud Saving Potential – Answer just 5 simple questions. AppsFlyer, Playtika, Lufthansa, IBM, top leading companies are already using our FinOps services.

Reduce your AWS costs by over 50%

What’s New?

Google is rolling out a new consumption and reservation model for BigQuery, dubbed BigQuery editions. The model introduces a tiered pricing structure with curated feature sets catering to different workload needs. All editions come with a new autoscaler functionality that promises fully elastic, dynamic scaling of BigQuery compute resources, eliminating the need for pre-provisioning capacity.

Why Does It Matter?

This major shift aims to provide users with more options to tailor their spending based on workload type and size. Nevertheless, these improvements also mean a 25% price increase for BigQuery on-demand analysis (pay-per-query pricing) to account for enhancements in serverless functionality and performance.

New BigQuery’s pricing model (Source: Google)

Key Changes to Look Out For:

  • Editions: BigQuery will now have three editions – Standard, Enterprise, and Enterprise Plus, each with different capabilities and price points.

  • Pricing Changes: The modifications will affect all customers with existing BigQuery reservation spend (flat-rate or flex slots) and those using BigQuery on-demand analysis.

  • Migration: Previous flat-rate and flex slot reservations were converted automatically to the BigQuery editions, with new pricing effective from July 5, 2023.

Key Actions to Perform:

  • Analyze Your Usage: Review your current usage of BigQuery and consider the implications of these changes on your costs.

  • Prepare for Migration: If you’re under the flat-rate model, coordinate with your teams to plan for workload transitions to the new editions model.

  • Evaluate Commitments: Contemplate adjusting your capacity configuration to avail optional 1-year or 3-year capacity commitments (available in Enterprise and Enterprise Plus editions) for potential cost savings.

  • Capitalize on Autoscaling and Compression: With BigQuery’s new granular autoscaling and compression features, you might be able to reduce your current committed capacity by 30-40%.

  • Optimize On-Demand Usage: For those continuing with on-demand analysis, think about optimizing your queries for cost-effectiveness. Efficient query design, partitioning, and clustering can maximize your on-demand usage benefits.

These changes offer flexible pricing options, the ability to mix and match editions, and multi-year usage discounts, all contributing towards improved cost predictability and lower total cost of ownership.

At GlobalDots, we acknowledge that navigating these changes can be complex. With two decades of experience in cloud innovation, comprehensive FinOps expertise, and a proven track record of cost optimization management for companies such as Gong, SentinelOne, and Lufthansa, we are well-equipped to guide you through this transition. Our goal is to help you strategically optimize your costs and usage in response to these new developments, leveraging our vendor-agnostic approach and multi-domain knowledge. Contact us today to get started, or get a free cost savings assessment in 90 seconds.

Latest Articles

3 IT Infrastructure Costs Increasing in 2024:

As we navigate through the evolving landscape of IT infrastructure, a closer look at the cost trends for 2024 reveals significant shifts. From cloud expenses feeling the pressure of economic changes. With global cloud spending expected to hit over $1 trillion and various sectors facing unique challenges, staying informed is more crucial than ever.  Dive […]

Miguel Fersen Iberia & LATAM Regional Manager @ GlobalDots
26th February, 2024
8 FinOps Best Practices for Cutting Cloud Costs

The cloud used to be viewed as a place of significant cost savings: rather than purchasing and maintaining dozens of server stacks, organizations could outsource this and purchase compute power on an as-needed basis. In the ensuing rush to cloud architecture, however, many companies simply lifted-and-shifted their old financial bad habits. The sheer speed of […]

22nd February, 2024
How FinOps Capabilities Can Unlock Your Cloud Cost Goals

Cloud computing has transformed more than individual app architectures: it’s granted both start-ups and market leaders an equal platform for innovation. New products are no longer dependent upon complex revenue-draining in-house server stacks. Instead, cloud-native disruptors such as Uber and Airbnb have been able to harness the once-unthinkable degrees of agility, scalability, and cost-efficiency that […]

24th January, 2024
How to Choose a Third-Party FinOps Solution

Cloud providers are becoming increasingly aware of their customers’ chronic overspending. To combat this, major industry players such as AWS and Azure are offering FinOps tools in the form of inbuilt cost dashboards and paying to become a member of the FinOps Foundation. While their native FinOps tools can offer an initial window into the […]

14th January, 2024

Unlock Your Cloud Potential

Schedule a call with our experts. Discover new technology and get recommendations to improve your performance.

Unlock Your Cloud Potential