Google BigQuery

A fast, highly scalable, cost-effective and fully-managed enterprise data warehouse for analytics at any scale

BigQuery is Google's serverless, highly scalable, low cost enterprise data warehouse
designed to make all your data analysts productive. Because there
is no infrastructure to manage, you can focus on analyzing data to find
meaningful insights using familiar SQL and you don't need a database
administrator. BigQuery enables you to analyze all your data by
creating a logical data warehouse over managed, columnar storage as well as data
from object storage, and spreadsheets. BigQuery makes it easy to securely
share insights within your organization and beyond as datasets,
queries, spreadsheets and reports. BigQuery allows organizations to
capture and analyze data in real-time using its powerful streaming
ingestion capability so that your insights are always current.
BigQuery is free for up to 1TB of data analyzed each month and
10GB of data stored.

Get up and running fast

Set up your data warehouse in seconds and start to query your data immediately.
Google BigQuery runs blazing-fast SQL queries on gigabytes to petabytes of data
and makes it easy to join public or commercial datasets with your data. Eliminate
the time-consuming work of provisioning infrastructure and reduce your downtime
with a serverless infrastructure that handles all ongoing maintenance, including
patches and upgrades. Google BigQuery uses familiar ANSI-compliant SQL and provides
ODBC and JDBC drivers to make integration with your data fast and easy.

Scale seamlessly

Remove the headache of planning for data warehouse capacity and reach for infinity
with elastic capacity scaling that has no limit. Google BigQuery meets the
challenges of real-time analytics by leveraging Google’s serverless infrastructure
that uses automatic scaling and high-performance streaming ingestion to load data.
BigQuery’s managed columnar storage, massively parallel execution and automatic
performance optimizations make it possible for all your users to quickly and
simultaneously analyze data regardless of the number of users or the size of the data.

Accelerate your insights with powerful analysis

Get insights from your data faster without needing to copy or move it. Google
BigQuery gives you full view of all your data by seamlessly querying data stored
in BigQuery’s managed columnar storage, Google Cloud Storage, Google Cloud Bigtable,
Google Sheets and Google Drive. BigQuery integrates with existing ETL tools like
Informatica and Talend to enrich the data you already use. BigQuery supports
popular BI tools like Tableau, MicroStrategy, Looker, Google DataStudio out of
the box, so anyone can easily create stunning reports and dashboards. Automatically
ingest and visualize Google Ads and marketing data using BigQuery Data Transfer
Service to set-up a high-powered marketing data warehouse in just a few clicks.

BigQuery Features

A fast, highly scalable, cost-effective and fully-managed enterprise data warehouse for analytics at any scale.

Serverless

Serverless data warehousing gives you the resources you need, when you need them.
With BigQuery, you can focus on your data and analysis, rather than operating and
sizing computing resources.

Real time analytics

BigQuery’s high-speed streaming insertion API provides a powerful foundation
for real-time analytics. BigQuery allows you to analyze what’s happening now by
making your latest business data immediately available for analysis.

Automatic High Availability

Free data and compute replication in multiple locations means your data is
available for query even in the case of extreme failure modes. BigQuery transparently
and automatically provides durable, replicated storage and high-availability
with no extra charge and no additional setup.

Standard SQL

BigQuery supports a standard SQL dialect which is ANSI:2011 compliant, reducing
the need for code rewrite and allowing you to take advantage of advanced SQL features.
BigQuery provides free ODBC and JDBC drivers to ensure your current applications can
interact with BigQuery’s powerful engine.

Federated query and logical data warehousing

BigQuery breaks down data silos so you can analyze all your data assets from
one place. Through powerful federated query, BigQuery can process data in object
storage(Cloud Storage), transactional databases(Cloud Bigtable), or spreadsheets in
Google Drive -- all without duplicating data. One tool lets you query all
your data sources.

Storage and Compute separation

BigQuery provides you fine grained control of cost and access. With BigQuery’s
separated storage and compute, you can pay only for the resources you use. You have
the option to choose the storage and processing solutions that make sense for
your business, and control access for each.

Automatic backup and easy restore

