BigQuery
A fast, economical and fully-managed enterprise data warehouse for large-scale data analytics
Try It FreeEnterprise Cloud Data Warehouse
BigQuery is Google's fully managed, petabyte scale, low cost enterprise data warehouse for analytics. 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 using familiar SQL. BigQuery is a powerful Big Data analytics platform used by all types of organizations, from startups to Fortune 500 companies.
Speed & Scale
BigQuery can scan TB in seconds and PB in minutes. 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 scale your database from GBs to PBs.
Incredible Pricing
BigQuery separates the concepts of storage and compute, allowing you to scale and pay for each independently. It also gives you flexible pricing options to better suit your needs. You can either choose a pay-as-you-go model or a flat-rate monthly price for those who need cost predictability.
Security & Reliability
BigQuery automatically encrypts and replicates your data to ensure security, availability and durability. You can further protect your data with strong role-based ACLs that you configure and control using our Google Cloud Identity & Access Management system.
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.
- 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, visualize it using Google Data Studio 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. 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 |
When querying data you can choose from two different pricing options:
| Feature | Price |
|---|---|
| Pay-as-you-go | $5 per TB First terabyte (1 TB) per month is free* |
| Flat-rate pricing | Starting at $40,000/month for a dedicated reservation of 2,000 slots. For more information, see Flat-rate pricing. |
* The first terabyte (1 TB) of data processed with Google BigQuery each month is free.
Note: BigQuery's quota policy applies for these operations.