Capterra Logo
Helping businesses choose better software since 1999
Google Cloud BigQuery

Google Cloud BigQuery

4.8 (29)
Capterra offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links.

What is Google Cloud BigQuery?

BigQuery is a serverless, multi-cloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely scale analytics, share rich data experiences with built-in BI, and train and deploy ML models with a simple SQL interface, helping to make your organization’s operations more data-driven.

Do you work for Google?Manage this profile page

Google Cloud BigQuery Integrations

Google Analytics 360 logo
Google Analytics 360
Google Ads logo
Google Ads
Google Data Studio logo
Google Data Studio
Looker logo
Looker
Google Cloud Compute Engine logo
Google Cloud Compute Engine
Migrate data warehouses to BigQuery. Solve for today’s analytics demands and seamlessly scale your business by moving to Google Cloud’s enterprise data warehouse.
Bring any data into BigQuery. Make analytics easier by bringing together data from multiple sources in BigQuery.
Build scalable marketing data warehouses. Marketing data warehouses let you deliver high quality advertising experiences that increase performance. BigQuery offers seamless data connectors into Google Ads, Campaign Manager, and other platforms.
Event-driven analysis. Gain a competitive advantage by responding to business events in real-time with event-driven analysis. Built-in streaming capabilities automatically ingest streaming data and make it immediately available to query.
BigQuery Cloud Console

Software like Google Cloud BigQuery

Based on other buyer's searches, these are the products that could be a good fit for you.

by Funnel

4.7 (19)
Starting Price:No pricing found
Tableau

by Salesforce

4.6 (2316)
Starting Price:$15/month
Snowflake

by Snowflake

4.7 (86)
Starting Price:$23/month
Google Cloud

by Google

4.7 (2091)
Starting Price:No pricing found
4.6 (1968)
Starting Price:$13748/one time

How much is Google Cloud BigQuery?

Starting From:
$2000 Per Month
Pricing Model: Flat Rate
  • Yes, has free trial
  • Yes, has free version
Pricing Details (Provided by Vendor):
Free Trial: New customers get $300 in free credits to spend on BigQuery during the first 90 days. Free Usage per Month: All customers get 10 GB storage and up to 1 TB queries free per month, not charged against their credits. General Pricing: BigQuery charges for data storage, streaming inserts, and querying data, but loading and exporting data are free of charge. • Storage: $0.02 per GB, per month and $0.01 per GB, per month for long-term storage • Streaming inserts: $0.01 per 200 MB

Google Cloud BigQuery Features

What solutions does Google Cloud BigQuery provide?

Alternatives to Google Cloud BigQuery

Google Cloud BigQuery
Google Cloud BigQuery

Starting from:
$2000/Per Month
Pricing Model:
Flat Rate

Overall Rating:

Ease of Use
4.4
Customer Service
4.0
Features
4.7
Value for Money
4.5
Grow

Starting from:
Not provided by vendor
Pricing Model:
Flat Rate

Overall Rating:

Ease of Use
4.2
Customer Service
4.5
Features
4.2
Value for Money
4.3
Zoho Analytics

Starting from:
$30/Per Month
Pricing Model:
Flat Rate

Overall Rating:

Ease of Use
4.2
Customer Service
4.1
Features
4.2
Value for Money
4.3
Minitab

Starting from:
$1780/Per Year
Pricing Model:
Flat Rate

Overall Rating:

Ease of Use
4.1
Customer Service
4.2
Features
4.4
Value for Money
4.2

Google Cloud BigQuery Reviews

Showing 5 of 29 reviews
Overall
4.8
Ease of Use
4.4
Customer Service
4.0

Pros

  • Free Tier access, query execution on the free tier, connection of Big Query from other market tools and best of the best we can directly connect with Google Sheet.

  • It is pretty straightforward to set up and allows for lots of data inputs. It's data visualization and statistics are amazing and provide useful insight.

  • Importing information from Google Sheets seems like a super advantage to me, as does the ability to execute large queries without affecting performance.

  • The sandbox supports up to 4 ( I think) projects that you can work on for free. This is great for people who are just starting out and BigQuery is very affordable as a whole.

Cons

  • Once the table is created it is difficult to edit the columns, so you have to delete it.

  • We have also built a dashboard where we make a conciliation of our clients' data, in case something goes wrong, we immediately realize what is happening.

  • Currently loading up multiple datasets on the same project and / or opening multiple tabs for queries makes everything really confusing and hard to navigate.

  • Sometimes when you make complex SQL queries, the debugging tool does not help a lot finding the problem.

