Stay organized with collections Save and categorize content based on your preferences.
See What's new with BigQuery and hear the latest product innovations announced at Next ’22.
Jump to

BigQuery

Cost-effective, serverless, multicloud enterprise data warehouse to power your data-driven innovation.

New customers get $300 in free credits to spend on BigQuery. All customers get 10 GB storage and up to 1 TB queries free per month, not charged against their credits.

  • Run analytics at scale with 27% lower three-year TCO than cloud data warehouse alternatives

  • Democratize insights with built-in business intelligence and machine learning

  • Power business decisions from data across clouds with a flexible, multicloud analytics solution

  • BigQuery is at the core of Google's unified data cloud to help you drive data transformation

Benefits

Gain insights with real-time and predictive analytics

Query streaming data in real time and get up-to-date information on all your business processes. Predict business outcomes easily with built-in machine learning–without the need to move data.

Protect your data and operate with trust

Rely on BigQuery’s robust security, governance, and reliability controls that offer high availability and a 99.99% uptime SLA. Protect your data with encryption by default and customer-managed encryption keys.

Break data silos and prevent lock-in

Embrace the ecosystem of partners, open data standards, and common industry data models to have the choice to work with data across any platform or environment.

Key features

Key features

Built-in machine learning

BigQuery ML enables data scientists and data analysts to build and operationalize ML models on planet-scale structured, semi-structured, and now unstructured data directly inside BigQuery, using simple SQL—in a fraction of the time. Export BigQuery ML models for online prediction into Vertex AI or your own serving layer. Learn more about the models we currently support.

Analyze and share data across clouds

BigQuery Omni is a fully managed, multicloud analytics solution that allows you to cost-effectively and securely analyze data across clouds, including AWS and Azure, and share results from a single pane of glass across your datasets. You can try BigQuery Omni at no cost for a limited period.  Efficiently and securely exchange data assets internally and across organizations with Analytics Hub, BigQuery's data exchange where you also have access to commercial, public, and Google datasets.

Real-time analytics with built-in query acceleration

BigQuery has built-in streaming capabilities that automatically ingest streaming data and make it immediately available to query, along with native integrations to Google Cloud's streaming products like Dataflow. Analyze large, complex datasets interactively with BigQuery BI Engine, an in-memory analysis service that offers sub-second query response time and high concurrency. BI Engine natively integrates with Looker Studio and works with many business intelligence tools.

Unify, manage and govern all types of data

BigQuery is the one stop solution for data analysts and scientists to query data of all types: structured, semi-structured and unstructured. Use BigLake to explore and unify different data types and build advanced models.  Centrally discover, manage, monitor, and govern data across data lakes, data warehouses, and data marts with consistent controls by leveraging Dataplex, an intelligent data fabric that enables organizations to provide access to trusted data and powering analytics at scale.

Geospatial analysis with BigQuery

BigQuery geospatial uniquely combines the serverless architecture of BigQuery with native support for geospatial analysis, so you can augment your analytics workflows with location intelligence. Simplify your analyses, see spatial data in fresh ways, and unlock entirely new lines of business with support for arbitrary points, lines, polygons, and multi-polygons in common geospatial data formats.

View all features

Documentation

Documentation

Quickstart
Using BigQuery sandbox

Experience BigQuery and the Cloud Console without providing a credit card, creating a billing account, or enabling billing for your project.

Quickstart
Quickstart using the Cloud Console

Learn how to use the Google Cloud Console as a visual interface to complete tasks like running queries, loading data, and exporting data.

Google Cloud Basics
Loading data into BigQuery

Learn how to ingest data into BigQuery via batch, streaming, querying, or using a third-party application. 

Google Cloud Basics
Create and use tables in BigQuery

Learn how to create and use standard (built-in) tables in BigQuery. 

Google Cloud Basics
BigQuery API and libraries overview

Get an overview of the various APIs and libraries associated with BigQuery, including an introductory video.

Quickstart
Quickstart using the BigQuery command-line tool

Learn how to use the BigQuery command-line tool to run queries, load data, and export data.

Use cases

Use cases

Use case
Data warehouse migration

Solve for today’s analytics demands and seamlessly scale your business by moving to Google Cloud’s enterprise data warehouse. Streamline your migration path from Netezza, Oracle, Redshift, Teradata, or Snowflake to BigQuery using the free and fully managed BigQuery Migration Service. Learn more and get started with our comprehensive data warehouse migration guides.

