An insider's guide to BigQuery cost optimization

Discover the best practices that help you optimize both cost and performance of BigQuery

Analytics is at the heart of every business decision. In today's economic climate, it has become more important than ever—helping organizations monitor their health, sharpen their focus, and drive efficiencies.

To make sure return on investment remains as high as possible, leading organizations are looking to best practices and optimization techniques for the cloud technologies they use. If you use BigQuery, this paper has you covered on both counts.

Read this whitepaper to:

Learn the best practices around data ingestion, export, storage, and analysis
Examine storage models and how long-term storage helps reduce costs
Explore consumption models of BigQuery Analysis
Dive into industry use cases to see how others are using BigQuery for data warehousing, storage, and analysis

Get the whitepaper

First name

Last name

Business email address

Calling Code

Business phone number

Job title

Company name

Sign me up to receive news, product updates, event information, and special offers about Google Cloud from Google.

I understand my personal data will be processed in accordance with Google's Privacy Policy.

Accelerate your digital transformation
Whether your business is early in its journey or well on its way to digital transformation, Google Cloud can help solve your toughest challenges.
Learn more

See all solutions

Industry Solutions
Reduce cost, increase operational agility, and capture new market opportunities.

Retail
Analytics and collaboration tools for the retail value chain.

Consumer Packaged Goods
Solutions for CPG digital transformation and brand growth.

Financial Services
Computing, data management, and analytics tools for financial services.

Healthcare and Life Sciences
Advance research at scale and empower healthcare innovation.

Media and Entertainment
Solutions for content production and distribution operations.

Telecommunications
Hybrid and multi-cloud services to deploy and monetize 5G.

Games
AI-driven solutions to build and scale games faster.

Manufacturing
Migration and AI tools to optimize the manufacturing value chain.

Supply Chain and Logistics
Enable sustainable, efficient, and resilient data-driven operations across supply chain and logistics operations.

Government
Data storage, AI, and analytics solutions for government agencies.

Education
Teaching tools to provide more engaging learning experiences.

Not seeing what you're looking for?
See all industry solutions

Application Modernization
Assess, plan, implement, and measure software practices and capabilities to modernize and simplify your organization’s business application portfolios.

CAMP
Program that uses DORA to improve your software delivery capabilities.

Modernize Traditional Applications
Analyze, categorize, and get started with cloud migration on traditional workloads.

Migrate from PaaS: Cloud Foundry, Openshift
Tools for moving your existing containers into Google's managed container services.

Migrate from Mainframe
Automated tools and prescriptive guidance for moving your mainframe apps to the cloud.

Modernize Software Delivery
Software supply chain best practices - innerloop productivity, CI/CD and S3C.

DevOps Best Practices
Processes and resources for implementing DevOps in your org.

SRE Principles
Tools and resources for adopting SRE in your org.

Day 2 Operations for GKE
Tools and guidance for effective GKE management and monitoring.

FinOps and Optimization of GKE
Best practices for running reliable, performant, and cost effective applications on GKE.

Run Applications at the Edge
Guidance for localized and low latency apps on Google’s hardware agnostic edge solution.

Architect for Multicloud
Manage workloads across multiple clouds with a consistent platform.

Go Serverless
Fully managed environment for developing, deploying and scaling apps.

Artificial Intelligence
Add intelligence and efficiency to your business with AI and machine learning.

Contact Center AI
AI model for speaking with customers and assisting human agents.

Document AI
Document processing and data capture automated at scale.

Product Discovery
Google-quality search and product recommendations for retailers.

APIs and Applications
Speed up the pace of innovation without coding, using APIs, apps, and automation.

New Business Channels Using APIs
Attract and empower an ecosystem of developers and partners.

Unlocking Legacy Applications Using APIs
Cloud services for extending and modernizing legacy apps.

Open Banking APIx
Simplify and accelerate secure delivery of open banking compliant APIs.

Databases
Migrate and manage enterprise data with security, reliability, high availability, and fully managed data services.

Database Migration
Guides and tools to simplify your database migration life cycle.

Database Modernization
Upgrades to modernize your operational database infrastructure.

Databases for Games
Build global, live games with Google Cloud databases.

Google Cloud Databases
Database services to migrate, manage, and modernize data.

Migrate Oracle workloads to Google Cloud
Rehost, replatform, rewrite your Oracle workloads.

Open Source Databases
Fully managed open source databases with enterprise-grade support.

SQL Server on Google Cloud
Options for running SQL Server virtual machines on Google Cloud.

Data Cloud
Unify data across your organization with an open and simplified approach to data-driven transformation that is unmatched for speed, scale, and security with AI built-in.

