BigQuery
A fast, economical and fully managed data warehouse for large-scale data analytics
Try It FreeAnalytics 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.
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.
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.
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.
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 |
Free |
* The first terabyte (1 TB) of data processed with Google BigQuery each month is free.
Note: BigQuery's quota policy applies for these operations.