data warehouse migration architecture diagram
Use case
Real-time analytics

Gain a competitive advantage by responding to business events in real-time with event-driven analysis. BigQuery has built-in streaming capabilities that automatically ingest streaming data and make it immediately available to query. This allows you to stay agile and make business decisions based on the freshest data.  Or use Dataflow to enable fast, simplified streaming data pipelines  for a comprehensive streaming analytics solution

streaming architecture
Use case
Predictive analytics

Predictive analytics helps you predict future outcomes more accurately and discover opportunities in your business. Our smart analytics reference patterns are designed to reduce time-to-value for common analytics use cases with sample code and technical reference guides.  Learn how BigQuery and BigQuery ML can help you build an ecommerce recommendation system, predict customers' lifetime value, and design propensity to purchase solutions.

Use case
Marketing data warehouse

Marketing data warehouses let you deliver timely, targeted, and tailored advertising experiences that increase marketing performance.  BigQuery offers seamless data connectors into Google Ads, Campaign Manager, and other marketing platforms for a holistic view of your business. Build advanced marketing audiences with Google Analytics and BigQuery's built-in ML to drive higher ROI. Learn more about our marketing analytics solutions.

marketing data warehouse architecture

All features

All features

Serverless With serverless data warehousing, Google does all resource provisioning behind the scenes, so you can focus on data and analysis rather than worrying about upgrading, securing, or managing the infrastructure.
Multicloud capabilities BigQuery Omni allows you to analyze data across clouds using standard SQL and without leaving BigQuery’s familiar interface. Its flexible, fully managed infrastructure allows your data analysts or data scientists to have a completely seamless data analysis experience. From a single pane-of-glass, you can also combine data or train models cross-clouds using cross-cloud transfer.
Built-in ML and AI integrations Besides bringing ML to your data with BigQuery ML, integrations with Vertex AI and TensorFlow enable you to train and execute powerful models on structured data in minutes, with just SQL.
Foundation for BI BigQuery forms the backbone for modern cloud BI solutions and enables seamless data integration, transformation, analysis, visualization, and reporting with tools from Google and our technology partners. To accelerate BI workloads you can turn on BI Engine, an in-memory analysis service, to achieve sub-second query response time and high concurrency for popular BI tools via standard ODBC/JDBC.
Spreadsheet interface Connected Sheets allows users to analyze billions of rows of live BigQuery data in Google Sheets without requiring SQL knowledge. Users can apply familiar tools—like pivot tables, charts, and formulas—to easily derive insights from big data. Learn more about Connected Sheets in the getting started guide.
Real-time analytics BigQuery’s high-speed streaming insertion API provides a powerful foundation for real-time analytics, making your latest business data immediately available for analysis. You can also leverage Datastream, Pub/Sub and Dataflow to stream data into BigQuery.
Real-time change data capture and replication Synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency with Datastream. Datastream integrates with purpose-built and extensible Dataflow templates to pull change streams written to Cloud Storage, and create up-to-date replicated tables in BigQuery for real-time analytics.
Automatic high availability BigQuery transparently and automatically provides highly durable, replicated storage in multiple locations and high availability with no extra charge and no additional setup.
Standard SQL BigQuery supports a standard SQL dialect that is ANSI:2011 compliant, which reduces the need for code rewrites. BigQuery also provides ODBC and JDBC drivers at no cost to ensure your current applications can interact with its powerful engine.
Federated query and logical data warehousing Through powerful federated queries, BigQuery can process external data sources in object storage (Cloud Storage) for Parquet and ORC open source file formats, transactional databases (Bigtable, Cloud SQL), or spreadsheets in Drive. All this can be done without moving the data.
Convergence of data warehouse and data lake Run open source data science workloads (Spark, TensorFlow, Dataflow and Apache Beam, MapReduce, Pandas, and scikit-learn) directly on BigQuery using the Storage API.  Unify data warehouses and lakes, and enable them to perform uniform fine-grained access control, and accelerate query performance across multi-cloud storage and open formats.
Materialized Views Accelerate query performance and reduce costs within your environment with BigQuery materialized views. It is easy to set up, effortless to use, and best of all it's real time, allowing you to quickly get answers to your questions.
Storage and compute separation With BigQuery’s separated storage and compute, you have the option to choose the storage and processing solutions that make sense for your business and control access and costs for each.
Automatic backup and easy restore BigQuery automatically replicates data and keeps a seven-day history of changes, allowing you to easily restore and compare data from different times.
Geospatial data types and functions BigQuery geospatial combines the serverless architecture of BigQuery with native support for geospatial analysis, so you can augment your analytics workflows with location intelligence. Simplify your analyses, see spatial data in fresh ways, and unlock entirely new lines of business with support for arbitrary points, lines, polygons, and multi-polygons in common geospatial data formats.
BigQuery data transfer service The BigQuery Data Transfer Service automatically transfers data from external data sources, like Google Marketing Platform, Google Ads, YouTube, and partner SaaS applications to BigQuery on a scheduled and fully managed basis. Users can also easily transfer data from Teradata and Amazon S3 to BigQuery.
Big data ecosystem integration With Dataproc and Dataflow, BigQuery provides integration with the Apache big data ecosystem, allowing existing Hadoop/Spark and Beam workloads to read or write data directly from BigQuery using the Storage API.
Petabyte scale Get great performance on your data, while knowing you can scale seamlessly to store and analyze petabytes to exabytes of data with ease.
Flexible pricing models On-demand pricing lets you pay only for the storage and compute that you use. Flat-rate pricing with Reservations enables high-volume users or enterprises to choose price predictability and workload management seamlessly. For more information, see BigQuery pricing or cost controls.
Data governance and security BigQuery's integration with security and privacy services from Google Cloud provides strong security and fine-grained governance controls, down to the column-level and row-level. Rest assured knowing your data is encrypted at rest and in transit by default. 
Geo-expansion BigQuery gives you the option of geographic data control (in US, Asia, and European locations), without the headaches of setting up and managing clusters and other computing resources in-region.
Flexible data ingestion Automatically move data from hundreds of popular business SaaS applications into BigQuery for free with Data Transfer Service (DTS) or leverage data integration tools like Cloud Data Fusion, Datastream for BigQuery, Informatica, Talend, and more. Load and transform data at any scale from hybrid and multicloud applications.
Programmatic interaction BigQuery provides a REST API for easy programmatic access and application integration. Client libraries are available in Java, Python, Node.js, C#, Go, Ruby, and PHP. Business users can use Google Apps Script to access BigQuery from Sheets.
Rich monitoring and logging BigQuery provides rich monitoring, logging, and alerting through Cloud Audit Logs and it can serve as a repository for logs from any application or service using Cloud Logging.
Public datasets Google Cloud Public Datasets offer a powerful data repository of more than 200 high-demand public datasets from different industries. Google provides free storage for all public datasets, and customers can query up to 1 TB of data per month at no cost.
Always-free access The BigQuery sandbox gives you always-free access to the full power of BigQuery subject to certain limits. You can get started without a credit card, or without creating or enabling a billing account for your project. 

