---
title: Google Cloud BigQuery Reviews
meta_title: 'Google Cloud BigQuery Reviews 2026: Details, Pricing, & Features | G2'
meta_description: Filter 1224 reviews by the users' company size, role or industry
  to find out how Google Cloud BigQuery works for a business like yours.
aggregate_rating:
  rating_value: 4.5
  review_count: 1224
  scale: '5'
date_modified: '2026-07-10'
parent_category:
  name: IT Infrastructure
  url: https://www.g2.com/categories/it-infrastructure
---

# Google Cloud BigQuery Reviews
**Vendor:** Google  
**Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse)  
**Average Rating:** 4.5/5.0  
**Total Reviews:** 1,224
## About Google Cloud BigQuery
BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Store 10 GiB of data and run up to 1 TiB of queries for free per month.



## Google Cloud BigQuery Pros & Cons
**What users like:**

- Users appreciate the **ease of use** in BigQuery, allowing them to run complex queries effortlessly. (156 reviews)
- Users highlight the **incredible speed** of Google Cloud BigQuery, making data handling efficient and user-friendly. (143 reviews)
- Users highlight the **fast querying capabilities** of Google Cloud BigQuery, making data analysis efficient and effortless. (120 reviews)
- Users value the **seamless integrations** of BigQuery with other Google Cloud products, enhancing their analytics capabilities significantly. (118 reviews)
- Users appreciate the **query efficiency** of Google Cloud BigQuery, highlighting its effortless processing of complex data. (114 reviews)
- Users appreciate the **scalability** of Google Cloud BigQuery, efficiently handling large datasets and providing fast performance. (112 reviews)
- Easy Integrations (99 reviews)
- Large Datasets (96 reviews)
- Efficiency Improvement (85 reviews)
- Performance (85 reviews)

**What users dislike:**

- Users find that the **cost can escalate quickly** with Google Cloud BigQuery if not carefully monitored. (127 reviews)
- Users struggle with **query issues** in BigQuery, facing challenges in cost management and optimization of queries. (78 reviews)
- Users express concerns over **cost issues** , particularly due to high expenses from poorly optimized queries. (63 reviews)
- Users find **cost management challenging** due to high fees for poorly optimized queries and small dataset limitations. (60 reviews)
- Users find the **learning curve** for advanced features in Google Cloud BigQuery challenging, contributing to billing misunderstandings. (54 reviews)
- Expensive Queries (53 reviews)
- Cost Estimation (46 reviews)
- Slow Performance (38 reviews)
- Slow Queries (33 reviews)
- Unclear Pricing (29 reviews)

## Google Cloud BigQuery Reviews
  ### 1. Best software for all your needs- In detail

**Rating:** 4.0/5.0 stars

**Reviewed by:** Raviteja K. | Business Development Executive, Small-Business (50 or fewer emp.)

**Reviewed Date:** September 20, 2024

**What do you like best about Google Cloud BigQuery?**

Using the Google cloud in day to day tasks to work on cloud data store help me seamlessly and carry on at easily implementating the new ways to data driven SQL to ful-fill the Machine learning requirements.

**What do you dislike about Google Cloud BigQuery?**

Working on the BigQuery for the daily tasks bit difficult But custommer support help to use number of uses of integeration to fix high level issues at very easy to by support. I use this service very frequently of use and helps.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

we got the best in data sloving towards the big issues like for big data analayzed datasets it limits the terms like data size issues to over come is by using small batches by turn around time to achive high volumes by rotations data driven tasks.

  ### 2. Great software and really helpful

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 13, 2024

**What do you like best about Google Cloud BigQuery?**

I love how it helps store my data with eaze and maximizes the value of the insights i can pull out

**What do you dislike about Google Cloud BigQuery?**

Maybe more storage on the platform would be very helpful for users

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Even though I can get data analytics done manually, the value that google cloud big query adds by maximizing the analytics is just immoecable7

  ### 3. Review of BigQuery Query Execution and Use Cases.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Vaibhav G. | Software Developer and Data Analyst, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 17, 2024

**What do you like best about Google Cloud BigQuery?**

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.

**What do you dislike about Google Cloud BigQuery?**

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

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

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

  ### 4. Developer friendly tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** Shikha S. | Data Scientist, Enterprise (> 1000 emp.)

**Reviewed Date:** November 26, 2024

**What do you like best about Google Cloud BigQuery?**

User friendly interface and fast retrieval of data

**What do you dislike about Google Cloud BigQuery?**

High long term costs are there and debugging can get bit challenging as detailed query execution details are not provided.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It provides cloud connectivity and we can directly fetch data from gcp to our python notebooks and work on them.

  ### 5. Awesome Cloud Tools

**Rating:** 5.0/5.0 stars

**Reviewed by:** Abhinav Kaushal K. | Lead Engineer, Mid-Market (51-1000 emp.)

**Reviewed Date:** December 18, 2024

**What do you like best about Google Cloud BigQuery?**

Large range of tools available for variety of tasks

**What do you dislike about Google Cloud BigQuery?**

Pricing information can be more detailed

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It provides wide range of cloud tools that allow tasks from data storage, streaming, processing, modeling and deploying in one place.

  ### 6. Awesome tool for BigData and reliable

**Rating:** 5.0/5.0 stars

**Reviewed by:** Srikar V. | DevOps Engineer, Enterprise (> 1000 emp.)

**Reviewed Date:** December 28, 2024

**What do you like best about Google Cloud BigQuery?**

