Analytics Data Warehouse

BigQuery is Google's fully managed, petabyte scale, low cost analytics data warehouse. BigQuery is serverless, there is no infrastructure to manage and you don't need a database administrator, so you can focus on analyzing data to find meaningful insights, use familiar SQL, and take advantage of our pay-as-you-go model. BigQuery is a powerful Big Data analytics platform used by all types of organizations, from startups to Fortune 500 companies.

Speed & Performance

Load your data from Google Cloud Storage or Google Cloud Datastore, or stream it into BigQuery to enable real-time analysis of your data. With BigQuery you can easily deploy Petabyte-scale Databases.

Speed and Performance

Incredible Pricing

BigQuery separates concepts of Big Data storage and compute, allowing you to scale and pay for each independently. In addition, the first terabyte (1 TB) of data processed each month is free.

first 1 TB of data process each month is free

Security & Reliability

BigQuery is built with a replicated storage strategy. You can protect your data with strong role-based ACLs that you configure and control.

Security and Reliability

Partnerships & Integrations

Google Cloud Platform partners and 3rd party developers have developed multiple integrations with BigQuery so you can easily load, process, and make interactive visualizations of your data. Our partners include Looker, Tableau, Qlik, Talend, Google Analytics, SnapLogic and more.

Partnership Integration

BigQuery Features

A fast, economical and fully managed data warehouse for large-scale data analytics.

Flexible Data Ingestion
Load your data from Google Cloud Storage or Google Cloud Datastore, or stream it into BigQuery at 100,000 rows per second to enable real-time analysis of your data.
Global Availability
You have the option to store your BigQuery data in European locations while continuing to benefit from a fully managed service, now with the option of geographic data control, without low-level cluster maintenance headaches.
Security & Permissions
You have full control over who has access to the data stored in Google BigQuery. Shared datasets will not impact your cost or performance (those you share with pay for their own queries).
Cost Controls
BigQuery provides cost control mechanisms that enable you to cap your daily costs to an amount that you choose. For more information, see Cost Controls.
Highly Available
Transparent data replication in multiple geographies means your data is available and durable even in the case of extreme failure modes.
Super Fast Performance
Run super-fast SQL queries against multiple terabytes of data in seconds, using the processing power of Google's infrastructure.
Fully Integrated
In addition to SQL queries, you can easily read and write data in BigQuery via Cloud Dataflow, Spark, and Hadoop.
Connect with Google Products
You can automatically export your data from Google Analytics Premium into BigQuery and analyze datasets stored in Google Cloud Storage.

“ Spotify chose Google in part because its services for analyzing large amounts of data, tools like BigQuery, are more advanced than data services from other cloud providers. ”

- Nicholas Harteau, VP of Infrastructure, Spotify

BigQuery Pricing

BigQuery charges for data storage, streaming inserts, and for querying data, but loading and exporting data are free of charge. Learn more

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
Queries First terabyte (1 TB) per month is free*
$5 per additional TB
Loading, Copying, or Exporting data
Metadata operations

* The first terabyte (1 TB) of data processed with Google BigQuery each month is free.
Note: BigQuery's quota policy applies for these operations.