Pricing

Pricing

BigQuery charges for data storage, streaming inserts, and querying data, but loading and exporting data are free of charge. For detailed pricing information, please view the pricing guide.

Item Price
Storage

$0.02 per GB, per month

$0.01 per GB, per month for long-term storage

Streaming inserts $0.01 per 200 MB
Loading, copying, or exporting data; metadata operations Free

If you pay in a currency other than USD, the prices listed in your currency on Google Cloud SKUs apply.

Subscription type Price
Pay-as-you-go

$5 per TB

First terabyte (1 TB) per month is free*

Flat-rate pricing

Starts at $1,700/month for a dedicated reservation of 100 slots.

$4 per hour for 100 Flex slots.

For more information, see flat-rate pricing.

Additional details: BigQuery ML pricing

Non-USD prices listed on Google Cloud SKUs

* The first 1 TB of data processed with BigQuery each month is free

BigQuery sandbox provides free, limited access

SUBSCRIPTION TYPE PRICE
BigQuery Omni flat-rate pricing

Starts at $2,125/month for a dedicated reservation of 100 slots (on AWS).

$5 per hour for 100 Flex slots.

For more information, see BigQuery Omni pricing.

BigQuery’s quota policy applies for these operations

Partners

Work with a partner with BigQuery expertise

From data ingestion to visualization many partners have integrated their data solutions with BigQuery. Listed below are partner integrations through Google Cloud Ready - BigQuery