We use BQ for analyzing firebase events data from our iOS mobile applications. It provides seamless data analysis for large dataset and querying was super fast and reliable.

**What do you dislike about Google Cloud BigQuery?**

At present there were no cons about this tool

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

In my project it solves slow data processing and queying issues and complexity of Infra management. With BigQuery we do not need to worry about managing clusters and handling performance tuning.

  ### 7. Finest tool for cloud storage in depth review

**Rating:** 4.5/5.0 stars

**Reviewed by:** Venkata Rao V. | Bench Sales recruiter, Small-Business (50 or fewer emp.)

**Reviewed Date:** September 12, 2024

**What do you like best about Google Cloud BigQuery?**

Google cloud BigQuery is ease to use to preform daily number of tasks at easy and effective manner and help to implementate high volume data BigQuery at high speed responses generated. Its high and ease integrations help to determin number of values in no time!

**What do you dislike about Google Cloud BigQuery?**

Its very high in cost, where not all the companies can effect high cost data integarations only the big companies which makes it few users and high effiency at compete with other company platforms.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Google CLoud BigQuery is helping to slove many daily task easy by doing multitasks at a time to finish the project effeciency to cloud data automations at peak level,
that benefitted me to delivery the project on time to the client!

  ### 8. Nothing but Amazing!

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Logistics and Supply Chain | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 16, 2024

**What do you like best about Google Cloud BigQuery?**

I think i really find it easy to use when it comes to upload of CSV files or such the customer support and how quick the query executes and integration with different datasets is quite usefull

**What do you dislike about Google Cloud BigQuery?**

The UI could be improve . At times find things is very difficult.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

BigQuery makes working with large datasets simple and fast. I can run complex queries without worrying about infrastructure or scaling issues, which saves me time. Its integration with tools like Python and Power BI fits seamlessly into my workflow, helping me build impactful dashboards and real-time analytics. It’s efficient, cost-effective, and lets me focus on delivering insights instead of managing systems.

  ### 9. A must have Cloud Analytics Tool

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 07, 2025

**What do you like best about Google Cloud BigQuery?**

I like BigQuery's ability to handle massive data with impressive speed and simplicity in handling SQL queries is commendable.

**What do you dislike about Google Cloud BigQuery?**

The costs of the monitoring can be high if you are not careful with optimizing the query sizes.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It addresses the challange of analyzing massive datasets in a scalable and cost-effective manner.It also integrate smoothly with other Google Cloud services and also simplifies the data visualisation with the help of Looker.

  ### 10. Efficient, Fast, and Secure

**Rating:** 4.5/5.0 stars

**Reviewed by:** Varun S. | Financial analysis, Financial Services, Small-Business (50 or fewer emp.)

**Reviewed Date:** February 14, 2025

**What do you like best about Google Cloud BigQuery?**

Rating: 4.5/5

it is fast and good for data storing.

**What do you dislike about Google Cloud BigQuery?**

It has drawbacks also seems costly to me.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Yeah it does solve problems and helps us to analyze large data sets. it is fast and good for complex infrastructure management.

  ### 11. Solid data warehouse

**Rating:** 3.5/5.0 stars

**Reviewed by:** John H. | Chief Data Officer, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 17, 2024

**What do you like best about Google Cloud BigQuery?**

Speed and cost are pretty good value comparison

**What do you dislike about Google Cloud BigQuery?**

I find the user interface to be inferior to Snowflakes UI.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

WE centralise all our data in BQ and use it for analysis and dashboarding.

  ### 12. A User's Perspective of Google Cloud BigQuery

**Rating:** 4.5/5.0 stars

**Reviewed by:** Kaung K. | Senior SDN Cloud Engineer, Enterprise (> 1000 emp.)

**Reviewed Date:** October 29, 2024

**What do you like best about Google Cloud BigQuery?**

I like best about google cloud bigQuery is a fully managed and serverless data warehouse that enables organizations to store, analyze and visualize large datasets. Also its architecture is designed for high performance that allows us to query large datasets in seconds.

**What do you dislike about Google Cloud BigQuery?**

Steep learning curve for enginner who are new to SQL or data warehousing.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Some traditional data warehouses often struggle to handle massive datasets and complex queries efficiently but BigQuery's serverless architecture and optimized query engine allow us to analyze petabytes of data in seconds and also cost-effectiveness for businesses of all sizes.

  ### 13. Best data warehouse with analytics and easy to implement ML models

**Rating:** 5.0/5.0 stars

**Reviewed by:** Dipak K. | Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.)

**Reviewed Date:** April 20, 2024

**What do you like best about Google Cloud BigQuery?**

i use bigquery especially as part of my lakehoue system, as it provides me with functionality such as in built analytics , data lineage, easy integration with other services such as dataflow , cloud functions. recently i came across with one GIS function which can calculate the exact location distance by just providing longitude and latitude

**What do you dislike about Google Cloud BigQuery?**

even though they almost cover all the usecases beginner might get trapped in the loop of documentation for finding simple solution for e.g. i wanted to query the percentiles of my one column for plotting boxplot, it took me half hour to figure out how to use it in a right way.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I mostly work on data engineering and ml related solutions and in my every project bigquery helps to achieve the analytics and ml model implementation with ease. Data partitioning feature saves the cost of querying data from petabytes of data resulting into faster retrieval and cost efficiency.

  ### 14. Bigquery review

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.)

**Reviewed Date:** January 15, 2025

**What do you like best about Google Cloud BigQuery?**