BigQuery automatically replicates data and keeps a 7-day history of changes,
reducing worries about unexpected data changes. This allows you to easily restore
and compare data from different times.

Data Transfer Service

BigQuery makes it easy to get started with data warehousing, even if your data is
in a SaaS application. The BigQuery Data Transfer
Service automatically transfers data from external data sources like DoubleClick,
AdWords, YouTube to Google BigQuery on scheduled and fully-managed basis.

Big Data ecosystem integration

With Cloud Dataproc and Cloud Dataflow, BigQuery provides integration with the Apache
Big Data ecosystem, allowing existing Hadoop/Spark, and Beam workloads to read
or write data directly from BigQuery. BigQuery allows you to get the most out of
structured data by making it easy to analyze in SQL and easy to integrate with your
existing Big Data jobs, so you don’t have to throw away the work you’ve already done.

Petabyte scale

BigQuery is fast and easy to use on data of any size. With BigQuery you’ll get great
performance on your data, while knowing you can scale seamlessly to store and analyze
petabytes more without having to buy more capacity.

Flexible pricing models

BigQuery enables you to choose the pricing model that best suits you. On-demand
pricing lets you pay only for the storage and compute that you use. Flat-rate Pricing
enables high-volume users or enterprises to choose a stable monthly cost for analysis.
For more information, see BigQuery Pricing.

Data Encryption and Security

You have full control over who has access to the data stored in Google BigQuery.
BigQuery makes it easy to maintain strong security with fine-grained identity and
access management with Google Cloud IAM,
and your data is always encrypted at rest and in transit.

Data Locality

You have the option to store your BigQuery data in US and European locations while
continuing to benefit from a fully managed service. BigQuery gives you the option
of geographic data control, without having the headaches of setting up and managing
clusters and other computing resources in-region.

Load your data from Google Cloud Storage or Google Cloud Datastore backups,
or stream it into BigQuery at thousands of rows per second to enable real-time analysis
of your data. Use familiar data integration tools like Informatica, Talend
and others out of the box.

Data Governance

BigQuery provides fine-grained access controls on data and role-based control
on API through integration with
Google Cloud IAM. With BigQuery
and Cloud IAM, you can be sure your data is safe from unauthorized access.

Programmatic interaction

BigQuery provides a REST API for easy programmatic access and application integration.
To enable programmers of all types, BigQuery offers client libraries in Java, Python,
Node.js, C#, Go, Ruby, and PHP. Business users can use Google AppScript to access
BigQuery from Google Sheets.

Rich monitoring and logging with Stackdriver

BigQuery provides rich monitoring, logging and alerting through
Stackdriver Audit Logs. BigQuery resources
can be monitored at a glance, and BigQuery can serve as a repository for logs from
any application or service using Stackdriver Logging.

Cost Controls

BigQuery provides cost control mechanisms that enable you to cap your daily costs.
Click here for more information on
cost controls.

“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

“Google BigQuery delivers a cost-effective and fast analytics environment. We
can do exploratory analytics that we would never have the time to build
ourselves and make much more informed decisions about whether to block a
transaction or kill a user account. BigQuery is a huge differentiator that
lets us offer cutting-edge services without driving up our staffing
and IT costs.”

“BigQuery was the decisive factor when we made our choice. It’s a unique
service among cloud providers. Look into big data systems such as Hadoop
or Spark Stack and there's a lot of complexity. BigQuery has all of that
complexity while offering a familiar SQL interface. Most people in our team
have a BI background and are familiar and skilled with SQL. BigQuery offers
big data processing capabilities through a clean programmable api.
On top of that, it had a very good connector with Tableau.”

If you pay in a currency other than USD, the prices listed in your currency on
Cloud Platform SKUs apply.

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.

If you pay in a currency other than USD, the prices listed in your currency on
Cloud Platform SKUs apply.

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

BigQuery Partners

Google BigQuery unlocks the full potential of data warehousing in the cloud for
a broad array of tools and partners. From data
integration to analytics, Google Cloud partners have integrated their industry
leading tools with BigQuery for loading, transforming and visualizing data, enabling
customers to leverage BigQuery’s agility, performance, and ease of use to deliver
faster, more powerful insights.