Provide an analytics service that can help to gain insights across data stored in data warehouses

Stay organized with collections Save and categorize content based on your preferences.

Features

Built-in machine learning

BigQuery ML enables data scientists and data analysts to build and operationalize ML models on planet-scale structured, semi-structured, and now unstructured data directly inside BigQuery, using simple SQL—in a fraction of the time. Export BigQuery ML models for online prediction into Vertex AI or your own serving layer. Learn more about the models we currently support.

Real-time analytics with built-in query acceleration

BigQuery has built-in capabilities that ingest streaming data and make it immediately available to query, along with native integrations to streaming products like Dataflow. Analyze large datasets interactively with BigQuery BI Engine, an in-memory analysis service that offers sub-second query response time and high concurrency. BI Engine natively integrates with Looker Studio and works with many BI tools, including Connected Sheets.

Unify, manage, and govern all types of data

Query all data types with BigQuery: structured, semi-structured and unstructured. Use BigLake to explore and unify different data types and build advanced models. Centrally discover, manage, monitor, and govern data across data lakes, data warehouses, and data marts with consistent controls with Dataplex, an intelligent data fabric that enables organizations to provide access to trusted data. 

Geospatial analysis with BigQuery

BigQuery geospatial uniquely combines the serverless architecture of BigQuery with native support for geospatial analysis, so you can augment your analytics workflows with location intelligence. Simplify your analyses, see spatial data in fresh ways, and unlock entirely new lines of business with support for arbitrary points, lines, polygons, and multi-polygons in common geospatial data formats.

Spreadsheet interface

Connected Sheets allows users to analyze billions of rows of live BigQuery data in Google Sheets without requiring SQL knowledge. Users can apply familiar tools—like pivot tables, charts, and formulas—to easily derive insights from big data. Learn more about Connected Sheets in the getting started guide.

Real-time change data capture and replication

Synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency with Datastream. Datastream integrates with purpose-built and extensible Dataflow templates to pull change streams written to Cloud Storage, and create up-to-date replicated tables in BigQuery for real-time analytics.

Standard SQL

BigQuery supports a standard SQL dialect that is ANSI:2011 compliant, which reduces the need for code rewrites. BigQuery also provides ODBC and JDBC drivers at no cost to ensure your current applications can interact with its powerful engine.

Materialized Views

Accelerate query performance and reduce costs within your environment with BigQuery materialized views. It is easy to set up, effortless to use, and best of all it's real time, allowing you to quickly get answers to your questions.

Petabyte scale

Get great performance on your data, while knowing you can scale seamlessly to store and analyze petabytes to exabytes of data with ease.

Data governance and security

Public datasets

Google Cloud Public Datasets offer a powerful data repository of more than 200 high-demand public datasets from different industries. Google provides free storage for all public datasets, and customers can query up to 1 TB of data per month at no cost.

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.

Run sample query

Common Uses

Transfer data into BigQuery

Data warehouse migration

Real-time analytics

Predictive analytics

Log analytics

Marketing data warehouse

Pricing

How BigQuery pricing works BigQuery pricing is based on analys type, storage costs, additional services, and data ingestion and extraction. Loading and exporting data are free.
Services and usageSubscription typePrice (USD)
Free tier

The BigQuery free tier gives customers 10 GB storage, up to 1 TB queries free per month, and other resources.

Free

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 1TB per month is free

Monthly flat-rate commitment

Best for customers who prefer a stable cost for queries rather than paying on-demand.

Starting at

$2,000

for 100 slots per month

Annual flat-rate commitment

Best for stable cost for queries rather than paying on-demand. Save more with an annual commitment.

Starting at

$1,700

for 100 slots per month

Flex short-term commitment

Pay for slots for 60 seconds, and each second thereafter until you delete or change your commitment.

Starting at

$4.00

for 100 slots per month

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

Pricing calculator

Estimate your monthly BigQuery costs, including region specific pricing and fees.

Estimate your costs

Custom quote

Connect with our sales team to get a custom quote for your organization.

Request a quote

Start your proof of concept

Query a public dataset in the Google Cloud console

Get started

Learn how to create and use tables in BigQuery

Learn more

FAQ

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. BigQuery customers can see up to 27% lower three-year TOC than cloud data warehouse alternatives.

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-premise to cloud data warehouses, which provides more cost savings, scalability and flexibility.

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.

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. 

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.

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.

Other inquiries and support

[{ "type": "thumb-down", "id": "hardToUnderstand", "label":"Hard to understand" },{ "type": "thumb-down", "id": "incorrectInformationOrSampleCode", "label":"Incorrect information or sample code" },{ "type": "thumb-down", "id": "missingTheInformationSamplesINeed", "label":"Missing the information/samples I need" },{ "type": "thumb-down", "id": "otherDown", "label":"Other" }] [{ "type": "thumb-up", "id": "easyToUnderstand", "label":"Easy to understand" },{ "type": "thumb-up", "id": "solvedMyProblem", "label":"Solved my problem" },{ "type": "thumb-up", "id": "otherUp", "label":"Other" }]

Which service in AWS is best used for data analytics and data warehousing?

Tens of thousands of customers today rely on Amazon Redshift to analyze exabytes of data and run complex analytical queries, making it the most widely used cloud data warehouse. Run and scale analytics in seconds on all your data without having to manage your data warehouse infrastructure.

What are the data analytics services?

Data analytics implies building an infrastructure for data aggregation, analysis, and reporting. An experienced provider of data analytics services, ScienceSoft delivers on simple and complex needs with tailored business analytics solutions.

Which of the following AWS services can help you with data analytics?

AWS Glue. AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics.

What are the four main types of data analytics?

Four main types of data analytics.
Predictive data analytics. Predictive analytics may be the most commonly used category of data analytics. ... .
Prescriptive data analytics. ... .
Diagnostic data analytics. ... .
Descriptive data analytics..