Bigquery offers one stop solution for all the data transformation and insights as well. We can even train machine learning model directly with a single SQL query

**What do you dislike about Google Cloud BigQuery?**

Google support is slow on some support tickets raised

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

We recently shifted from on Prem storage to cloud. the Pay as we use model is benifitting us immensely.

  ### 15. Bigquery is an easy to use SQL Editor for GCP

**Rating:** 4.5/5.0 stars

**Reviewed by:** Bhavesh G. | System Analyst, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 04, 2024

**What do you like best about Google Cloud BigQuery?**

Bigquery is an easy to use tool to write your SQL queries for GCP. the UI is very easy to use and it also gives suggestion for queries using Gemini.

**What do you dislike about Google Cloud BigQuery?**

Sometimes the SQL behaves abruptly and take huge amount of time to update few records also.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It solves problem for all your analytical needs. It also gives you graph wise execution of Query to see step wise execution.

  ### 16. Experience using Google Cloud Dialogflow for the Rice Shop Chatbot application

**Rating:** 5.0/5.0 stars

**Reviewed by:** Wadi W. | Mentor Front-End Developer, Small-Business (50 or fewer emp.)

**Reviewed Date:** May 09, 2024

**What do you like best about Google Cloud BigQuery?**

Because of its ease of applying chatbots, composing words to be read, and easy integration into Flutter. Another advantage is that it's dialogflow free so I don't have to worry about costs. For BigQuery, the usage is very easy, the coding is also easy, and the output is very clear.

**What do you dislike about Google Cloud BigQuery?**

There are features that are locked due to cost issues, because I don't use costs so that the features obtained are not maximized, besides that there is not much dialogflow documentation. For BigQuery has little documentation

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

What is solved is the problem of creating a chatbot and producing appropriate output and customers of my application can get the right information according to what I set in the chatbot. For BigQuery, the problem solved is that I can process data very easily so that the output data can be processed properly.

  ### 17. My experience of Google BigQuery

**Rating:** 5.0/5.0 stars

**Reviewed by:** Pranav K. | Data Analyst, Small-Business (50 or fewer emp.)

**Reviewed Date:** January 20, 2025

**What do you like best about Google Cloud BigQuery?**

The best thing about Google BigQuery is it's data processing while extra tong the data. Besides of this it is good for storing columnar data.

**What do you dislike about Google Cloud BigQuery?**

The thing I dislike about Google BigQuery is difficulty in handling very big data.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Google BigQuery helps me in uncovering hidden insights and finding business trends.

  ### 18. Bigquery: An efficient data warehousing tool

**Rating:** 4.0/5.0 stars

**Reviewed by:** Kshitij D. | SDE-1, Mid-Market (51-1000 emp.)

**Reviewed Date:** July 08, 2024

**What do you like best about Google Cloud BigQuery?**

The feature that i like the most about bigquery is the simplified UI experience as compared to it counterparts and other cloud providers. Also the seamless integration with Google products like google adds is a great add on to have.

**What do you dislike about Google Cloud BigQuery?**

Despite the numerous features provided by BQ, it has one drawback is it's lagging behaviour when the number of enteries the the tables increases significantly.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It is solving a lot of problems for us like:

It provides seamless integration with data analytic tools like looker.
It provides great integration with gcp buckets.
It lets you run SQL queries in the console itself helping to get insight from the data.

  ### 19. Experience Google Big Query with Google Analytics 4 - Its magical!

**Rating:** 4.5/5.0 stars

**Reviewed by:** Dheeraj Kumar D. | Senior Data Analyst, Enterprise (> 1000 emp.)

**Reviewed Date:** May 14, 2024

**What do you like best about Google Cloud BigQuery?**

Its the ease of using the cloud functions/ automation that makes it best .Its also easy to implement and integrate it your current Software pool.It allows us to get macro level user data which is very helpful for analysis which we do very frequently.
The customer support was good and the min time to response was <6hrs.

**What do you dislike about Google Cloud BigQuery?**

Couple of things that i would like Google to work on are - they have removed the unsampled data export thats present in Gogle Analytics 4 which is making us use the Big Query for data extraction. Due to this the cost for data extract is quite high.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It helps me get granular level user data to understand the user behaviour towards our product. This could only be achived by the help of Google Analytics and Big Query.

  ### 20. Used Big Query cloud to analyze our large dataset as I'm a data analyst.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ashvini G. | Database Marketing Specialist, Enterprise (> 1000 emp.)

**Reviewed Date:** October 10, 2024

**What do you like best about Google Cloud BigQuery?**

There is no doubt that this is one of the best cloud-based data warehouses, I majorly use it for analysis of our company's large dataset.
It's swift and efficient, you can also run complex SQL queries irrespective of structured or semi-structured data.
very quick
Compared to redshift, big query gives very quick results even while using complex SQL queries for the data that are too old.

**What do you dislike about Google Cloud BigQuery?**

so far i have come across one limitation which is data export.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Every month Google provides free terabytes of queries and you can load your data at no cost, up to 10GB.

  ### 21. Big query as warehouse at scale

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.)

**Reviewed Date:** January 27, 2025

**What do you like best about Google Cloud BigQuery?**

It great it has lot of features (user defined functions, procedures,views)

**What do you dislike about Google Cloud BigQuery?**

At scale its not very fast sometimes it takes more time to fetch the result

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Having clean data for repoting big query as a sql tool helps to transform/clean data

  ### 22. Great but long learning curve

