Stay organized with collections Save and categorize content based on your preferences.
Cloud Logging's Log Analytics, powered by BigQuery, is now GA. Read about new features included with the launch.

BigQuery product icon BigQuery

Cloud data warehouse to power your data-driven innovation

BigQuery is a completely serverless and cost-effective enterprise data warehouse. It has built-in machine learning and BI that works across clouds, and scales with your data.

Try BigQuery free Contact sales Go to console Contact sales

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.

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 for cost-effective and secure data analysis across clouds and shares results within a single pane of glass. Within BigQuery Analytics Hub, securely exchange data assets internally and across organizations without data movement and enhance analysis with commercial, public, and Google datasets.

Real-time analytics with built-in query acceleration

BigQuery has built-in capabilities that ingest streaming data and make it immediately available to query, along with native integrations to streaming products like Dataflow. Analyze large 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 BI tools, including Connected Sheets.

Unify, manage, and govern all types of data

Query all data types with BigQuery: 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 with Dataplex, an intelligent data fabric that enables organizations to provide access to trusted data. 

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.

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 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.

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.

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.

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.

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. 

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.

How It Works

BigQuery's serverless architecture lets you use SQL queries to analyze your data. You can store and analyze your data within BigQuery or use BigQuery to assess your data where it lives. To test how it works for yourself, query data—without a credit card—using the BigQuery sandbox.
Run sample query

Demo: Solving business challenges with an end-to-end analysis in BigQuery

Common Uses

Transfer data into BigQuery

Data warehouse migration

Real-time analytics

Predictive analytics

Log analytics

Marketing data warehouse

Pricing

How BigQuery pricing works

BigQuery pricing is based on analysis type, storage, additional services, and data ingestion and extraction. Loading and exporting data are free.

Free tier

The BigQuery free tier gives customers 10 GB storage, up to 1 TB queries free per month, and other resources.

Free

Analysis

On-demand

Generally gives you access to up to 2,000 concurrent slots, shared among all queries in a single project. 

Starting at

$5.00

First 1TB per month is free


Monthly flat-rate commitment

Best for customers who prefer a stable cost for queries rather than paying on-demand.

Starting at

$2,000

for 100 slots per month


Annual flat-rate commitment

Best for stable cost for queries rather than paying on-demand. Save more with an annual commitment.

Starting at

$1,700

for 100 slots per month


Flex short-term commitment

Pay for slots for 60 seconds, and each second thereafter until you delete or change your commitment.

Starting at

$4.00

for 100 slots per month

Storage

Active local storage

Based on the uncompressed bytes used in tables or table partitions modified in the last 90 days. 

Starting at

$0.02

Per GB. The first 10 GB is free each month.


Long-term logical storage

Based on the uncompressed bytes used in tables or table partitions modified for 90 consecutive days. 

Starting at

$0.01

Per GB. The first 10 GB is free each month.


Active physical storage

Based on the compressed bytes used in tables or table partitions modified for 90 consecutive days.

Starting at

$0.04

Per GB. The first 10 GB is free each month.


Long-term physical storage

Based on compressed bytes in tables or partitions that have not been modified for 90 consecutive days.

Starting at

$0.02

Per GB. The first 10 GB is free each month.

Data ingestion

Batch loading 

Export table data to Cloud Storage.

Free

When using the shared slot pool


Streaming inserts

You are charged for rows that are successfully inserted. Individual rows are calculated using a 1 KB minimum.

$0.01

per 200 MB


BigQuery Storage Write API

Data loaded into BigQuery, is subject to BigQuery storage pricing or Cloud Storage pricing.

$0.025

per 1 GB. The first 2 TB per month are free.

Data extraction

Batch export

Export table data to Cloud Storage.

Free

When using the shared slot pool


Streaming reads

Use the storage Read API to perform streaming reads of table data.

Starting at

$1.10

per TB read

How BigQuery pricing works BigQuery pricing is based on analysis type, storage, additional services, and data ingestion and extraction. Loading and exporting data are free.
Services and usage Subscription type Price (USD)
Free tier

The BigQuery free tier gives customers 10 GB storage, up to 1 TB queries free per month, and other resources.

