# 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,237 ## 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 love the **ease of use** of Google Cloud BigQuery, enjoying its straightforward setup and efficient query processing. (156 reviews) - Users praise the **incredible speed** of Google Cloud BigQuery, enhancing their data processing and analytics efficiency. (143 reviews) - Users appreciate the **fast querying capabilities** of Google Cloud BigQuery, enabling efficient analysis of large datasets effortlessly. (120 reviews) - Users appreciate the **seamless integration** of BigQuery with other Google Cloud tools, enhancing their data analysis experience. (118 reviews) - Users praise the **query efficiency** of Google Cloud BigQuery, highlighting its smooth processing of complex queries effortlessly. (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 the **cost management challenging** with Google Cloud BigQuery, especially due to its expensive pay-per-query pricing. (127 reviews) - Users struggle with **cost management and query optimization** , facing challenges when running large queries unintentionally. (78 reviews) - Users find **cost issues** with BigQuery due to high pricing per TB scanned and complex query management requirements. (63 reviews) - Users struggle with **cost management** due to expensive TB scans and the need for disciplined query optimization. (60 reviews) - Users find the **learning curve challenging** , particularly with partitioning and advanced features, impacting overall user-friendliness. (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. Cloud BigQuery Review **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** May 02, 2025 **What do you like best about Google Cloud BigQuery?** It’s intuitive for the most part and has nice UX features **What do you dislike about Google Cloud BigQuery?** Can be a bit cluttered at times and don’t love the jargon **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Streamlining data that’s otherwise all over the place ### 2. Game changer! **Rating:** 5.0/5.0 stars **Reviewed by:** Rashi K. | Employee Experience Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** February 11, 2025 **What do you like best about Google Cloud BigQuery?** Well it is insanely fast and integrates easily! I appreciate how easy it is to get insights **What do you dislike about Google Cloud BigQuery?** hmmm .. i guess that as users we might not know the cost of running a query given that the cost is determined based on the queries we feed in **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I can run queries on large transaction data in real time to detect frauds and other red-flag cases (I am from fintech space) ### 3. Simple and Effecient **Rating:** 4.5/5.0 stars **Reviewed by:** Abdullah E. | Yield & Revenue Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** April 04, 2025 **What do you like best about Google Cloud BigQuery?** Simplicity of integration with other google related services and software. **What do you dislike about Google Cloud BigQuery?** Not enough customization for my needs, or integration with our current system software. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It provides scalable solutions for my data needs and integrates easily with other google services that my company uses. ### 4. It was pleasant **Rating:** 2.5/5.0 stars **Reviewed by:** Deniz . | Unemployed, Small-Business (50 or fewer emp.) **Reviewed Date:** March 24, 2025 **What do you like best about Google Cloud BigQuery?** It is easy to use and its fast. It handles large datasets very quickly as well. **What do you dislike about Google Cloud BigQuery?** The cost is sometimes unpredictable, and updates sometimes is slow **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery solves big data processing challenges. It supports real time insights and also it integrates well with ML tools. ### 5. Evaluating of Google cloud **Rating:** 4.0/5.0 stars **Reviewed by:** Shyamprasad Reddy G. | Senior System Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2025 **What do you like best about Google Cloud BigQuery?** Uses a distributed architecture and colmunar storage for high speed sql queries. **What do you dislike about Google Cloud BigQuery?** Complex pricing model- understanding storage query and streaming requests requires careful planning. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It solves the analysing big data by offering a server-less, scalable platform with high performance. It handles petabyte scale datasets and eliminates the needs for managing infrastructure, making it easier to team to work on analysis. ### 6. My experience with the server is good and overall I will give the platform 4/5 stars. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2024 **What do you like best about Google Cloud BigQuery?** The best part of the software is how easy it is to to use with all the entries Google cloud eco system especially the design of Google SQL cloud that resemble the traditional PostgreSQL UI. It make integration super easy for me. **What do you dislike about Google Cloud BigQuery?** It's very expensive and their billing system is enormous. I also think they can integrate a basic data visualization into the BigQuery studio to make data engineer job a lot easier. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Cloud Database storage, as a data engineer they have make my job a lot easier, however they could improve their API to connect to other company database. The API system is very complicated to use. I understand this is good for security but there's a way they could utilize some advanced 2FA techniques to make using the API a lot more easier for the users. ### 7. Easy to integrate and scale **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** January 29, 2025 **What do you like best about Google Cloud BigQuery?** There are 2 things which i like most about BigQuery, 1st is the ease of integration and 2nd is how easy it is to scale because of its severless architecture, it also has upcoming machine learning and ai capabilities, i have yet to try those but so far it is been great using it. **What do you dislike about Google Cloud BigQuery?** I have little to dislike about bigquery but some of the things that i dont like are, poor customer service and a steep learning curve. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I am not required to manage big storage or softwares in order to store huge amount of data and analyse and gain insights,it saves my time and resources ### 8. used Google Cloud BigQuery for analyzing large datasets **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** May 02, 2025 **What do you like best about Google Cloud BigQuery?** The setup was minimal, and its serverless architecture meant I didn’t need to manage infrastructure **What do you dislike about Google Cloud BigQuery?** Cost unpredictability: Since it's billed based on data processed, poorly written queries or large scans can become expensive quickly. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery handles petabyte-scale datasets without requiring infrastructure management. This allows me to analyze massive volumes of data quickly and without worrying about provisioning or scaling servers. ### 9. fast,easy, our go-to data warehouse sulotion **Rating:** 5.0/5.0 stars **Reviewed by:** Matan H. | ds team lead, Small-Business (50 or fewer emp.) **Reviewed Date:** October 24, 2024 **What do you like best about Google Cloud BigQuery?** end to end pipeline made easy with bq, we use it on hourly basis and the consule is very nice for quick checks. very easy to implement all wrappers to integrate our pipelines **What do you dislike about Google Cloud BigQuery?** In some things documentation is quite not understandable and not fully coverage everything. do not have "debug" emulator for dev porpuses before prod. so it is always will price in compute. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** democrezating data patterns. fullt managable data warehouse. easy serving data to 3rd party services ### 10. Google cloud bigquery helpful analysis **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Publishing | Mid-Market (51-1000 emp.) **Reviewed Date:** February 02, 2025 **What do you like best about Google Cloud BigQuery?** We can do the analysis of the raw data by connecting different platforms. **What do you dislike about Google Cloud BigQuery?** We need to have some SQL knowledge to run the query to get the desired result. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** With the help of google bigquery we are able to analyze the raw data which is filling the missing links in the data and helping us in taking the data driven decesions. ### 11. BigQuery for storage **Rating:** 4.5/5.0 stars **Reviewed by:** Abhijith Y. | Data engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 05, 2024 **What do you like best about Google Cloud BigQuery?** At my previous role, i liked few thing i liked ,where I leveraged Google BigQuery as the primary storage solution for handling large volumes of data in automotive analytics projects for Jaguar Land Rover. I developed and implemented ETL processes to ingest and store data efficiently in BigQuery, ensuring seamless integration and easy access for analysis. The two main features that help in cost saving are the clustering and partitioning of the data based on data. **What do you dislike about Google Cloud BigQuery?** Most of the features of google bigquery are good and cost effective .The only thing that can be imporoved are integrating bigquery with more systems. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We utilized Google Cloud BigQuery to address several critical challenges in managing and analyzing large volumes of automotive data for Jaguar Land Rover. BigQuery’s scalable architecture solved our scalability issues, allowing us to handle vast datasets efficiently without performance bottlenecks. This significantly improved our query execution times, enabling faster data analysis and timely insights. The integration capabilities of BigQuery simplified our ETL processes, allowing us to seamlessly ingest and transform data from diverse sources. Additionally, BigQuery's cost-effective pay-as-you-go model helped us manage our expenses better by only paying for the resources we used. ### 12. Fast, scalable, but pricey **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** March 07, 2025 **What do you like best about Google Cloud BigQuery?** Incredibly fast, integrates easily with other Google Cloud services, and supports standard SQL, making it easy to use. **What do you dislike about Google Cloud BigQuery?** When I used to use it, it was pay per query pricing can get expensive if not monitored. Overall, it's a powerful and scalable data warehousing solution. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Infrastructure is the biggest plus. It is easy to analyze massive datasets without worrying about performance. It runs complex queries in seconds, plus, it scales automatically, so performance isn’t an issue even with huge data loads. ### 13. Google Cloud BigQuery: Ultimate tool for Big Data Analysis **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2024 **What do you like best about Google Cloud BigQuery?** It's Performance, Scalability, Speed, Serverless Architecture, Cost Efficiency, Integration with Google Cloud, Real time analysis, SQL Support, ML integration. **What do you dislike about Google Cloud BigQuery?** It's Storage Cost, Query limitations, Good for large scale analytics but not good for low-latency transactional applications, Limited support in Transactions, Export limitations, Data load limitations, No support for non-relational data. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** For managing data which is in multiple sources like on-premises, cloud, and third-party services and integrating it for analysis can be complex. So on that time in used it made easy to centralised and analyze that data. This integration saves time and reduces many complexity. ### 14. 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. ### 15. 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 ### 16. 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. ### 17. 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. ### 18. 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. ### 19. 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. ### 20. 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! ### 21. 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. ### 22. 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. ### 23. 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. ### 24. 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. ### 25. 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. ### 26. 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. ### 27. 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. ### 28. 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. ### 29. 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. ### 30. 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. ### 31. 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. ### 32. 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. ### 33. 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. ### 34. 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 ### 35. 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 ### 36. 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 ### 37. 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. ### 38. 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. ### 39. 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 ### 40. 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. ### 41. "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. ### 42. 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. ### 43. 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. ### 44. 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 ### 45. 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. ### 46. 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. ### 47. 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. ### 48. 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. ### 49. 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 ### 50. 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. ## 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§ion=pricing&secure%5Bexpires_at%5D=2026-05-20+00%3A50%3A40+-0500&secure%5Bsession_id%5D=e4217d52-3c0d-46e2-95a1-9bfc95c38526&secure%5Btoken%5D=6a80214cb7ab3c9682bef5fd2e3b848de9298b4107af0338f095cd441e472ed7&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) - [Airbyte](https://www.g2.com/products/airbyte/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) - [Azure SQL Database](https://www.g2.com/products/azure-sql-database/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) - [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](https://www.g2.com/products/google-analytics/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 Run](https://www.g2.com/products/google-cloud-run/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) - [Matillion](https://www.g2.com/products/matillion-2023-06-26/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) - [Pipefy](https://www.g2.com/products/pipefy/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) - [UiPath Automation Hub](https://www.g2.com/products/uipath-automation-hub/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.6/5.0 (687 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (746 reviews) - [Cloudera Data Platform](https://www.g2.com/products/cloudera-cloudera-data-platform/reviews) - 4.1/5.0 (131 reviews)