**Rating:** 4.0/5.0 stars

**Reviewed by:** Kush P. | Founding Engineer, Small-Business (50 or fewer emp.)

**Reviewed Date:** January 17, 2025

**What do you like best about Google Cloud BigQuery?**

It has most of the services that i used to code my self

**What do you dislike about Google Cloud BigQuery?**

It has a long learning curve and most of the code needs to be in google apis

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I am right now managing customer data using bigquery for analytics and making reports

  ### 23. Great experience

**Rating:** 4.0/5.0 stars

**Reviewed by:** Shobhit D. | Research Assistant, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 04, 2024

**What do you like best about Google Cloud BigQuery?**

I haven’t used it for longer period yet but I am impressed by how fast integrates with other tools of GCP, it has very good scalability although it should have been bigger

**What do you dislike about Google Cloud BigQuery?**

I think the pricing part ehen Large models will come into picture is a concern for me

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I am easily able to pul date data feom GCP and run the SQL query seamlessly

  ### 24. Executing with big million records.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Thirumala Kaleshwarrao V. | Senior Data Engineer, Enterprise (> 1000 emp.)

**Reviewed Date:** February 21, 2025

**What do you like best about Google Cloud BigQuery?**

Excellent for execution the query on million records.

**What do you dislike about Google Cloud BigQuery?**

Only few public dataset are to practice.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Very fast to retrieve the millon records.

  ### 25. A comprehensive review based on my experience

**Rating:** 4.0/5.0 stars

**Reviewed by:** Anshul J. | Analyst , Small-Business (50 or fewer emp.)

**Reviewed Date:** November 14, 2024

**What do you like best about Google Cloud BigQuery?**

Ease to use.
Easy to be deployed. 
Can see data in excel without any unnecessary downloads.
Easy to integrate with different softwares
Data is highly available whenever i run my queries and deployed my data.
Customer support is there

**What do you dislike about Google Cloud BigQuery?**

It doesn't support different files types. Which make it difficult to use.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I work as a data engineer to my client as i used this to load and transform the data.

  ### 26. UI and query processing is very fast

**Rating:** 5.0/5.0 stars

**Reviewed by:** Harish V. | Data Engineer-III, Mid-Market (51-1000 emp.)

**Reviewed Date:** November 04, 2024

**What do you like best about Google Cloud BigQuery?**

Easy to use and query processing is very fast and can do advance analytics also

**What do you dislike about Google Cloud BigQuery?**

It is little costly have to pay for each query run

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Processing time and can handle large volume of data

  ### 27. I used BigQuery to operate on tables with large number of rows and had experience writing queries.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Prabhath G. | Machine Learning EN=ngineer, Small-Business (50 or fewer emp.)

**Reviewed Date:** August 26, 2024

**What do you like best about Google Cloud BigQuery?**

I worked on querying and stored terabytes of data on bigquery while we were trying to search for an alternative to Amazon redshift, as redshift was posing a lot of problems in scaling and managing resources. There is no need to think about the disk utilization and stuff, as in redshift. That was such a relief!

**What do you dislike about Google Cloud BigQuery?**

The lowest point in my experience was the integration between Google Cloud Storage and BigQuery, which I felt a little confusing for the first few times.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

There is no need to think about the disk utilization like other services, which makes working on the actual stuff a lot easier.

  ### 28. "Experience using Google Cloud Dialogflow for the Flower Shop Chatbot application"

**Rating:** 4.5/5.0 stars

**Reviewed by:** Muhammad R. | Small-Business (50 or fewer emp.)

**Reviewed Date:** May 14, 2024

**What do you like best about Google Cloud BigQuery?**

Because it is easy to arrange word by word to read, and easy to integrate into the Flutter programming language. Another advantage is that the dialogue flow is free so I don't have to worry about costs. How to use BigQuery is very easy, and the output is very clear.

**What do you dislike about Google Cloud BigQuery?**

I can't access some features without paying, which results in not optimal functionality. Additionally, the documentation for Dialogflow is also limited.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

The problem that has been resolved is a project that is able to produce the output I want, so that my application can get accurate information. For BigQuery, the problem that is resolved is the ease of processing data so that the output data can be processed properly.

  ### 29. Honest review: Google Cloud Bigquery

**Rating:** 4.0/5.0 stars

**Reviewed by:** Neeraj M. | Member of Technical Staff, Mid-Market (51-1000 emp.)

**Reviewed Date:** March 12, 2024

**What do you like best about Google Cloud BigQuery?**

Things that I liked about Google Cloud Big Query:

a) The ease to use of this platform makes it a better choice for me.
b) A lot of data formats are supported.
c) The low storage price is a huge bonus.
d) Allowance of querying data from various sources like AWS, and Azure is good.
e) For upgrades it doesn't require downtime.
f) Customer support is pretty good.

**What do you dislike about Google Cloud BigQuery?**

Things that I disliked about Google Cloud BigQuery:

a) Doesn't support data in real-time for sandbox projects.
b) SOmetimes lots of redundant data are there which leverages the cost.
c) Support outside the GCP is quite weak and can be improved.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

We are using big data analytics to understand and analyze customer behavior for our client projects that can lead to success of them. We have used it as a part of our data preprocessing pipeline for our AI related app.

  ### 30. Runs complex jobs smoothly

**Rating:** 4.5/5.0 stars

**Reviewed by:** Siddhant  A. | Lead - Analytics and MarTech, Mid-Market (51-1000 emp.)