Databases Solutions
Migrate and manage enterprise data with security, reliability, high availability, and fully managed data services.

Smart Analytics Solutions
Generate instant insights from data at any scale with a serverless, fully managed analytics platform that significantly simplifies analytics.

AI Solutions
Add intelligence and efficiency to your business with AI and machine learning.

Data Cloud for ISVs
Innovate, optimize and amplify your SaaS applications using Google's data and machine learning solutions such as BigQuery, Looker, Spanner and Vertex AI.

Data Cloud Alliance
An initiative to ensure that global businesses have more seamless access and insights into the data required for digital transformation.

Digital Transformation
Accelerate business recovery and ensure a better future with solutions that enable hybrid and multi-cloud, generate intelligent insights, and keep your workers connected.

Digital Innovation
Reimagine your operations and unlock new opportunities.

Operational Efficiency
Prioritize investments and optimize costs.

COVID-19 Solutions
Get work done more safely and securely.

COVID-19 Solutions for the Healthcare Industry
How Google is helping healthcare meet extraordinary challenges.

Infrastructure Modernization
Migrate quickly with solutions for SAP, VMware, Windows, Oracle, and other workloads.

Application Migration
Discovery and analysis tools for moving to the cloud.

SAP on Google Cloud
Certifications for running SAP applications and SAP HANA.

High Performance Computing
Compute, storage, and networking options to support any workload.

Windows on Google Cloud
Tools and partners for running Windows workloads.

Data Center Migration
Migration solutions for VMs, apps, databases, and more.

Active Assist
Automatic cloud resource optimization and increased security.

Virtual Desktops
Remote work solutions for desktops and applications (VDI & DaaS).

Rapid Migration Program (RaMP)
End-to-end migration program to simplify your path to the cloud.

Backup and Disaster Recovery
Ensure your business continuity needs are met.

Red Hat on Google Cloud
Google and Red Hat provide an enterprise-grade platform for traditional on-prem and custom applications.

Productivity and Collaboration
Change the way teams work with solutions designed for humans and built for impact.

Google Workspace
Collaboration and productivity tools for enterprises.

Google Workspace Essentials
Secure video meetings and modern collaboration for teams.

Cloud Identity
Unified platform for IT admins to manage user devices and apps.

Chrome Enterprise
ChromeOS, Chrome Browser, and Chrome devices built for business.

Cloud Search
Enterprise search for employees to quickly find company information.

Security
Detect, investigate, and respond to online threats to help protect your business.

Security Analytics and Operations
Solution for analyzing petabytes of security telemetry.

Web App and API Protection
Threat and fraud protection for your web applications and APIs.

Security and Resilience Framework
Solutions for each phase of the security and resilience life cycle.

Risk and compliance as code (RCaC)
Solution to modernize your governance, risk, and compliance function with automation.

Software Supply Chain Security
Solution for improving end-to-end software supply chain security.

Security Foundation
Recommended products to help achieve a strong security posture.

Smart Analytics
Generate instant insights from data at any scale with a serverless, fully managed analytics platform that significantly simplifies analytics.

Data Warehouse Modernization
Data warehouse to jumpstart your migration and unlock insights.

Data Lake Modernization
Services for building and modernizing your data lake.

Spark on Google Cloud
Run and write Spark where you need it, serverless and integrated.

Stream Analytics
Insights from ingesting, processing, and analyzing event streams.

Business Intelligence
Solutions for modernizing your BI stack and creating rich data experiences.

Data Science
Put your data to work with Data Science on Google Cloud.

Marketing Analytics
Solutions for collecting, analyzing, and activating customer data.

Geospatial Analytics and AI
Solutions for building a more prosperous and sustainable business.

Datasets
Data from Google, public, and commercial providers to enrich your analytics and AI initiatives.

Startups and SMB
Accelerate startup and SMB growth with tailored solutions and programs.

Startup Solutions
Grow your startup and solve your toughest challenges using Google’s proven technology.

Startup Program
Get financial, business, and technical support to take your startup to the next level.

Small and Medium Business
Explore solutions for web hosting, app development, AI, and analytics.

Software as a Service
Build better SaaS products, scale efficiently, and grow your business.

Featured Products

Compute Engine
Virtual machines running in Google’s data center.

Cloud Storage
Object storage that’s secure, durable, and scalable.

BigQuery
Data warehouse for business agility and insights.

Cloud Run
Fully managed environment for running containerized apps.

Google Kubernetes Engine
Managed environment for running containerized apps.

Vertex AI
Unified platform for ML models and generative AI.

