BigQuery
Cloud data warehouse to power your data-driven innovation
BigQuery is a serverless and cost-effective enterprise data warehouse that works across clouds and scales with your data. Use built-in ML/AI and BI for insights at scale.
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
Unified experience for all analytics users
Duet AI in BigQuery
Flexibility, predictable pricing, and best price performance
Built-in machine learning
Analyze and share data across clouds
Real-time analytics with streaming data pipelines
Unify, manage, and govern all types of data
Share insights with built-in business intelligence
Data governance and security
Geospatial analysis with BigQuery
Real-time change data capture and replication
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.
Common Uses
Transfer data into BigQuery
Bring any data into BigQuery
Tutorials, quickstarts, & labs
Bring any data into BigQuery
Data warehouse migration
Migrate data warehouses to BigQuery
Tutorials, quickstarts, & labs
Migrate data warehouses to BigQuery
Real-time analytics
Event-driven analysis
Tutorials, quickstarts, & labs
Event-driven analysis
Predictive analytics
Predict business outcomes with leading AI/ML
Tutorials, quickstarts, & labs
Predict business outcomes with leading AI/ML
Log analytics
Analyze log data
Tutorials, quickstarts, & labs
Analyze log data
Marketing analytics
Increase marketing ROI and performance with data and AI
Tutorials, quickstarts, & labs
Increase marketing ROI and performance with data and AI
Data clean rooms
BigQuery data clean rooms for privacy-centric data sharing
Tutorials, quickstarts, & labs
BigQuery data clean rooms for privacy-centric data sharing
Pricing
| How BigQuery pricing works | BigQuery pricing is based on compute (analysis), 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 |
| Compute (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 1 TB per month is free |
Standard edition Low-cost option for standard SQL analysis | $0.04 per slot hour | |
Enterprise edition Supports advanced enterprise analytics | $0.06 per slot hour | |
Enterprise Plus edition Supports mission-critical enterprise analytics | $0.10 per slot hour | |
| 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 | |
Learn more about BigQuery pricing. View all pricing details
How BigQuery pricing works
BigQuery pricing is based on compute (analysis), storage, additional services, and data ingestion and extraction. Loading and exporting data are free.
The BigQuery free tier gives customers 10 GB storage, up to 1 TB queries free per month, and other resources.
Free
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 1 TB per month is free
Standard edition
Low-cost option for standard SQL analysis
$0.04
per slot hour
Enterprise edition
Supports advanced enterprise analytics
$0.06
per slot hour
Enterprise Plus edition
Supports mission-critical enterprise analytics
$0.10
per slot hour
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.
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.
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
Learn more about BigQuery pricing. View all pricing details
Pricing calculator
Custom quote
Start your proof of concept
New customers get $300 in free credits
Try BigQuery sandbox without a credit card
Query a public dataset in the Google Cloud console
Learn how to load data into BigQuery
Learn how to create and use tables in BigQuery
Partners & Integration
Work with a partner with BigQuery expertise
ETL and data integration
Reverse ETL and MDM
BI and data visualization
Data governance and security
Connectors and developer tools
Machine learning and advanced analytics
Data Quality and Observability
Consulting partners
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
What makes BigQuery different from other enterprise data warehouse alternatives?
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.
What is an enterprise data warehouse?
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.
How secure is BigQuery?
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.
How can I get started with BigQuery?
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.
What is the BigQuery sandbox?
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.
What are the most common ways companies use 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.