**Reviewed Date:** September 16, 2024

**What do you like best about Google Cloud BigQuery?**

Speed and simplicity : the UI is striaghtforward and in comparsion to other tools, the queries execute faster even for big dataset

**What do you dislike about Google Cloud BigQuery?**

Costing is a bit tricky. While using it to analyse GA4 raw data, it has 60 days data expiration on tables.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

We use Bigquery to analyse the raw events captured by firebase and GA4.

  ### 31. My everyday daily tool guide review

**Rating:** 4.5/5.0 stars

**Reviewed by:** Ravi Teja K. | Bench Sales recruiter, Small-Business (50 or fewer emp.)

**Reviewed Date:** September 10, 2024

**What do you like best about Google Cloud BigQuery?**

The best tool to help to process cloud data to manage BigQuery data in warehouse to manage the loads of large data managent at ease of usage, and multi data sources like cloud, public data as well.

**What do you dislike about Google Cloud BigQuery?**

where the Bigquery is very expensive when its comes to data transfer comparied to other platforms out there and lack of compute customization for qurey process which little tough,

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

When we you dose't perform well at the time we use relational database, 
where its hard to process the single row append actions and multi batch ations at a time

  ### 32. My experience for BigQuery

**Rating:** 5.0/5.0 stars

**Reviewed by:** Pranav K. | Data Analyst, Information Technology and Services, Small-Business (50 or fewer emp.)

**Reviewed Date:** January 20, 2025

**What do you like best about Google Cloud BigQuery?**

The data extraction efficiency and capacity that BigQuery has.

**What do you dislike about Google Cloud BigQuery?**

I don't dislike too much BigQuery except the processesing data of high volume.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I extracted data and uncovered key insights using BigQuery.

  ### 33. Fast and cheap for Bigdata analytics

**Rating:** 4.0/5.0 stars

**Reviewed by:** Surya G. | Collibra Developer, Enterprise (> 1000 emp.)

**Reviewed Date:** December 17, 2024

**What do you like best about Google Cloud BigQuery?**

I am in data engineer team and I run different queries as well to do the data analysis and prediction

**What do you dislike about Google Cloud BigQuery?**

The UI is still the same it used to be 5 yr back. Compare to snowflake the UI looks but old

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Data analysis for our sales data.

  ### 34. Google Bigquery as a data warehousing solution.

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Consulting | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 05, 2024

**What do you like best about Google Cloud BigQuery?**

Google Bigquery should be the best go-to option for modern Data warehousing since it is based on cloud making it easy to implement. Serverless decoupled compute drives high scalability with little administration overhead. One thing I liked most is the availability/integration of other Google services that drives real-time data analytics. it is simple to use and beginner friendly with high availability of most recent data from Google trends in case someone wish to get their hands dirty with data. It supports SQL queries to execute super fast and GCP's identity and access management ensures our data is secure. The query results can be exported into various data types/ formats making it more flexible.

**What do you dislike about Google Cloud BigQuery?**

Although it is beginner friendly, to get to an advanced level in Bigquery, we might have to invest a considerable amount of time. The other thing I noticed is the comparatively high cost compared to other cloud datawarehouses.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

This cloud based Google product overcomes the rigidity associated with the data warehouses in scaling it. The SQL queries are superfast allowing better business analytics. HIgh availability of recent data of key search words drives efficient marketing analytics.

  ### 35. A Data Warehousing solution for Modern Analytics

**Rating:** 4.5/5.0 stars

**Reviewed by:** Nahista Abuzar A. | Senior Data Analyst, Mid-Market (51-1000 emp.)

**Reviewed Date:** November 22, 2024

**What do you like best about Google Cloud BigQuery?**

Easy to use for large datasets, fast query performance, scalability, built-in machine learning, powerful tool for modern data analytics.

**What do you dislike about Google Cloud BigQuery?**

limitation of query customization, high cost for large volume of data set, learning newcomers.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Managing and analyzing massive datasets efficiently by reducing operational overhead, accelerating decision-making, and enabling real-time analytics, machine learning integration, and data visualization with tools like Power BI and Tableau.

  ### 36. really good data analytics

**Rating:** 4.5/5.0 stars

**Reviewed by:** Ayabulela T. | admin, Mid-Market (51-1000 emp.)

**Reviewed Date:** January 09, 2025

**What do you like best about Google Cloud BigQuery?**

it helps alot with helping me with my reports

**What do you dislike about Google Cloud BigQuery?**

im not too sure yet, too soon to tell but will let you know but a little complicated

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

reporting systems for our big team

  ### 37. Beyond Data Warehouse

**Rating:** 4.5/5.0 stars

**Reviewed by:** Anwesh D. | Enterprise (> 1000 emp.)

**Reviewed Date:** May 16, 2024

**What do you like best about Google Cloud BigQuery?**

Onestop solution to multiple BigData problems, BigQuery is not just a Data Warehouse that scales infinitely, it is just more more than that, we often talk about distributed computing framework like Apache spark,Hadoop Bigquery is a modern solution to those problems with a simplified approach.Using your native SQL  semantics that helps you discover insights into your data along with its capabilities to drive ML models using something as simple as SQL Queries. it can also serve as a great platform to serve as a data lake house for storing different kinds of data in a combining with Google cloud storage and the easy integration. It has integration with all the GCP services along with other cloud services as well and one of the most brilliant feature, I like about BigQuery is that it is serverless which means that you don't have to manage any server or any CP utilisation or anything like that, it is completely seamless in terms of scalability.