Looker
Platform for BI, data applications, and embedded analytics.

Apigee API Management
Manage the full life cycle of APIs anywhere with visibility and control.

Cloud SQL
Relational database services for MySQL, PostgreSQL and SQL Server.

Cloud SDK
Command-line tools and libraries for Google Cloud.

Cloud CDN
Content delivery network for delivering web and video.

Not seeing what you're looking for?
See all products (100+)

AI and Machine Learning

Vertex AI Platform
Unified platform for ML models and generative AI.

Vertex AI Studio
Build, tune, and deploy foundation models on Vertex AI.

Vertex AI Search and Conversation
Generative AI apps for search and conversational AI.

Dialogflow
Lifelike conversational AI with state-of-the-art virtual agents.

Natural Language AI
Sentiment analysis and classification of unstructured text.

Speech-to-Text
Speech recognition and transcription across 125 languages.

Text-to-Speech
Speech synthesis in 220+ voices and 40+ languages.

Translation AI
Language detection, translation, and glossary support.

Document AI
Document processing and data capture automated at scale.

Vision AI
Custom and pre-trained models to detect emotion, text, and more.

Contact Center AI
AI model for speaking with customers and assisting human agents.

Not seeing what you're looking for?
See all AI and machine learning products

Business Intelligence

Looker
Platform for BI, data applications, and embedded analytics.

Looker Studio
Interactive data suite for dashboarding, reporting, and analytics.

Compute

Compute Engine
Virtual machines running in Google’s data center.

App Engine
Serverless application platform for apps and back ends.

Cloud GPUs
GPUs for ML, scientific computing, and 3D visualization.

Migrate to Virtual Machines
Server and virtual machine migration to Compute Engine.

Spot VMs
Compute instances for batch jobs and fault-tolerant workloads.

Batch
Fully managed service for scheduling batch jobs.

Sole-Tenant Nodes
Dedicated hardware for compliance, licensing, and management.

Bare Metal
Infrastructure to run specialized workloads on Google Cloud.

Recommender
Usage recommendations for Google Cloud products and services.

VMware Engine
Fully managed, native VMware Cloud Foundation software stack.

Cloud Run
Fully managed environment for running containerized apps.

Not seeing what you're looking for?
See all compute products

Containers

Google Kubernetes Engine
Managed environment for running containerized apps.

Cloud Run
Fully managed environment for running containerized apps.

Cloud Build
Solution for running build steps in a Docker container.

Artifact Registry
Package manager for build artifacts and dependencies.

Cloud Code
IDE support to write, run, and debug Kubernetes applications.

Cloud Deploy
Fully managed continuous delivery to GKE and Cloud Run.

Migrate to Containers
Components for migrating VMs into system containers on GKE.

Deep Learning Containers
Containers with data science frameworks, libraries, and tools.

Knative
Components to create Kubernetes-native cloud-based software.

Data Analytics

BigQuery
Data warehouse for business agility and insights.

Looker
Platform for BI, data applications, and embedded analytics.

Dataflow
Streaming analytics for stream and batch processing.

Pub/Sub
Messaging service for event ingestion and delivery.

Dataproc
Service for running Apache Spark and Apache Hadoop clusters.

Cloud Data Fusion
Data integration for building and managing data pipelines.

Cloud Composer
Workflow orchestration service built on Apache Airflow.

Dataprep
Service to prepare data for analysis and machine learning.

Dataplex
Intelligent data fabric for unifying data management across silos.

Dataform
Build, version control, and deploy SQL workflows in BigQuery.

Analytics Hub
Service for securely and efficiently exchanging data analytics assets.

Not seeing what you're looking for?
See all data analytics products

Databases

AlloyDB for PostgreSQL
Fully managed, PostgreSQL-compatible database for enterprise workloads.

Cloud SQL
Fully managed database for MySQL, PostgreSQL, and SQL Server.

Firestore
Cloud-native document database for building rich mobile, web, and IoT apps.

Spanner
Cloud-native relational database with unlimited scale and 99.999% availability.

Bigtable
Cloud-native wide-column database for large-scale, low-latency workloads.

Datastream
Serverless change data capture and replication service.

Database Migration Service
Serverless, minimal downtime migrations to Cloud SQL.

Bare Metal Solution
Fully managed infrastructure for your Oracle workloads.

Memorystore
Fully managed Redis and Memcached for sub-millisecond data access.

Developer Tools

Artifact Registry
Universal package manager for build artifacts and dependencies.

Cloud Code
IDE support to write, run, and debug Kubernetes applications.

Cloud Build
Continuous integration and continuous delivery platform.

