--- 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-02' 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. A Superb Query Engine with Real-time Answers **Rating:** 4.5/5.0 stars **Reviewed by:** Lynn W. | Advertising Executive , Marketing and Advertising, Small-Business (50 or fewer emp.) **Reviewed Date:** March 28, 2024 **What do you like best about Google Cloud BigQuery?** Its open cloud, flexible, serverless. Reliable for secure big data mining, processing, analysis, sharing and exportation. It gives is customers data when we want, for analysis snd real-time answers that determines our predictions, marketing and advertising. **What do you dislike about Google Cloud BigQuery?** It doesn't work well outside the GCP ecosystem. Its costly compared to most data warehouses in its class. Hope they address. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** This Platform mines customer and market data for us which it processes, questions, analyses and models for our use. It helps us understand, predict and market effectively. ### 2. Fantastic data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Tong Yi C. | Senior Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** May 09, 2024 **What do you like best about Google Cloud BigQuery?** the connections to our G Suite products make it so easy to work with large amounts of data **What do you dislike about Google Cloud BigQuery?** Minimal downsides, making it easier to process and ingest data could be better, having said that it is still very good and easy to use **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Storing large amounts of data safely and cheaply. Allows myself and the team to easily access the data we need ### 3. ETL process efficient engine **Rating:** 5.0/5.0 stars **Reviewed by:** Anushka V. | US IT Recruiter , Mid-Market (51-1000 emp.) **Reviewed Date:** January 27, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud BigQuery is the best process for analysing the data from the server,it is a quickly response and efficient BigQuery engine,it is easy to use data analysis services and there online UI is well organised to manage there complex data and it's run smoothly **What do you dislike about Google Cloud BigQuery?** When i uploaded lot's of complex data for analysing there file so it will bit slow response and there server been laggy but there customer support is always being for help **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google cloud BigQuery is help to analyse multiple complex query to analyse the data from server, speed of queries is boost up then the other server, it is smoothly work when i used data from the server ### 4. Generally works well, difficult to architect for data security. **Rating:** 3.5/5.0 stars **Reviewed by:** Stephen T. | Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** I like how integrated google cloud bigquery is and its general presentation. **What do you dislike about Google Cloud BigQuery?** I don't like that bigquery is so accessible that it often leads developers to fall into low-effort designs and architectures. It has a similar problem to Mongo, it is easy to get into but you can quickly find yourself over your head. I feel that bigquery does not provide good mocking or test infrastrcture **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Distribued analytics and querying for healthcare and cloud managment. ### 5. Easiness using in Google Cloud Bigquery **Rating:** 4.5/5.0 stars **Reviewed by:** Rohit S. | Product Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2023 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery has several features that make it a popular choice for data analysts and data scientists. One of its most attractive qualities is its scalability, allowing users to efficiently analyze massive datasets without worrying about managing infrastructure. Its fast querying capabilities and support for real-time data analysis also make it a powerful tool for handling complex data tasks. **What do you dislike about Google Cloud BigQuery?** While Google Cloud BigQuery offers numerous benefits, some users have found certain limitations or challenges. One common concern is the cost, as complex queries or large datasets can incur significant expenses. Additionally, some users have encountered issues with complex joins and nested queries, which might require additional workarounds or optimizations. Lastly, the learning curve for beginners can be steep, requiring some time to become proficient with its advanced functionalities. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery is designed to solve a variety of data-related challenges, including the need to efficiently process and analyze massive datasets, the demand for real-time data insights, and the necessity for scalable data warehousing solutions. By providing a powerful, serverless, and fully managed analytics platform, BigQuery enables businesses to make data-driven decisions faster, uncover valuable insights, and streamline their data analysis processes. Its ability to handle complex analytics tasks and support real-time data processing helps improve overall data management and decision-making, thereby benefiting businesses and users in gaining a competitive edge. ### 6. Google Cloud BigQuery review **Rating:** 3.5/5.0 stars **Reviewed by:** Kartikay B. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2023 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery is a powerful platform known for its scalability, serverless architecture, SQL support, seamless integration with Google Cloud services, real-time data analysis, robust security, cost flexibility, and data sharing capabilities. It's a valuable tool for data warehousing and complex queries, and Google's managed services ensure reliability. Its extensive ecosystem of tools and connectors enhances its versatility, making it a valuable asset for data-driven organizations. **What do you dislike about Google Cloud BigQuery?** As per me - Complex pricing, steep learning curve, potential query complexity, and challenges related to data import/export. While these issues are notable, they might not apply universally, and it may have made improvements over time. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery solves key data challenges by offering scalability for growing datasets, optimizing query performance, and providing serverless data warehousing. Real-time analytics and cost flexibility are also notable advantages. These solutions translate to faster decision-making, reduced operational overhead, and improved data analysis, contributing to more efficient and data-driven business operations. The extent of these benefits depends on how well an organization leverages BigQuery to address its specific data challenges. ### 7. designed for excellence **Rating:** 4.5/5.0 stars **Reviewed by:** Saurabh S. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2024 **What do you like best about Google Cloud BigQuery?** easy analysis for large quantity of data **What do you dislike about Google Cloud BigQuery?** its nothing that I can think of right now. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** making it easy to analyze petabytes of data and offering SQL like querying ### 8. Google cloud BigQuery, data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Beauti M. | Sales Assistant, Mid-Market (51-1000 emp.) **Reviewed Date:** January 20, 2024 **What do you like best about Google Cloud BigQuery?** Big query is the best process for the ETL tools. And for the web developers it is the best cloud storage whis is hell to easy to use. Whenever we need some problem there costomer support is always for the help. There are many numbers of features in the GCP for the frequent uses for the web developers **What do you dislike about Google Cloud BigQuery?** Many times some users face challanges to dealing with the BigQuery, sometime i run the multiple query then i face the slow process and some lagging problem **What problems is Google Cloud BigQuery solving and how is that benefiting you?** As i already mentioned they help to solve the multiple data entry and ETL process, and i do run the query for the prediction and the data analysis ### 9. BigQuery for big data **Rating:** 5.0/5.0 stars **Reviewed by:** Arpita P. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** Easy to query any data using sql query no matter how the data is structured. **What do you dislike about Google Cloud BigQuery?** Cost might go high if you query sql that queries terrabytes of data that can end up costing alot to the company unless alert is set. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We have a terrabytes of data that is hard to query but having bigquery helped migrate the national water model data in bigquery that is easy to run query on now. ### 10. I have 2 years of experience in Big query. **Rating:** 4.5/5.0 stars **Reviewed by:** Vinish K. | Associate Technical Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** May 08, 2024 **What do you like best about Google Cloud BigQuery?** First thing I like the most is the performance of big query on larg data set. Easy to analyse and query on petabytes of data. **What do you dislike about Google Cloud BigQuery?** User interface and cost comparatively to other vender like aws Athena. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It's help me to analyse the the IOT device data for any issue. Also help me to improve the machine learning models. ### 11. Great Experience **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** Query experience is great, handles huge amounts of data. And I love the public datasets. Such as the public blockchain dataset. I think those are great for fostering an awesome community around big data and building things on top of that data. **What do you dislike about Google Cloud BigQuery?** I think GCP's permissions model in general is the hardest part. I think it's very robust, but it's hard enough that trying to give access to a specific data set takes too much effort and I just provision full access accounts. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It lets me look at public blockchain datasets and use it to get a good idea of how to parse the data for my business needs. ### 12. I can analyze massive datasets in seconds, giving me lightning-fast data insights. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Small-Business (50 or fewer emp.) **Reviewed Date:** April 13, 2024 **What do you like best about Google Cloud BigQuery?** BigQuery lets me crunch through enormous datasets in record time, which is a game-changer for getting insights from all my data, not just a sample. This allows me to make data-driven decisions with confidence. **What do you dislike about Google Cloud BigQuery?** BigQuery offers a powerful SQL interface, but for users unfamiliar with SQL or data warehousing concepts, there can be a steep learning curve. This can slow down initial adoption and require additional training for some team members. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Setting up and managing my own data warehouse infrastructure was complex and expensive. BigQuery's serverless architecture eliminates that burden. I can focus on analyzing data and asking questions, without worrying about managing servers or capacity planning. ### 13. Best in Existing cloud services available querying,evaluation and visuality all at one place. **Rating:** 4.5/5.0 stars **Reviewed by:** Yash K. | Enterprise (> 1000 emp.) **Reviewed Date:** November 07, 2023 **What do you like best about Google Cloud BigQuery?** Its ability to integrate with Kubernetes-supported Kubeflow also fast load and visualization with Looker Studio. The frequency of running multiple queries from multiple buckets helps a lot and saves a lot of time. Data schema and rest can be visualized. Easier query implementation. Also, tutorials are available for external customer support. **What do you dislike about Google Cloud BigQuery?** Wrong evaluation and estimated size shown when running a query. Also querying becomes lot slower when running multiple queries at once on same dataset. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** As in the Data science team, we work for the modeling and loading of the data into the correct form needed for the modeling and also saving the results with correct schema in bigquery. ### 14. Pros and cons of BigQuery **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Education Management | Small-Business (50 or fewer emp.) **Reviewed Date:** April 18, 2024 **What do you like best about Google Cloud BigQuery?** I like that it can handle large datasets easely, no need for infrastructure management. Also I like the pay as you go pricing, and facilitation made for data sharing **What do you dislike about Google Cloud BigQuery?** BigQuery's SQL is a bit different than Standard SQL, as I mentioned in pros pay as you go pricing is great but It makes cost management unpredictable. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** it is cost effective and helps collaboration between team members ### 15. Google Cloud BigQuery Effectiveness **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 18, 2024 **What do you like best about Google Cloud BigQuery?** It's very fast and saves our time querying large datasets. **What do you dislike about Google Cloud BigQuery?** Sometimes it takes more time in importing data **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It is helping in cost management and real time analytics ### 16. Best Roboust tool to organize the data **Rating:** 4.0/5.0 stars **Reviewed by:** Shivam K. | software developer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 15, 2024 **What do you like best about Google Cloud BigQuery?** helping me to sort and find the insights of the data using the readymade tools and also helping to get good insights **What do you dislike about Google Cloud BigQuery?** Documentation is lil bit confusing. and the price is lil high **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It is helping our client data to explore and analyze the seasonality. ### 17. Ease of use **Rating:** 4.5/5.0 stars **Reviewed by:** Praveen C. | Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** Very easy to navigate and ability to perform analytics in one place on different types of data **What do you dislike about Google Cloud BigQuery?** There is none that I dislike about Bigquery **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I work with customers to device solutions that includes Bigquery, and bigquery is at the core of any data solutions. BQ ability to integrate with various data sources and visualization is easy to sell end to end analytics solution for a different use cases. ### 18. GCP Bigquery **Rating:** 4.0/5.0 stars **Reviewed by:** Ashish S. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 06, 2024 **What do you like best about Google Cloud BigQuery?** First thing is we did not worry about infra management in bigquery because GCP will take care of his querying and all. **What do you dislike about Google Cloud BigQuery?** Some time I feel the cost that we are paying for GCP BigQuery is little bit high also sometime I face timeout while running the query..other wise everything is manageable. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** GCP Bigquery solve many things like real time analytics, ML integration, BI integration, ad hoc query, costing optimization etc and benefits like its analysis the data that is essential for fraud detection and monitoring user behavior etc and analyze data without complex setup and many more. ### 19. Wonderful tool for Data analysts **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Music | Small-Business (50 or fewer emp.) **Reviewed Date:** May 13, 2024 **What do you like best about Google Cloud BigQuery?** The ease of use and the table directories. **What do you dislike about Google Cloud BigQuery?** Editing tables could be easier, the cost data visualisation is difficult to wrap my head around as well. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We currently use it to power all of our company dashboards, run granular analytics analyses and deliver ad-hoc data requests to the wider team. ### 20. It is a serverless application **Rating:** 5.0/5.0 stars **Reviewed by:** Swati S. | Process Lead (North America Hiring) , Enterprise (> 1000 emp.) **Reviewed Date:** March 19, 2024 **What do you like best about Google Cloud BigQuery?** It handles infrastructure and allow users to improve analysis of data instead of system administration. It helps in writing simple sql query for analysis of data. It has strong security quality. It has fast query capacity. **What do you dislike about Google Cloud BigQuery?** To store a large amount of data in big query it contribute to current cost. Just like different cloud services, there is a concern of data getting locked in by getting dependent only on big query **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It has strong security quality ### 21. Reliable but expensive database service **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** March 14, 2024 **What do you like best about Google Cloud BigQuery?** It is fast processing, secure service wirh granual access to data. Being a Google service, the database is reliable. Another good thing is its efficient query performance but again this feature is also offered by AWS and Azure. **What do you dislike about Google Cloud BigQuery?** It is not flexible in terms of cost conpared to its counter parts. Some might not feel it as user friendly as Athena offered by AWS. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** As an enterprise which has started to move to cloud from on prem, GCP does provide a lot of useful support and ample amount of learning resources for the engineers on usage of BigQuery. The engineers who are just switching to clouds, for them Google Cloud BigQuery is a good place to start. ### 22. Google Cloud BigQuery is Productive **Rating:** 5.0/5.0 stars **Reviewed by:** Shivam M. | Account Manager, Staffing and Recruiting, Mid-Market (51-1000 emp.) **Reviewed Date:** March 18, 2024 **What do you like best about Google Cloud BigQuery?** The best thing i like about Google Cloud BigQuery it is powerful and it is handling complex data processing. It is easy to use and it integrates smoothly with other cloud services. It supports large data volumes with low cost. Its gives the security assurance with good support system. **What do you dislike about Google Cloud BigQuery?** It is complicated to use for new users. Sometimes It can be time-consuming task. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery allows to analyze large volume of data with speed and efficiency. ### 23. User friendly recommendations for queries. **Rating:** 5.0/5.0 stars **Reviewed by:** ABHISHEK N. | Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** March 22, 2024 **What do you like best about Google Cloud BigQuery?** The feature I liked the most is it's optimizing recommendations such as using table partitions or clustering, to improve query performance. **What do you dislike about Google Cloud BigQuery?** It may become costly for long-term use due to its required high storage which can be costly to maintain. However data retention policies will assists in maintaining large storage cost effectively. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Easy to use for a new user as BigQuerry supports standard SQL, the one can use it without learning a new query language. ### 24. A data warehousing tool for all. **Rating:** 4.5/5.0 stars **Reviewed by:** alex. m. | Administrator , Staffing and Recruiting, Mid-Market (51-1000 emp.) **Reviewed Date:** March 28, 2024 **What do you like best about Google Cloud BigQuery?** The pricing model is based on pay for what you used and it very cost efficient. Terrific with monitoring large amount and dat and analysis purposes. Google cloud Bigquery unleashing data magic in the cloud. **What do you dislike about Google Cloud BigQuery?** It take sometimes to get familiarized with their UI. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google cloud Bigquery is the great way to organize data by creating a number of statements. Google cloud Bigquery is a super fast, require virtual no maintenance. ### 25. BigQuery is still the king of big data aggregation at speed **Rating:** 4.5/5.0 stars **Reviewed by:** Taylor C. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** Queries always run at good speed. Managing tables is simple and copying data between tables or GCP projects is very easy. The availability is always great. **What do you dislike about Google Cloud BigQuery?** The 100 concurrent interactive query limit is non-negotiable according to the official docs and we use it a lot **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Aggregations on large datasets. Similar queries on the same data in other databases can't scale or perform fast enough. ### 26. Cloud Based Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** sat y. | ASM- Global Talent Acquisition , Enterprise (> 1000 emp.) **Reviewed Date:** April 03, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery contains data in cloud data warehouse platform which is easy to use, fast in nature and provide results in no time. **What do you dislike about Google Cloud BigQuery?** Price is on higher side as compare to competitive data warehouse systems. Also support should be more wider. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We don't have to worry about space allocation and speed while using it. It fetches data from cloud very fast and time saving in nature. ### 27. Exceptional Product Experience **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 23, 2023 **What do you like best about Google Cloud BigQuery?** Bigquery is one of the best database management system that I have used, we can add any number of projects to bigquery and store the data here. The best thing that I like is the console through which we can query the projects data. The data gets updated in real time. It has made all our lives very easy. **What do you dislike about Google Cloud BigQuery?** I don't have much that I dislike about it, the only thing that I don't like is that it can be very slow sometimes, it will take a lot of time to query the data or to open the projects. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** The main problem that it solves for me is processing the data quickly and analyzing it very fast. It helps me store large amounts of data and query is very easily. ### 28. Easy straightforward and not expensive **Rating:** 4.5/5.0 stars **Reviewed by:** Gustavo M. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 09, 2024 **What do you like best about Google Cloud BigQuery?** I loved that I could predict the costs of each query, also that is simple and fast. **What do you dislike about Google Cloud BigQuery?** It's less integrated than snowflake for the task I'm currently doing. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I'm not using it anymore, but before it helped me store billions of pre calculated scores and predictions very fast. ### 29. Biquery is good for data analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 14, 2024 **What do you like best about Google Cloud BigQuery?** integration with any cloud, easy data ingestion and retrieval. costing based on the data of the output. User access management. **What do you dislike about Google Cloud BigQuery?** need to write complex queries sometimes. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It helped us in giving visibility to client huge data and processing complex operations on the data while querying. ### 30. Scalability, Pay-as-you-go, Security and Compliance **Rating:** 4.0/5.0 stars **Reviewed by:** Piyush D. | Data Engineer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** November 20, 2023 **What do you like best about Google Cloud BigQuery?** The most important part is Scalability my friend needs a scalable solution for processing and analyzing large datasets, so BigQuery be a good choice. Consider the security features standards that BigQuery adheres to. This is crucial, especially for organizations with strict security requirements. Evaluate the available documentation, community support and the level of customer support provided by Google Cloud. **What do you dislike about Google Cloud BigQuery?** For less frequently used tables or queries there might be a slight delay in processing as the system warms up to handle the request. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Problem is Handling Large Datasets Efficiently BigQuery is built to handle massive datasets efficiently. It uses a distributed architecture, enabling it to process and analyze terabytes or even petabytes of data in a scalable manner. This is particularly beneficial for data analysts dealing with vast amounts of information. ### 31. google cloud as basis for the data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Fabian H. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 23, 2024 **What do you like best about Google Cloud BigQuery?** a simple structure of data tables is possible and thus the simplest dwh structures can be set up in a short time. this means that queries can be made in a short time and the first analyses can be carried out. **What do you dislike about Google Cloud BigQuery?** costs and the necessary consumption are clear and transparent. Unfortunately, it is not possible to clearly identify the sources of consumption. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google BigQuery provides the basis for queries to our Google DWH. It also links third-party systems and delivers data to third-party systems. ### 32. Scalable solution for analysis of big data **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Transportation/Trucking/Railroad | Mid-Market (51-1000 emp.) **Reviewed Date:** May 12, 2024 **What do you like best about Google Cloud BigQuery?** Easily adaptable for folks familiar with SQL queries.Provides lots of built in features for data engineering and data science capabilities.Can easily integrate with other BI tools as well. **What do you dislike about Google Cloud BigQuery?** Slightly lesser options available for migration capabilities when compared to other cloud solutions. Cost could be another factor,but as long as your queries are optimised you are good to go. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Has options do real time analytics and can easily be scaled up. Can handle all types of data - structured and semi structured data. ### 33. Data Warehouse (Serverless) **Rating:** 4.5/5.0 stars **Reviewed by:** Shikha S. | Technical recruiter, Mid-Market (51-1000 emp.) **Reviewed Date:** February 01, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud BigQuery suppory IAM for acess control and it supports various format of data that make the transformation and movement of date quite easy. **What do you dislike about Google Cloud BigQuery?** For the large project or multiple projects one have to pay a large amount of money due to which financial burden increases so pricing show be minimised for the large workloads. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** With the help of this i can source the data from different departments and stores in a single repository. Also it can be used for comparison the data and to analyse the historical data and charts as well. ### 34. Scalable services, Serverless and highly cost effective **Rating:** 4.5/5.0 stars **Reviewed by:** Pranesh G. | Back End Developer, Enterprise (> 1000 emp.) **Reviewed Date:** November 07, 2023 **What do you like best about Google Cloud BigQuery?** >> Google cloud BigQuery is highly cost effective and can use for scalable services. >> This is Easy to Use and Easy for implementation of large scaled services. >> It allows to simplify data integration. >> It is customer friendly. >> Well organized user dashboard. **What do you dislike about Google Cloud BigQuery?** >> Managing Access controls for specially large organizations which has several users and datasets can be complex. >> It may be difficult for users who are not familiar with SQL or distributed data processing concepts. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** >> Google cloud BigQuery are easy to use and easy to implement it. It provides scalability benifits so user experience is better with it in applications of data processing. >> Also query execution performance is good and can be used while working with large datasets. >> Google Cloud BigQuery offers cost efficiency for it's serverless architecture. ### 35. Wonderful **Rating:** 5.0/5.0 stars **Reviewed by:** Bhanu c. | Bench Sales Recruiter, Enterprise (> 1000 emp.) **Reviewed Date:** July 01, 2024 **What do you like best about Google Cloud BigQuery?** Huge Data Analysis, Data Recovery, And Data Modulation. **What do you dislike about Google Cloud BigQuery?** Nothing is to dilike about Google Cloud BigQuery **What problems is Google Cloud BigQuery solving and how is that benefiting you?** No problems faced ### 36. I feel it's extremely user friendly for all levels **Rating:** 4.0/5.0 stars **Reviewed by:** Sara C. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** I like the user experience. I can give the platform to any new user and they can use it seemlessly without knowing much about the platform **What do you dislike about Google Cloud BigQuery?** Sometimes the data we need is more complicated than can be documented **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It helps us document analytics at the stadium and helps us use the information to target stuff on the website ### 37. Big Query enables migration to GCP at a faster pace **Rating:** 4.5/5.0 stars **Reviewed by:** Kiranmayee J. | Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** Big Query has the auto code review feature which makes it easier for new learners to code compared to traditional methods of SQL **What do you dislike about Google Cloud BigQuery?** I think more API's to interace with other LLM's will help **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We are in the midst of migration to GCP from Terradata and Hadoop, so Big Query helps streamline the large sets of data. ### 38. Big Query for your data needs **Rating:** 4.5/5.0 stars **Reviewed by:** kalpesh p. | Solutions Architect, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** The flexibility with storage and ability to use it across a variety of use cases across the enterprize value chain **What do you dislike about Google Cloud BigQuery?** Tends to get get pricier with the amount of use and limited ways to optimize cost **What problems is Google Cloud BigQuery solving and how is that benefiting you?** this services give my organization the ability to store and process large amounts of data and make sense out of it. ### 39. Got what you need. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Consulting | Mid-Market (51-1000 emp.) **Reviewed Date:** July 04, 2024 **What do you like best about Google Cloud BigQuery?** Simplicity at its finest. Ability to implement code at blazing speeds and the quick response from support is great for someone like me that uses BigQuery daily. Easy to integrate with the rest of GCP. **What do you dislike about Google Cloud BigQuery?** I would like better integration of AI into the coding ecosystem. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Data analytics solutions for large scale companies. ### 40. Working as strategic analyst **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek G. | Business Strategy Analyst | Enterprise Solutions, Enterprise (> 1000 emp.) **Reviewed Date:** May 29, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud bigquery helps me do my work efficiently and effectively **What do you dislike about Google Cloud BigQuery?** Difficult to work with for nubes. Otherwise good. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** During my work i need to do analysis on various data for my company. ### 41. Ease in implementing with Google cloud platform **Rating:** 5.0/5.0 stars **Reviewed by:** Varnika P. | Talent Acquisition Specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** March 22, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud big queries allows number of features apart from it's primarily functionality like it helps in regulating the data cycle by retention and deletion for cost optimisation **What do you dislike about Google Cloud BigQuery?** Execution of querry may include very attentive planning and it can lead to extra data transfer cost while transferring data between different regions and cloud. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** The data integration process is very seemless. It provides good secure and protection ### 42. Excellent for large scale aggregations **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Mid-Market (51-1000 emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** I like that the sql syntax is familiar, but allows some more advanced schemas, with things like records and repeated fields. I also like that that I don't have to think too much about indexing. **What do you dislike about Google Cloud BigQuery?** Some of the performance constraints are non-obvious and require some careful schema design. More convenient ways to handle deduplication of large datasets, given the append-only nature of BigQuery, would also be nice. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery is primarily used as the backend for our Looker reports. The ease of integration, and ability to handle our large, multitenant dataset is the biggest advantage. ### 43. Performance is awesome **Rating:** 5.0/5.0 stars **Reviewed by:** Minesh P. | Infrastructure Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** It does direct connection from BQ to our Qlik Analytics tool. It helps with performance of the data. Also the data stored and the time it takes to delivered is great. **What do you dislike about Google Cloud BigQuery?** So far I have not run into any issues but the price to use BQ is high. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It is fast to deliver data when Filter. ### 44. Was able to get to move a lot of date from SAP to Bigquery using cortex framework **Rating:** 3.5/5.0 stars **Reviewed by:** sai P. | Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** It costs very little to store huye ammount of data. **What do you dislike about Google Cloud BigQuery?** It is really hard to move data from SAP sources like ECC even when using cortex. No direct native connector for moving data from SAP HANA to bigquery **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It is able to store alot of data at a fraction of the cost of other SAP systems. ### 45. A good experience with Google Cloud BigQuery **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Small-Business (50 or fewer emp.) **Reviewed Date:** May 15, 2024 **What do you like best about Google Cloud BigQuery?** 1. I can easily store the data & perform analysis on it. 2.Overall very easy to use. 3. For SQL users, it is very convenient to work in BigQuery. 4. Serverless part is just amazing. **What do you dislike about Google Cloud BigQuery?** 1. Sometimes it is costly when processing a large volume of data **What problems is Google Cloud BigQuery solving and how is that benefiting you?** By using google cloud bigQuery I can store my data and run analysis on it and get valuable insights which help me to take my business decisiosns more effectively. ### 46. Best Product on Earth **Rating:** 5.0/5.0 stars **Reviewed by:** Raymond K. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** BQ is the best data/process investigation tool on the market. Also, because of partitioning it's extremely cheap. We put all changesets to our DB or all intra-service communication via pubsub into BQ datasets that we can later query if we want to find trends/problems/auditing. **What do you dislike about Google Cloud BigQuery?** I have not found anything I dislike yet! **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Inevestigation into Data trends. ### 47. Great product but not yet perfect **Rating:** 4.5/5.0 stars **Reviewed by:** Yahia M. | Data Scientist, Small-Business (50 or fewer emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** It makes managing and analysing big datasets much easier **What do you dislike about Google Cloud BigQuery?** Sometimes had performance issues while running the query **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Normally dealing with big data you had to watch how you use machine learning and predictive analysis in order to get good performance while with big query you don't that as it provides you these services with constant performance ### 48. BigQuery is fast, and can optimize data tables that we previously had stored on different servers. **Rating:** 5.0/5.0 stars **Reviewed by:** Jake B. | Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** It's speed, user interface, and that it shows whether or not a query will successfully run. I also like the data preview of the table without having the query the table. **What do you dislike about Google Cloud BigQuery?** In my experience, I have not experienced downsides with BigQuery so far. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Querying data in one location that was previously stored across multiple servers. ### 49. Software developer for cloud saas for an MNC **Rating:** 4.5/5.0 stars **Reviewed by:** Swati G. | Senior Member Of Technical Staff, Enterprise (> 1000 emp.) **Reviewed Date:** May 28, 2024 **What do you like best about Google Cloud BigQuery?** It's a great way to query and manage data efficiently **What do you dislike about Google Cloud BigQuery?** It's not highly renowned now and there are others in the market **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Helps me manage and query data effectively and efficiently ### 50. My experience with BigQuery **Rating:** 5.0/5.0 stars **Reviewed by:** Vivek K. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** We use BigQuery in our day to day life to store the HIPPA data for our project and I have had a good in analytics and processing **What do you dislike about Google Cloud BigQuery?** Till now I haven't seen any issue. Good work **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We have a large amount of data coming in every day and BigQuery is handling the data pretty well ## 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=8§ion=pricing&secure%5Bexpires_at%5D=2026-07-06+04%3A51%3A25+-0500&secure%5Bsession_id%5D=fc39c23f-04fd-4fe0-8b3c-579c31e48995&secure%5Btoken%5D=2bbc01cd7b03f89c8db6ae780facbbad54ca041d1f9ff3b1e8631844c35cd507&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,284 reviews) - [Cloudera](https://www.g2.com/products/cloudera/reviews) - 4.1/5.0 (131 reviews)