**What do you dislike about Google Cloud BigQuery?**

There is very limited scope of changing the path of our execution, which is something that we don't have much control over when once we have the sql queries fired into the  Dremel engine of bigquery. yes, it's serves as an abstraction to the complexities of dealing with various explain plans and everything, but sometimes it helps to understand how some explain plans are being chosen over the other and how internally everything is getting you know drill down right from accessing the file system to fetching the data app, applying the filters and everything.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Like for example, in our last project, we had the data asset for our e-commerce system built in bigquery .so we had the data from various ERP systems into big query and we had historical data to analyse patterns. we had ML models driven in SQL to determine predict customer segmentation demo based on demographic planogram optimisation, drill down into various levels into package, detail orders detail, shipment, detail and analyse data quality issues and then it helps build not directly but indirectly. It helps build a reputation of the company, and it also provides a lot of actionable items that can serve as a predictive and prescriptive analytics. We were able to do inventory management, improve the operation operations of our e-commerce platform. We were able to predict the load of our front-end systems, so these were directly helping generate revenue using big query.

  ### 38. Pretty agile to use

**Rating:** 3.5/5.0 stars

**Reviewed by:** Umang A. | Manager - Strategic and Customer Insights, Enterprise (> 1000 emp.)

**Reviewed Date:** December 21, 2024

**What do you like best about Google Cloud BigQuery?**

Neat to use and is very quick. Interface is easy to understand but still requores some more case examples to get a grasp

**What do you dislike about Google Cloud BigQuery?**

A little bit difficult to navigate sometimes

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

I work in telecom so has helped with analysis around customers

  ### 39. Keep your Head in the Cloud.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Joseph M. | Senior Director Of Marketing, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 19, 2024

**What do you like best about Google Cloud BigQuery?**

Google Cloud BigQuery allows us to store massive amounts of data for aggregate data solutions.

**What do you dislike about Google Cloud BigQuery?**

Google Cloud BugQuery allows only for data inputted to be analyzed. I would like a more comprehensive data set.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Too much data storage for our storage capabilities.

  ### 40. Its fast

**Rating:** 4.5/5.0 stars

**Reviewed by:** Abhay G. | Data Analyst, Enterprise (> 1000 emp.)

**Reviewed Date:** January 17, 2025

**What do you like best about Google Cloud BigQuery?**

Its fast, flexible and we can easily schedule the automated jobs.

**What do you dislike about Google Cloud BigQuery?**

Its very expensive and some syntax are not supported

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Its reducing the time for querying bigdata

  ### 41. REALLY NICE TO USE

**Rating:** 5.0/5.0 stars

**Reviewed by:** Huzaifah M. | customer service, Mid-Market (51-1000 emp.)

**Reviewed Date:** December 19, 2024

**What do you like best about Google Cloud BigQuery?**

Problem: Traditional systems often lack the capability to process streaming data efficiently.

**What do you dislike about Google Cloud BigQuery?**

its a little expensive for me to pay for a big service

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Solution: BigQuery’s support for real-time streaming analytics enables businesses to analyze live data as it arrives.

  ### 42. Robust, Dynamic tool for computing, analytics and storage

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.)

**Reviewed Date:** January 11, 2025

**What do you like best about Google Cloud BigQuery?**

It's very easy to use, efficient and offers a lot of services at an effective price point compare to any other cloud platforms.

**What do you dislike about Google Cloud BigQuery?**

It's rigid for a few things like required date formats, etc. A dedicated customer support is also required for small businesses.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

It comes with a lot of intergations and other dynamic tools which makes it use for ETL,analytics and data warehousing as whole.

  ### 43. Easy to use cloud data query solution.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Ramy S. | Analytics Team Manager, Information Technology and Services, Mid-Market (51-1000 emp.)

**Reviewed Date:** April 24, 2024

**What do you like best about Google Cloud BigQuery?**

Google BigQuery is fast and reliable for analyzing massive datasets. The service has auto-scaling capabilities and integrates with other Google services like AI, data storage, and many other data services, allowing me to explore and transform large data sets for our analytics workload needs. BigQuery.

**What do you dislike about Google Cloud BigQuery?**

I have nothing against Google BigQuery, but the pricing and cost estimates can be tricky. I just wish I could be more confident about what my queries will actually cost.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Google BigQuery helps me easily explore, clean, and analyze massive HR datasets. The service saves me time and effort on the technical aspects of my work as it handles the Provisioning, scalability, and optimization and allows me to work more efficiently, focusing on business objectives.

  ### 44. BigQuery is full featured and easy to use for teams of any size

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.)

**Reviewed Date:** May 09, 2024

**What do you like best about Google Cloud BigQuery?**

BigQuery is very easy to use and implement, even with a small data team. It integrates seamlessly with the rest of our data stack, including Airbyte and Metabase. I frequently use the time-travel features when I am investigating data anomalies and to help backup and restore data as needed. I especially love that BigQuery SQL keeps up with modern SQL features, such as QUALIFY statements and GROUP BY ALL. Overall, I really enjoy using this product.

**What do you dislike about Google Cloud BigQuery?**

I occasionally run into blockers when I want to query from two different datasets accross different projects and regions in BigQuery. I also find the UI to be a bit clunky when I want to do a deeper analysis. I wish it behaved more like a notebook at times.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

BigQuery serves as our Cloud Data Warehouse to consolidate data from many sources. It scales with the size of our data and allows us to process and analyze valuable information to run our business.

  ### 45. really good with intergration