Cloud Deploy
Fully managed continuous delivery to GKE and Cloud Run.

Cloud Deployment Manager
Service for creating and managing Google Cloud resources.

Cloud SDK
Command-line tools and libraries for Google Cloud.

Cloud Scheduler
Cron job scheduler for task automation and management.

Cloud Source Repositories
Private Git repository to store, manage, and track code.

Infrastructure Manager
Automate infrastructure management with Terraform.

Cloud Workstations
Managed and secure development environments in the cloud.

Gemini for Google Cloud
AI-powered collaborator available across Google Cloud.

Not seeing what you're looking for?
See all developer tools

Distributed Cloud

Google Distributed Cloud Edge
Distributed cloud services for edge workloads.

Google Distributed Cloud Hosted
Distributed cloud for air-gapped workloads.

Hybrid and Multicloud

Google Kubernetes Engine
Managed environment for running containerized apps.

Apigee API Management
API management, development, and security platform.

Migrate to Containers
Tool to move workloads and existing applications to GKE.

Traffic Director
Traffic control pane and management for open service mesh.

Cloud Build
Service for executing builds on Google Cloud infrastructure.

Operations
Monitoring, logging, and application performance suite.

Google Distributed Cloud
Fully managed solutions for the edge and data centers.

Industry Specific

Anti Money Laundering AI
Detect suspicious, potential money laundering activity with AI.

Cloud Healthcare API
Solution for bridging existing care systems and apps on Google Cloud.

Device Connect for Fitbit
Gain a 360-degree patient view with connected Fitbit data on Google Cloud.

Telecom Network Automation
Ready to use cloud-native automation for telecom networks.

Telecom Data Fabric
Telecom data management and analytics with an automated approach.

Telecom Subscriber Insights
Ingests data to improve subscriber acquisition and retention.

Spectrum Access System (SAS)
Controls fundamental access to the Citizens Broadband Radio Service (CBRS).

Integration Services

Application Integration
Connect to 3rd party apps and enable data consistency without code.

Workflows
Workflow orchestration for serverless products and API services.

Apigee API Management
Manage the full life cycle of APIs anywhere with visibility and control.

Cloud Tasks
Task management service for asynchronous task execution.

Cloud Scheduler
Cron job scheduler for task automation and management.

Dataproc
Service for running Apache Spark and Apache Hadoop clusters.

Cloud Data Fusion
Data integration for building and managing data pipelines.

Cloud Composer
Workflow orchestration service built on Apache Airflow.

Pub/Sub
Messaging service for event ingestion and delivery.

Eventarc
Build an event-driven architecture that can connect any service.

Management Tools

Cloud Shell
Interactive shell environment with a built-in command line.

Cloud console
Web-based interface for managing and monitoring cloud apps.

Cloud Endpoints
Deployment and development management for APIs on Google Cloud.

Cloud IAM
Permissions management system for Google Cloud resources.

Cloud APIs
Programmatic interfaces for Google Cloud services.

Service Catalog
Service catalog for admins managing internal enterprise solutions.

Cost Management
Tools for monitoring, controlling, and optimizing your costs.

Operations
Monitoring, logging, and application performance suite.

Carbon Footprint
Dashboard to view and export Google Cloud carbon emissions reports.

Config Connector
Kubernetes add-on for managing Google Cloud resources.

Active Assist
Tools for easily managing performance, security, and cost.

Not seeing what you're looking for?
See all management tools

Maps and Geospatial

Earth Engine
Geospatial platform for Earth observation data and analysis.

Google Maps Platform
Create immersive location experiences and improve business operations.

Media Services

Cloud CDN
Content delivery network for serving web and video content.

Live Stream API
Service to convert live video and package for streaming.

OpenCue
Open source render manager for visual effects and animation.

Transcoder API
Convert video files and package them for optimized delivery.

Video Stitcher API
Service for dynamic or server side ad insertion.

Migration

Migration Center
Unified platform for migrating and modernizing with Google Cloud.

Application Migration
App migration to the cloud for low-cost refresh cycles.

Migrate to Virtual Machines
Components for migrating VMs and physical servers to Compute Engine.

Cloud Foundation Toolkit
Reference templates for Deployment Manager and Terraform.

Database Migration Service
Serverless, minimal downtime migrations to Cloud SQL.

Migrate to Containers
Components for migrating VMs into system containers on GKE.

BigQuery Data Transfer Service
Data import service for scheduling and moving data into BigQuery.

Rapid Migration Program (RaMP)
End-to-end migration program to simplify your path to the cloud.

Transfer Appliance
Storage server for moving large volumes of data to Google Cloud.