Free

Analysis

On-demand

Generally gives you access to up to 2,000 concurrent slots, shared among all queries in a single project. 

Starting at

$5.00

First 1TB per month is free

Monthly flat-rate commitment

Best for customers who prefer a stable cost for queries rather than paying on-demand.

Starting at

$2,000

for 100 slots per month

Annual flat-rate commitment

Best for stable cost for queries rather than paying on-demand. Save more with an annual commitment.

Starting at

$1,700

for 100 slots per month

Flex short-term commitment

Pay for slots for 60 seconds, and each second thereafter until you delete or change your commitment.

Starting at

$4.00

for 100 slots per month

Storage

Active local storage

Based on the uncompressed bytes used in tables or table partitions modified in the last 90 days. 

Starting at

$0.02

Per GB. The first 10 GB is free each month.

Long-term logical storage

Based on the uncompressed bytes used in tables or table partitions modified for 90 consecutive days. 

Starting at

$0.01

Per GB. The first 10 GB is free each month.

Active physical storage

Based on the compressed bytes used in tables or table partitions modified for 90 consecutive days.

Starting at

$0.04

Per GB. The first 10 GB is free each month.

Long-term physical storage

Based on compressed bytes in tables or partitions that have not been modified for 90 consecutive days.

Starting at

$0.02

Per GB. The first 10 GB is free each month.

Data ingestion

Batch loading 

Export table data to Cloud Storage.

Free

When using the shared slot pool

Streaming inserts

You are charged for rows that are successfully inserted. Individual rows are calculated using a 1 KB minimum.

$0.01

per 200 MB

BigQuery Storage Write API

Data loaded into BigQuery, is subject to BigQuery storage pricing or Cloud Storage pricing.

$0.025

per 1 GB. The first 2 TB per month are free.

Data extraction

Batch export

Export table data to Cloud Storage.

Free

When using the shared slot pool

Streaming reads

Use the storage Read API to perform streaming reads of table data.

Starting at

$1.10

per TB read

Pricing calculator

Estimate your monthly BigQuery costs, including region specific pricing and fees.
Estimate your costs

Custom quote

Connect with our sales team to get a custom quote for your organization.
Request a quote

Start your proof of concept

New customers get $300 in free credits

Try BigQuery free

Try BigQuery sandbox without a credit card

Run a query

Query a public dataset in the Google Cloud console

Get started

Learn how to load data into BigQuery

Learn more

Learn how to create and use tables in BigQuery

Learn more

Partners & Integration

Work with a partner with BigQuery expertise

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

Visit our partner directory to learn about these BigQuery partners.

FAQ

BigQuery is Google Cloud’s fully managed and completely serverless enterprise data warehouse.  BigQuery supports all data types, works across clouds, and has built-in machine learning and business intelligence, all within a unified platform. BigQuery customers can see up to 27% lower three-year TCO compared to cloud data warehouse alternatives.

An enterprise data warehouse is a system used for the analysis and reporting of structured and semi-structured data from multiple sources. Many organizations are moving from traditional data warehouses that are on-premises to cloud data warehouses, which provide more cost savings, scalability, and flexibility.

BigQuery offers robust security, governance, and reliability controls that offer high availability and a 99.99% uptime SLA. Your data is protected with encryption by default and customer-managed encryption keys.

There are a few ways to get started with BigQuery. 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. You can get these credits by signing up for the BigQuery free trial. Not ready yet? You can use the BigQuery sandbox without a credit card to see how it works. 

The BigQuery sandbox lets you try out BigQuery without a credit card. You stay within BigQuery’s free tier automatically, and you can use the sandbox to run queries and analysis on public datasets to see how it works. You can also bring your own data into the BigQuery sandbox for analysis. There is an option to upgrade to the free trial where new customers get a $300 credit to try BigQuery.

Companies of all sizes use BigQuery to consolidate siloed data into one location so you can perform data analysis and get insights from all of your business data. This allows companies to make decisions in real time, streamline business reporting, and incorporate machine learning into data analysis to predict future business opportunities.

Other inquiries and support