**Rating:** 4.5/5.0 stars

**Reviewed by:** Shaakira D. | retentions officer, Mid-Market (51-1000 emp.)

**Reviewed Date:** January 02, 2025

**What do you like best about Google Cloud BigQuery?**

its been helpful with my analytics and doing reports

**What do you dislike about Google Cloud BigQuery?**

its a little confusing but I am getting the hand of it

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

its helping alot because I can just pull my google data

  ### 46. Experience with BigQuery with an automation mindset

**Rating:** 5.0/5.0 stars

**Reviewed by:** Shaurya V. | Analytics Specialist, Mid-Market (51-1000 emp.)

**Reviewed Date:** July 02, 2024

**What do you like best about Google Cloud BigQuery?**

i have had an good experience with BigQuery when it comes to consol as alot of details are visible in some of the tabs

**What do you dislike about Google Cloud BigQuery?**

the issue with BQ is when it comes to API where some times the authentication failes or request limit is reached

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

we have our ML Models setup in GCP where we have all of the script running daily or weekly where we are pushing our records to BQ and the data is automatically updates our dashboards, dashboard just like google studio

  ### 47. BigQuery Brilliance: Google's data dynamic masterpiece

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ekta S. | Senior Executive - Data Science & Analytics, Enterprise (> 1000 emp.)

**Reviewed Date:** February 21, 2024

**What do you like best about Google Cloud BigQuery?**

1) Ease of usage - a very good simplistic user interface
2) Scalability -Can scale up to use petabytes of data
3) Speed - It has a greate speed in dealing with really massive datasets
4) Good customer support - Any query with respect to Bigquery usage is answered swiftly
5) Ease of Integration - BigQuery connectors allow easy transfer of data from one DB to the other.
6) Frequency of Use - Due to a higher frequency of use, Bigquery gives a comparatively higher edge in terms of cost management.
7) Ease of Implementation - Implementing SQL queries on Bigquery is a cakewalk

**What do you dislike about Google Cloud BigQuery?**

1) Data Ingress and Egress operation costs 
2) Complex pricing structure
3) Data privacy and compliance

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Bigquery is solving data processing challenges majorly scalable data warehousing, high performance analytics, simplified data management and so on. Its benefitting me by helping create the data lake which eases my task

  ### 48. Excellent

**Rating:** 4.5/5.0 stars

**Reviewed by:** Kaylie V. | admin, Mid-Market (51-1000 emp.)

**Reviewed Date:** January 09, 2025

**What do you like best about Google Cloud BigQuery?**

good with help with data and reportinggg.

**What do you dislike about Google Cloud BigQuery?**

its a bit complicated and takes time getting used to.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Helping me do things less manuallly and keep everything more oganised.

  ### 49. Fully managed and completely serverless enterprise data warehouse.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Sahil M. | Key Account Manager, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 10, 2024

**What do you like best about Google Cloud BigQuery?**

They provide end-to-end services with a brand.

**What do you dislike about Google Cloud BigQuery?**

Contracting is too big and long, it becomes tedious for smaller companies.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

There are multiple problems that are being addressed by Google Big Query is it as a large scale apart from SQL.

  ### 50. Loving it as a data analyst

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.)

**Reviewed Date:** July 02, 2024

**What do you like best about Google Cloud BigQuery?**

I love the way it works with simple UI. As a daily user for my needs to build dashboards it serves all the data analyst could expect for. I can build intensively large amount of queries without worrying about the data limitations if < 200MN rows. My clients also loved the final product which was easy to navigate and use.

**What do you dislike about Google Cloud BigQuery?**

Deprication of dremel as few syntaxes had to be changed. Dremel had a few unique features which F1 doesn't in BQ. Big queries and joining mutiple times takes more time but this is rare when we're trying to pull the unwanted data.

**What problems is Google Cloud BigQuery solving and how is that benefiting you?**

Combining large amounts of data effortlessly, i can join any number of tables and still would fetch the result faster.