Storage Transfer Service
Data transfers from online and on-premises sources to Cloud Storage.

VMware Engine
Migrate and run your VMware workloads natively on Google Cloud.

Mixed Reality

Immersive Stream for XR
Hosts, renders, and streams 3D and XR experiences.

Networking

Cloud Armor
Security policies and defense against web and DDoS attacks.

Cloud CDN and Media CDN
Content delivery network for serving web and video content.

Cloud DNS
Domain name system for reliable and low-latency name lookups.

Cloud Load Balancing
Service for distributing traffic across applications and regions.

Cloud NAT
NAT service for giving private instances internet access.

Cloud Connectivity
Connectivity options for VPN, peering, and enterprise needs.

Network Connectivity Center
Connectivity management to help simplify and scale networks.

Network Intelligence Center
Network monitoring, verification, and optimization platform.

Network Service Tiers
Cloud network options based on performance, availability, and cost.

Virtual Private Cloud
Single VPC for an entire organization, isolated within projects.

Private Service Connect
Secure connection between your VPC and services.

Not seeing what you're looking for?
See all networking products

Operations

Cloud Logging
Google Cloud audit, platform, and application logs management.

Cloud Monitoring
Infrastructure and application health with rich metrics.

Error Reporting
Application error identification and analysis.

Cloud Debugger
Real-time application state inspection and in -production debugging.

Cloud Trace
Tracing system collecting latency data from applications.

Cloud Profiler
CPU and heap profiler for analyzing application performance.

Cloud Quotas
Manage quotas for all Google Cloud services.

Productivity and Collaboration

AppSheet
No-code development platform to build and extend applications.

AppSheet Automation
Build automations and applications on a unified platform.

Google Workspace
Collaboration and productivity tools for individuals and organizations.

Google Workspace Essentials
Secure video meetings and modern collaboration for teams.

Gemini for Workspace
Embeds generative AI across Google Workspace apps.

Cloud Identity
Unified platform for IT admins to manage user devices and apps.

Chrome Enterprise
ChromeOS, Chrome browser, and Chrome devices built for business.

Security and Identity

Cloud IAM
Permissions management system for Google Cloud resources.

Sensitive Data Protection
Discover, classify, and protect your valuable data assets.

Mandiant Managed Defense
Find and eliminate threats with confidence 24x7.

Mandiant Threat Intelligence
Know who’s targeting you.

Security Command Center
Platform for defending against threats to your Google Cloud assets.

Cloud Key Management
Manage encryption keys on Google Cloud.

Mandiant Incident Response
Minimize the impact of a breach.

Mandiant Attack Surface Management
See your organization through the eyes of the adversary.

Assured Workloads
Compliance and security controls for sensitive workloads.

Chronicle Security Operations
Detect, investigate, and respond to cyber threats.

Mandiant Consulting
Get expert guidance before, during, and after an incident.

Not seeing what you're looking for?
See all security and identity products

Serverless

Cloud Run
Fully managed environment for running containerized apps.

Cloud Functions
Platform for creating functions that respond to cloud events.

App Engine
Serverless application platform for apps and back ends.

Workflows
Workflow orchestration for serverless products and API services.

API Gateway
Develop, deploy, secure, and manage APIs with a fully managed gateway.

Storage

Cloud Storage
Object storage that’s secure, durable, and scalable.

Block Storage
High-performance storage for AI, analytics, databases, and enterprise applications.

Filestore
File storage that is highly scalable and secure.

Persistent Disk
Block storage for virtual machine instances running on Google Cloud.

Cloud Storage for Firebase
Object storage for storing and serving user-generated content.

Local SSD
Block storage that is locally attached for high-performance needs.

Storage Transfer Service
Data transfers from online and on-premises sources to Cloud Storage.

Parallelstore
High performance, managed parallel file service.

Google Cloud NetApp Volumes
File storage service for NFS, SMB, and multi-protocol environments.

Backup and DR Service
Service for centralized, application-consistent data protection.

Web3

Blockchain Node Engine
Fully managed node hosting for developing on the blockchain.

Save money with our transparent approach to pricing
Google Cloud's pay-as-you-go pricing offers automatic savings based on monthly usage and discounted rates for prepaid resources. Contact us today to get a quote.
Request a quote

Save money with our transparent approach to pricing
Request a quote
Pricing overview and tools
Google Cloud pricing
Pricing calculator
Google Cloud free tier
Cost optimization framework
Cost management tools
Product-specific Pricing
Compute Engine
Cloud SQL
Google Kubernetes Engine
Cloud Storage
BigQuery
See full price list with 100+ products