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

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.

How One AI-Driven Media Platform Cut EBS Costs for AWS ASGs by 48%

How One AI-Driven Media Platform Cut EBS Costs for AWS ASGs by 48%

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

EBS-Optimized Instances: A Guide to Cut Costs and Maintain Performance

A recent study of over 100 enterprises found more than 15% of AWS cloud bills comes from Elastic Block Store (EBS). But what can you do to cut those costs without impacting performance? The key is to select EBS-optimized instances. With the right combination of EBS-optimized instances and EBS volumes, companies consistently maintain at least […]

Ganesh The Awesome Senior Pre & Post-Sales Engineer at GlobalDots
19th May, 2024
Cut Big Data Costs by 23%: 7 Key Practices

In this webinar, we reveal a solution that cuts big data costs by 23% and enhances system efficiency - without changing a single line of code. We’ll also explore 7 key practices that will free your engineers to process and analyze data at the pace and scale they need - and ensure they never lose control of the process.

Ganesh The Awesome Senior Pre & Post-Sales Engineer at GlobalDots
15th April, 2024
Project FOCUS: A New Age of FinOps Visibility

It’s easy for managers and team leaders to get caught up in the cultural scrum of FinOps. Hobbling many FinOps projects, however, is a lack of on-the-ground support for the DevOps teams that are having to drive this widespread change – this is how all too many FinOps projects become abandoned on the meeting room […]

Ganesh The Awesome Senior Pre & Post-Sales Engineer at GlobalDots
27th March, 2024

Unlock Your Cloud Potential

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

    GlobalDots' industry expertise proactively addressed structural inefficiencies that would have otherwise hindered our success. Their laser focus is why I would recommend them as a partner to other companies

    Marco Kaiser
    Marco Kaiser


    Legal Services

    GlobalDots has helped us to scale up our innovative capabilities, and in significantly improving our service provided to our clients

    Antonio Ostuni
    Antonio Ostuni


    IT Services

    It's common for 3rd parties to work with a limited number of vendors - GlobalDots and its multi-vendor approach is different. Thanks to GlobalDots vendors umbrella, the hybrid-cloud migration was exceedingly smooth

    Motti Shpirer
    Motti Shpirer

    VP of Infrastructure & Technology

    Advertising Services