## Google Cloud BigQuery Discussions
  - [Is BigQuery part of Google Cloud Platform?](https://www.g2.com/discussions/is-bigquery-part-of-google-cloud-platform) - 2 comments, 2 upvotes
  - [Is Big Query free?](https://www.g2.com/discussions/is-big-query-free) - 3 comments, 1 upvote
  - [When we can integrate](https://www.g2.com/discussions/when-we-can-integrate) - 1 comment, 1 upvote
  - [How BQ legacy SQl is different form the standard SQL?](https://www.g2.com/discussions/16021-how-bq-legacy-sql-is-different-form-the-standard-sql) - 1 comment, 1 upvote
  - [What is Google BigQuery based on?](https://www.g2.com/discussions/what-is-google-bigquery-based-on) - 1 comment

- [View Google Cloud BigQuery pricing details and edition comparison](https://www.g2.com/products/google-cloud-bigquery/reviews?page=5&section=pricing&secure%5Bexpires_at%5D=2026-07-10+12%3A58%3A35+-0500&secure%5Bsession_id%5D=36c84f64-517f-454e-9102-026ab228639e&secure%5Btoken%5D=136540ae14b58df4b23f8a46b9e2e83b24bfda2030428f80646c560396367ce6&format=llm_user)
## Google Cloud BigQuery Integrations
  - [Ab Initio](https://www.g2.com/products/ab-initio/reviews)
  - [Agentforce Sales (formerly Salesforce Sales Cloud)](https://www.g2.com/products/agentforce-sales-formerly-salesforce-sales-cloud/reviews)
  - [AM](https://www.g2.com/products/am/reviews)
  - [Apache Kafka](https://www.g2.com/products/apache-kafka/reviews)
  - [AppSheet](https://www.g2.com/products/appsheet/reviews)
  - [Azure Databricks](https://www.g2.com/products/azure-databricks/reviews)
  - [Boomi Data Integration](https://www.g2.com/products/boomi-data-integration/reviews)
  - [CrowdStrike Falcon Endpoint Protection Platform](https://www.g2.com/products/crowdstrike-falcon-endpoint-protection-platform/reviews)
  - [Databricks](https://www.g2.com/products/databricks/reviews)
  - [DATAflow](https://www.g2.com/products/dataflow/reviews)
  - [Data Studio](https://www.g2.com/products/data-studio/reviews)
  - [dbt](https://www.g2.com/products/dbt/reviews)
  - [Gemini Enterprise Agent Platform](https://www.g2.com/products/gemini-enterprise-agent-platform/reviews)
  - [Google Analytics 360](https://www.g2.com/products/google-analytics-360/reviews)
  - [Google Cloud Dataflow](https://www.g2.com/products/google-cloud-dataflow/reviews)
  - [Google Cloud Storage](https://www.g2.com/products/google-cloud-storage/reviews)
  - [Grafana Labs](https://www.g2.com/products/grafana-labs/reviews)
  - [Hightouch](https://www.g2.com/products/hightouch/reviews)
  - [Informatica PowerCenter](https://www.g2.com/products/informatica-powercenter/reviews)
  - [Looker](https://www.g2.com/products/looker/reviews)
  - [Microsoft Fabric](https://www.g2.com/products/microsoft-fabric/reviews)
  - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews)
  - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews)
  - [Microsoft Teams](https://www.g2.com/products/microsoft-teams/reviews)
  - [pandas python](https://www.g2.com/products/pandas-python/reviews)
  - [PostgreSQL](https://www.g2.com/products/postgresql/reviews)
  - [Prefect](https://www.g2.com/products/prefect/reviews)
  - [Purple DS](https://www.g2.com/products/purple-ds/reviews)
  - [PyCharm](https://www.g2.com/products/pycharm/reviews)
  - [Python](https://www.g2.com/products/python/reviews)
  - [Snowflake](https://www.g2.com/products/snowflake/reviews)
  - [Tableau](https://www.g2.com/products/tableau/reviews)
  - [Talend Cloud Data Integration](https://www.g2.com/products/talend-cloud-data-integration/reviews)

## Google Cloud BigQuery Features
**Management**
- Reporting
- Auditing

**Data Management**
- Data Integration
- Data Compression
- Data Quality
- Built-In Data Analytics
- In-Database Machine Learning
- Data Lake Analytics

**Storage**
- Data Model
- Data Types

**Centralized computation**
- Centralized Computation

**Statistical Tool**
- Scripting
- Data Mining
- Algorithms

**Marketing Operations**
- ROI Tracking
- Data Collection
- Customer Insights
- Multi-User Access
- Spend Management
- White Label

**Database**
- Real-Time Data Collection
- Data Distribution
- Data Lake

**Data Transformation**
- Real-Time Analytics
- Data Querying

**Functionality**
- Extraction
- Transformation
- Loading
- Automation
- Scalability

**Integration**
- AI/ ML Integration
- BI Tool Integration
- Data lake Integration

**Availability**
- Auto Sharding
- Auto Recovery
- Data Replication

**Localized computation**
- Localized computation

**Data Analysis**
- Analysis
- Data Interaction

**Integrations**
- Hadoop Integration
- Spark Integration

**Deployment**
- On-Premise
- Cloud

**Performance**
- Integrated Cache

**Decision Making**
- Modeling
- Data Visualizations
- Report Generation
- Data Unification

**Campaign Activity**
- Campaign Insights
- Reports and Dashboards
- Campaign Stickiness
- Multichannel Tracking
- Brand Optimization
- Predictive Analytics

**Platform**
- Machine Scaling
- Data Preparation
- Spark Integration

**Connectivity**
- Hadoop Integration
- Spark Integration
- Multi-Source Analysis
- Data Lake

**Performance **
- Scalability

**Security**
- Role-Based Authorization
- Authentication
- Audit Logs
- Encryption

**Agentic AI - Marketing Analytics**
- Autonomous Task Execution
- Cross-system Integration
- Proactive Assistance

**Processing**
- Cloud Processing
- Workload Processing

**Operations**
- Data Visualization
- Data Workflow
- Governed Discovery
- Embedded Analytics
- Notebooks

**Security**
- Data Governance
- Data Security

**Support**
- Multi-Model
- Operating Systems

**Generative AI**
- AI Text Generation
- AI Text Summarization

**Generative AI**
- AI Text Generation
- AI Text Summarization

**Building Reports**
- Data Transformation
- Data Modeling
- WYSIWYG Report Design
- Integration APIs

**Platform**
- Customization 
- User, Role, and Access Management
- Internationalization
- Sandbox / Test Environments
- Performance and Reliability
- Breadth of Partner Applications

## Top Google Cloud BigQuery Alternatives
  - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (708 reviews)
  - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (1,317 reviews)
  - [Cloudera](https://www.g2.com/products/cloudera/reviews) - 4.1/5.0 (131 reviews)

