BigQuery

What is BigQuery?

BigQuery is a fully-managed enterprise data warehouse for analytics at any scale.

BigQuery is a Google Cloud Platform tool - a database-as-a-service (DBaaS) maintaining the querying and rapid analysis of enterprise-level big data. This is one of the best parallel solutions for Google Analytics, able to store terabytes of data.

This cloud data warehouse service is a solution for not only Google Analytics data management, but also for any other data that users need to store and analyze. BigQuery does not require a server or a database administrator, it is low-cost, and makes data analytics productive.

The key parts of this solution are the fast SQL-based queries, capacity scaling, integration with more existing ETL tools, logical data warehousing, automatic backup, and more. The service is free for up to 1TB of data analyzed each month and 10GB of data stored.



BigQuery Awards


BigQuery currently scores 91/100 in the Big Data category. This is based on user satisfaction (90/100), press buzz (89/100), and other relevant information on BigQuery gathered from around the web.

The score for this software has declined over the past month. What is this?
cloud.google.com
  • BigQuery
  • BigQuery
  • BigQuery
  • BigQuery
  • BigQuery
  • BigQuery

BigQuery Product Overview

  • Serverless

  • Real-Time Analytics

  • Automatic High Availability

  • Standard SQL

  • Federated Query and Logical Data Warehousing

  • Storage & Compute Separation

  • Automatic Backup & Easy Restore

  • Data Transfer Service

  • Big Data Ecosystem Integration

  • Petabyte Scale


Languages Supported: English, German, Spanish, French, Italian, Dutch, Portuguese, Turkish, Serbian, Chinese, Korean

Big Data Software Buyer Guide 2024

Product recommendations, vendor rankings, market overview and tips on how to select Big Data software for business. Published in November 2024.

Big data is continuously gaining importance in the business world. Businesses today, regardless of their scale and industry, collect large volumes of data about key processes and stakeholders with the view to generating actionable insights. Big data solutio...

FREE DOWNLOAD

BigQuery Features

  • 2-Factor Authentication
  • A/B Testing
  • Analytics
  • API
  • Calendar Management
  • Contact Management
  • Conversion Tracking
  • Dashboard
  • Data Export
  • Data Import
  • Data Mining
  • Data Visualization
  • External Integrations
  • Forecasting
  • Keyword Tracking
  • Link Tracking
  • Multi-Site
  • Multi-User
  • Notifications
  • Referral Tracking
  • Scheduling
  • SEO
BigQuery Pricing

BigQuery Pricing Plans

Storage

$0.02
Per GB, Per Month
  • First 10 GB is free each month.

Long Term Storage

$0.01
Per GB, Per Month
  • Price of storage drops by 50 percent to $0.01 per GB per month for inactive tables.
  • No degradation of performance, durability, availability, or any other functionality for long term storage tables.
  • $0.02 per GB per month for actively edited tables.

Streaming Inserts

$0.05
Per GB
  • Loading data into BigQuery is free, except for a small charge for streamed data
  • Storage pricing is based on the amount of data stored in your tables.

Queries

$5.00
Per TB
  • You aren't charged for queries that return an error, or for cached queries.
  • Charges are rounded to the nearest MB, with a minimum 10 MB data processed per table and per query.
  • Cancelling a running query job may incur charges.

Plans starting from: $0.02/month Credit card required: No

BigQuery FAQs

Does BigQuery offer guides, tutorials and or customer support?

Support: Knowledge Base, Tutorials, Training, Help Center, Email Support, Community.

What is BigQuery generally used for?

BigQuery is used as an enterprise analytics data warehouse.

Does BigQuery integrate with any other apps?

It integrates with Alooma, Blendo, Fivetran, Funnel, Atom Data, Informatica, Lytics, Matillion ETL, SAP, Segment, SnapLogic, Stitch, Striim, Switchboard, Skyvia, Talend, Treasure Data, Xplenty.

Who are the main user groups of BigQuery?

Main users of this service are data scientists and analysts in enterprises.

What are some applications BigQuery is commonly used in tandem with?

It is most commonly used in tandem with Google Analytics.

Does BigQuery offer an API?

Yes, it offers REST API.

What platforms does BigQuery support?

This is a web-based platform.

BigQuery Competitors BigQuery Alternatives

BigQuery Alternatives & Competitors

Talend
Talend
  65 86/100
Big Data Software
Couchbase
Couchbase
  100 88/100
Big Data Software
Treasure Data
Treasure Data
  143 90/100
Big Data Software
Palantir Gotham
Palantir Gotham
  1 86/100
Big Data Software
MapR
MapR
  5 85/100
Big Data Software
Devo
Devo
  4 83/100
Big Data Software

BigQuery User Reviews

Average User Rating:
4.5/5 based on 6412 user ratings.
Your Rating:
User profile picture

""A Wonderful And Crazy Fast Solution For Data Warehousing And OLAP Analytics""


What do you like about BigQuery?

The speed of BigQuery has no comparison. It's absolutely insane how quickly we are able to query multi-terabyte tables--even when performing aggregations or statistical functions

What do you dislike about BigQuery?

I'm not a huge fan of the interface and it's seemingly silly limitations (like only being able to export up to 10MB resultsets).

What have you been using it for and what problems did BigQuery solve?

In one line, it's a wonderful tool. It does exactly what it says, and does that astonishingly well. We have been using this for almost 3 years now. And never have faced any issues, barring a few minor ones, that too quite occasionally. Running funnel-like queries on datasets containing more than a billion records usually completes within 10-20 seconds. Running simple count queries takes less than a second or two. Pricing is exactly how a SaaS vendor would love to have. It's based on data stored and data scanned during query executions. You don't have to manage any machines, neither do have to pay for them. You only pay for what you use. We have evaluated a few other alternatives as well, some hosted ones, other, on-premise. None of them came even distant close to BigQuery's performance. Coming to cons, we really haven't found any. Earlier, around 3 years back, updates and deletes to data were not supported, but they are now very well supported, although with restrictions. This makes sense too as BigQuery is meant to be a data-warehousing solution, not OLTP alternative. So give this a try. You'll be surprised at it's performance :)

4/5
Usefulness
5/5
Ease of use
4/5
Value for money
5/5
Customer service
Back to top