Most Helpful Reviews for Google Cloud BigQuery

Vaibhav G. avatar
Vaibhav G.
Software Developer
Computer Software, 11-50 employees
Used the software for: 6-12 months
Overall Rating
5.0
Ease of Use
5.0
Customer Service
4.0
Features
5.0
Value for Money
5.0
Likelihood to Recommend
9/10
Reviewer Source
Source: Capterra
December 24, 2024

"Review of BigQuery Query Execution and Use Cases."

Overall: Free Tier access, query execution on the free tier, connection of Big Query from other market tools and best of the best we can directly connect with Google Sheet. It is very to use and implement into software using data stream to connect with databases as well.

Pros: It is very help full to store large unstructured data and further etl the data and used for analytics.

Cons: For Beginners it is costly. Overall very fast and reliable.

Switched From: Amazon Redshift
Reasons for Switching to Google Cloud BigQuery: Fast Synchronization and Data Stream From Google Cloud SQL
Verified Reviewer
Data Analytics Manager
Logistics and Supply Chain, 201-500 employees
Used the software for: 2+ years
Overall Rating
4.0
Ease of Use
5.0
Features
4.0
Value for Money
3.0
Likelihood to Recommend
7/10
Reviewer Source
Source: Capterra
June 20, 2022

"Great serverless cloud data warehouse"

Overall: We used BigQuery to analyze firebase events data from our mobile apps. Considering the sheer volume of this dataset, querying has been mostly very fast and reliable, albeit at a high cost.

Pros: I like the serverless nature of BigQuery. It takes away most of the maintenance costs involved in maintaining and fine-tuning a data warehouse.

Cons: I didn't really like the on-demand pricing of BigQuery. Monthly costs tend to blow up excessively. I think they have a different pricing option now to resolve this though.

Alternatives Considered: Databricks, Presto and Snowflake
Reasons for Choosing Google Cloud BigQuery: BigQuery has a native integration with Firebase.
Chhaya S. avatar
Chhaya S.
Marketing Manager
Food & Beverages, 201-500 employees
Used the software for: 1-2 years
Overall Rating
3.0
Ease of Use
4.0
Customer Service
2.0
Features
4.0
Likelihood to Recommend
8/10
Reviewer Source
Source: Capterra
September 18, 2022

"Get started with BigQuery, A powerful tool for analysing Big data"

Pros: Our salesforce campaigns relies heavily on data warehouse, which is the backbone of everything we do. This data set contains both row data sets and BigQuery is used to aggregate this sets by running schedule queries on it.

Cons: This platform requires strong SQL skills. Huge dependency on tech team to fix queries sometime.

Switched From: Supermetrics
pratik C.
Data Engineer
Computer Software, 11-50 employees
Used the software for: 6-12 months
Overall Rating
5.0
Ease of Use
5.0
Customer Service
4.0
Features
4.0
Value for Money
5.0
Likelihood to Recommend
10/10
Reviewer Source
Source: Capterra
December 23, 2024

"Worth a try for datawarehousing loads"

Pros: Free 1TB compute User friendly web UI Amazing web SQL editor

Cons: I can't find anything wrong with biguery

Alternatives Considered: Amazon Redshift
Reasons for Choosing Google Cloud BigQuery: Easy onboarding for smaller teams Free compute allowed my team to experiment a lot with BigQuery
Bryan H.
Director of Technical Operations
Marketing and Advertising, 11-50 employees
Used the software for: 2+ years
Overall Rating
5.0
Ease of Use
5.0
Customer Service
5.0
Features
5.0
Value for Money
5.0
Likelihood to Recommend
10/10
Reviewer Source
Source: Capterra
September 7, 2024

"GBQ is an analysts best friend"

Overall: GBQ powers a lot of our analysis tooling and reps use it directly with Python to make their own custom flows.

Pros: Literally everything. GBQ takes tasks like partitioning, building feeds from/to other systems simple, fine-grain access controls, plugs into Looker like a dream, built in connectors for other Google products (Search console, GA)

Cons: The permission-ing for GBQ can sometimes be vague depending on what the user is needing/wanting to do. Some roles require items that you think would be included in higher access level roles (I'm looking at you BigQuery Job User role).