# 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,227 ## 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** of Google Cloud BigQuery, enabling fast data analysis with minimal management effort. (129 reviews) - Users appreciate the **high speed** of BigQuery, enjoying quick query processing and seamless integration with Google Cloud services. (126 reviews) - Users appreciate the **easy integration with Google Cloud services** , enhancing workflow and analytics across platforms. (110 reviews) - Users value the **fast querying** capabilities of Google Cloud BigQuery, enabling seamless analysis of large datasets effortlessly. (105 reviews) - Users appreciate the **query efficiency** of BigQuery, effortlessly processing complex queries on massive datasets with speed. (100 reviews) - Users appreciate the **scalability** of Google Cloud BigQuery, efficiently handling large datasets and providing fast performance. (99 reviews) - Easy Integrations (91 reviews) - Large Datasets (87 reviews) - Efficiency Improvement (75 reviews) - Performance (74 reviews) **What users dislike:** - Users find BigQuery **expensive** , especially when executing large or inefficient queries, leading to quickly escalating costs. (112 reviews) - Users experience **query issues** in BigQuery, often struggling with cost management and complex SQL troubleshooting. (65 reviews) - Users face **unpredictable pricing** with Google Cloud BigQuery, leading to high bills and the need for strict budget controls. (52 reviews) - Users express concerns about **cost issues** due to rapid bill spikes and the need for strict budget management. (51 reviews) - Users find the **steep learning curve** for Google Cloud BigQuery challenging, especially for beginners and advanced features. (49 reviews) - Expensive Queries (47 reviews) - Cost Estimation (40 reviews) - Slow Performance (34 reviews) - Slow Queries (27 reviews) - UX Improvement (24 reviews) ## Google Cloud BigQuery Reviews ### 1. Huge Fan of BigQuery and Google Cloud!! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2024 **What do you like best about Google Cloud BigQuery?** Coming from Oracle data warehouse, migrating to BigQuery has shifted my perspective and how I go about design/development now. I no longer think too heavily about performance and tuning and all the things our team had to take into consideration when developing data solutions. Processes that took hours, maybe days now take minutes. Allows us to focus on the data instead of roadblocks. Also, love the ease of small enhancements that make coding less cumbersome, for example, being able to leave a column at the end of a select or using select all columns except a few. TOTAL GAMECHANGER!! **What do you dislike about Google Cloud BigQuery?** Would love for the UI to able to store/pin results in same tab/window, instead of opening multiple tabs. For this, I love DBeaver but would love to just stay in the UI for all coding work. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** faster analytics faster blending of multiple datasets for reporting and visualization tools ### 2. Seamless Data Warehousing with a Hassle-Free Experience! **Rating:** 4.0/5.0 stars **Reviewed by:** Aashi A. | Relationship Manager NRI, Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2024 **What do you like best about Google Cloud BigQuery?** The inherent strength of BigQuery lies in its exceptional structure. My firsthand experience with Cloud Functions and Cloud Storage has been nothing short of delightful. The GCP CLI outshines competitors on alternative cloud platforms, offering a superior level of ease and implementation which i like the most . Customer support peovided by them is remarkable. **What do you dislike about Google Cloud BigQuery?** Some users have faced challenges when dealing with intricate joins and nested queries in BigQuery, necessitating the exploration of additional workarounds or optimizations. Additionally, there's a noticeable slowdown in querying performance when running multiple queries simultaneously this is the one i personally observe as a cons of this software , overall i must say there are no. of features that one must give it a try to enjoy seamless experience. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery solves the challenges of traditional data warehouses by providing a scalable and cost-efficient analytics platform. It offers real-time analytics, flexibility with schema, and ease of use, addressing issues like complex queries and concurrent query performance. This will help me to improved efficiency, reduced infrastructure management overhead, and timely insights for data-driven decision-making, ultimately benefiting you with a streamlined and powerful analytics experience ### 3. Google Cloud BigQuery Review **Rating:** 5.0/5.0 stars **Reviewed by:** Sourav D. | Mentor, Small-Business (50 or fewer emp.) **Reviewed Date:** November 08, 2023 **What do you like best about Google Cloud BigQuery?** BigQuery is one of the best tools for the ETL process. The best thing about Bigquery is the option to create ML models with just SQL-like syntax. Automatically optimises queries to fetch data quickly and the speed is one of the best things about BigQuery. **What do you dislike about Google Cloud BigQuery?** The learning curve for the tool can be a bit daunting. But, If you are good with SQL it is not that difficult. Also uploading a database in Excel sheet format can be very slow and also prone to errors **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery is mostly used for the ETL process and also for Predictive Analysis. The speed of querying has made a significant difference in the ETL process. managing the cost is also quite easy in Google Cloud for BigQuery. Another key factor is public data sets which are already available can be used with our databases for queries, ### 4. The name says it all. Have a big table of data? BigQuery can help you query the hell out of it. **Rating:** 5.0/5.0 stars **Reviewed by:** Patrick H. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** Fast, reliable, and serverless, BigQuery is the premeer data warehouse analytics tool, period. **What do you dislike about Google Cloud BigQuery?** Now much help to you if you're SQL skills are lacking. Also, the visibility into what it's doing behind the scenes is very limited, so if you want to find out why a query is slow or what you could do to improve it, there's not much help for you. Feels to me like something a little AI might help with. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It does it's job. When you have lots and lots of tabular data, BigQuery can help you get all that dirt out of the way so you can find the gold inside. ### 5. USED BIGQUERY, GCP ION MANY MACHINE LEARNING PROJECTS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Manufacturing | Enterprise (> 1000 emp.) **Reviewed Date:** September 09, 2024 **What do you like best about Google Cloud BigQuery?** handling large-scale datasets with fast, SQL-based queries, making it ideal for data preprocessing and feature extraction in machine learning. Its integration with tools like Vertex AI simplifies model deployment and training. **What do you dislike about Google Cloud BigQuery?** BigQuery can become costly for large, complex queries and lacks native support for certain advanced ML algorithms. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery solves the challenge of processing massive datasets quickly, benefiting by enabling efficient data analysis and ML model training at scale. ### 6. Google Cloud BigQuery **Rating:** 5.0/5.0 stars **Reviewed by:** Dinesh Y. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 05, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud bigquery is reliable and efficient to complete the project without any delay. It is easy to use and there UI is smothly when we are using the online editor. Automatic fetch the query from tha database and inhance the speed and manage the warehouse. implemation and integration is smoth and the customer support is up to the mark. **What do you dislike about Google Cloud BigQuery?** When i am run the multiple query on the Google Cloud big query online editor then it become slow then the othew databse also lagging **What problems is Google Cloud BigQuery solving and how is that benefiting you?** i do run the qurey to analyse and manage and predication the data from the cloud, it is easy to use and manage the large amount of data and complex data from the database. it save lot of time by runing the various query at a same time in different different project simulteniously. ### 7. Good experience with GCP Big Query **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** September 02, 2024 **What do you like best about Google Cloud BigQuery?** Google cloud BigQuery is a very simple language that helps getting the data in No Time. Easy to pulling in codes to fetch and save data in databases. Also easy to integrate with visualization tools likes tableau. **What do you dislike about Google Cloud BigQuery?** Nothing that i can think off. It is smooth and easy to setup and use platform. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Data management and storing for multiple databases. Easy to access data in right format for faster analysis and visualization. ### 8. Best warehousing solution which might rule the future **Rating:** 5.0/5.0 stars **Reviewed by:** Sumanth S. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 08, 2023 **What do you like best about Google Cloud BigQuery?** Mainly its user friendly, pay per use, and easy to work on, having most of the advanced options to ingest the data like using API, or using console directly and even using transfer appliance. **What do you dislike about Google Cloud BigQuery?** In some cases its speed will decrease when there is the need of accessing data which is outside the gcp and it might be costly for complex and dataset **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I will be working on a huge migration project, So here we transferring data from oracle to GCP so using it every day ### 9. Data Warehousing without the need to worry about the back-end! **Rating:** 4.5/5.0 stars **Reviewed by:** Deborishi G. | Business Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** December 22, 2023 **What do you like best about Google Cloud BigQuery?** I am a Pythonista and I love the seamless ability to use the RESTful API available to query the tables that we create. Hence it is easily integratable and it is of ease to use it. Whenever I would need to run a query, good ol' SQL does the trick for us - implementation is a breeze. I store mainly analytics data and use quite frequently to run our reports. It works well with Google Looker for the BI needs. **What do you dislike about Google Cloud BigQuery?** Sometimes when I run multiple queries - having too many tabs and juggling between them becomes a real chore. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I do run queries that help us with predictive analytics - as it involves SQL, it is very easy to implement. ### 10. Best platform to manage complex datasets. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Staffing and Recruiting | Enterprise (> 1000 emp.) **Reviewed Date:** March 19, 2024 **What do you like best about Google Cloud BigQuery?** After using Google Cloud BigQuery all the datasets across all the databases behave like singular storage and gather everything at one single place which is the best thing i like the best in it, it provide a good storage at a minimal price which is the best option to attract the customer. Somehow i find it easy to use as i am technical person and i must say customer service is very good they give immediate solution to your query. **What do you dislike about Google Cloud BigQuery?** If anyone want to upload a file suppose that was a excel it may take a longer time than epected, also to find the data in a Gogle Cloud BigQuery is hard for someone who is not a frequesnt user. These are the basic cons. that i observe as a user **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It offers automatic scaling and eliminate the infrastructure hassel which is a most biggest problem for any business and it is benefiting us by providing meaning ful insights which helps in descision making and create a strategic planning technique for that specific project which help a business to grow constantly. ### 11. Very ease to pick up and learn. Easy connections to Google Cloud function. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** July 03, 2024 **What do you like best about Google Cloud BigQuery?** Able to execute complex SQL queries with ease. **What do you dislike about Google Cloud BigQuery?** Sometimes query runs for high duration of time though query seems easy to look at. Also If i am not wrong it doesn't have traditional indexing. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Handling large complex SQL queries. Acts as a data warehouse. I can look at all tables and views. I belive this is scalable as well. ### 12. very recomended for use google cloud bigquery **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammad I. | Small-Business (50 or fewer emp.) **Reviewed Date:** May 14, 2024 **What do you like best about Google Cloud BigQuery?** sql language, BigQuery is capable of processing very large datasets quickly **What do you dislike about Google Cloud BigQuery?** Query performance can sometimes be inconsistent, especially during peak usage times. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery uses standard SQL, which makes it easy to use for data analysts already familiar with SQL, without needing to learn a new programming language. ### 13. A powerful tool for the working when comes to data analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Manoj C. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 08, 2024 **What do you like best about Google Cloud BigQuery?** A strong tool when it comes to form data warehousing by data analytics and easy to understand **What do you dislike about Google Cloud BigQuery?** It is an add on tool to our organization for model building with reduced preprocessing **What problems is Google Cloud BigQuery solving and how is that benefiting you?** For our admin dashbord we are facing house vacancy ads from various locations for that need to find out where the ads are triggering frequently.Also load the data and analyze it. ### 14. sentiment analysis of Twitts **Rating:** 4.0/5.0 stars **Reviewed by:** Amir Ali S. | Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 07, 2024 **What do you like best about Google Cloud BigQuery?** It was easy to learn. I used it to save extracted data. And then queried them to train a model **What do you dislike about Google Cloud BigQuery?** In general nothing to dislike. Any computer scientist can easily learn and use it **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It was a project in the university ### 15. Data Engineer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 14, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery is its versatility. It can consistently deal with monstrous datasets, empowering quick and effective questioning, even on petabyte-scale information. Furthermore, its joining with other Google Cloud integration and instruments makes it helpful for building hearty information pipelines and performing complex analytics task. **What do you dislike about Google Cloud BigQuery?** Google Cloud BigQuery incorporate its valuing structure, which can be perplexing and possibly costly for specific responsibilities, particularly on the off chance that not improved productively. Furthermore, a few clients find the expectation to learn and adapt steep while first beginning with BigQuery, especially in grasping its SQL dialect and improving queries for execution. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** As I am data Engineer, So I am validating the ETL tools, Data integration and Business intelligence, Marketing analytics and other kind of tools available in the market. Google Cloud BigQuery tends to different difficulties in data management and analytics , fundamentally by giving a versatile, serverless, and completely oversaw information distribution warehouse solution. With BigQuery, associations can consistently ingest, process, and examine organized and semi-organized information progressively, prompting quicker experiences and better navigation. ### 16. Google Cloud Bigquery **Rating:** 5.0/5.0 stars **Reviewed by:** Sahar S. | Partner Support Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 16, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery stands out for its remarkable speed and scalability. It's like having a supercharged engine for data analysis, allowing you to query massive datasets in seconds, which is a game-changer for businesses dealing with large volumes of data. **What do you dislike about Google Cloud BigQuery?** One thing that can be a bit frustrating about Google Cloud BigQuery is its pricing structure. While it offers great performance and scalability, the costs can add up, especially for larger datasets and complex queries **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery is a lifesaver for big data analytics, solving numerous challenges and bringing immense benefits to my work. Firstly, it handles massive datasets with lightning speed, allowing me to query and analyze huge volumes of data in a fraction of the time it would take with traditional databases ### 17. Low Cost tool **Rating:** 4.0/5.0 stars **Reviewed by:** Mohit K. | Delivery Manager - Talent Acquisition, Mid-Market (51-1000 emp.) **Reviewed Date:** March 13, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery is easy to use and implement. It allows to handle huge data at a very low cost. It gives the security assurance with good support on the user end. **What do you dislike about Google Cloud BigQuery?** BigQuery is little complecated to use for the new users. Sometimes it can be a lenthy process as well. If we are using BigQuery for complex queires it may not be that much effective. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery is cost effective tool that allows storing maximun data at lower cost, so it's solving the budget issues. Before BigQuery I was facing storage issue but it gives me that solution where i am able to store more data as per my requirements. ### 18. Bigquery warehouse over others **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.) **Reviewed Date:** July 08, 2024 **What do you like best about Google Cloud BigQuery?** The ability to create tables from either sql based or nosql based, ability to have nested columns which can be alot of helpful in terms of ingesting the data.Ability to run ML models directly in bigquery **What do you dislike about Google Cloud BigQuery?** Sometimes the flattening of tables may require extra work which can be fixed,Syntaxes are broken sometime and same query requires re run, **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Data Warehousing and then creating the BI Reports on top of that,that is something Bigquery has helped me. The fact I can store data in any format the flexibility is something that helps alot ### 19. Robust tool to get the things done when it come to Data Analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Devendra T. | Small-Business (50 or fewer emp.) **Reviewed Date:** March 11, 2024 **What do you like best about Google Cloud BigQuery?** It is a good tool to help when it comes to the data analytics form the data warehousing and able to get insights easily **What do you dislike about Google Cloud BigQuery?** I liked it as it is helping my organization to build models with less headache of preprocessing. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** So for our organization we get ads of house vacacny form different locations for our admin dashboard to locate from where the ads are posting frequently. we load data here and analyze it. ### 20. Generating Insights: Cloud BigQuery **Rating:** 4.5/5.0 stars **Reviewed by:** Abhiraj B. | Cultural Co-Head , Small-Business (50 or fewer emp.) **Reviewed Date:** February 09, 2024 **What do you like best about Google Cloud BigQuery?** The user interface is seamless, it also provides options to integrate data from various sources. Apart from that it can also train some ML models via queries which is also a plus. **What do you dislike about Google Cloud BigQuery?** Sometimes the amout of features are overwhelming but with proper guidance it can be managed. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google Cloud BigQuery provides a seamless analytical tool for extracting insights form data. It supports procesing of Big Data along with normal database along with predictive modelling. You can aditionally apply manual filters on the queried data to extract further trends. ### 21. Big query review **Rating:** 4.5/5.0 stars **Reviewed by:** Pawan D. | IT Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** July 08, 2024 **What do you like best about Google Cloud BigQuery?** All the functions and information are helpful for users. **What do you dislike about Google Cloud BigQuery?** At this time.i didn't find any disadvantage of Big query. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Google BigQuery helps users analyze data by enabling them to list, manage, and update projects, datasets, jobs, and tables. It also allows users to delete and manage any data they input. ### 22. Easy to use and alter data with better interface **Rating:** 4.0/5.0 stars **Reviewed by:** Aksh P. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 18, 2024 **What do you like best about Google Cloud BigQuery?** The interface for query and it requires less effort to learn it **What do you dislike about Google Cloud BigQuery?** Would appreciate if it has more tutorials on how the incoming datatype is changed into other automatically as it creates mess sometimes **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Its solving the scalability issue for me with affordable pricing ### 23. Google cloud BigQuery **Rating:** 5.0/5.0 stars **Reviewed by:** Sahil W. | Sr Developer, Human Resources, Mid-Market (51-1000 emp.) **Reviewed Date:** January 27, 2024 **What do you like best about Google Cloud BigQuery?** This is the process of ETL warehousing to manage the database, it is easy to use software and there UI is smoothly when we use there online BigQuery editor, automatically fetch the query to get the efficacy data and increase there speed and performance to analyse the data and manage there database. Implementation and integration was smooth and the customer support was also upto the mark. **What do you dislike about Google Cloud BigQuery?** When i run the multiple query on the online editor it becomes slow then the other SQL server also starts lagging. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I do run the query that help us to prediction and analyse involved as a SQL server and it is easy to use to manage large and complex database and this software help use to analyse the data from database ### 24. About Google Cloud BigQuery **Rating:** 5.0/5.0 stars **Reviewed by:** Ankit P. | Talent Acquisition Analyst - Global Strategic Resourcing, Small-Business (50 or fewer emp.) **Reviewed Date:** March 26, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery is managed datawarehouse, it is PAAS(platform as a service) tat support SQL. The best thing about it has built in machine learning and business intelligence. it is useful or suitable for big set of data. it is ease to use as it support SQL query, ease to set up and use, reduce data size and ease to integrate with other platform. it is frequently used for provides fast query performance. **What do you dislike about Google Cloud BigQuery?** streaming data in google cloud bigquery is expensive. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** it is use friendly becasue of it use SQL query and it can handle large amount of data. ### 25. Using BigQuery in the Classroom **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** BigQuery has an expansive set of resources that I can provide to my students to help them understand how to best utilize the capabilities of the tool **What do you dislike about Google Cloud BigQuery?** User interface changes when the window size is modified, which is fine except it hides several critical tools on smaller screens. Students are often working with lower-level technology and/or are working side-by-side with digital resources, so this makes it difficult for them to learn. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery helps me demonstrate the scale of data to students who are just starting their technology journey. It's often very difficult for them to imagine how much data is being collected in our IT systems and BigQuery gives them the opportunity to work with large datasets and learn how to efficiently answer questions about the data. ### 26. Reviewing one of the best analytic platform **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 01, 2024 **What do you like best about Google Cloud BigQuery?** Using SQL for querying means it's accessible to a wide range of users, from data analysts to data scientists. This simplicity in querying makes it easier to derive insights quickly. **What do you dislike about Google Cloud BigQuery?** While the pay-as-you-go model can be cost-effective, running complex queries on large datasets can accumulate costs, especially if not optimized. Users need to monitor and optimize query efficiency to manage expenses. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It helps in seamless integration with other Google Cloud services and third-party tools makes it versatile for building comprehensive data pipelines and integrating with existing workflows. ### 27. My review on ETL process **Rating:** 5.0/5.0 stars **Reviewed by:** Chandan D. | Sr. Information Technology Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 12, 2024 **What do you like best about Google Cloud BigQuery?** Data storage and pre process, Google cloud BigQuery is a platform which is reliable and storage the serverless database for storage of data and process the data, It is managed the multiple query at the same time and complex data. They are many feature in the GCP to use frequently for the web developers **What do you dislike about Google Cloud BigQuery?** I didn't find any cons about the Google cloud BigQuery expect the UI. Whenever i do run multiple query from the different database it will be lagging **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We use the Google cloud BigQuery to process the huge customer and data for the analysis. It save lot of time by running the verious query at the same time from different different project simultaneously and efficiently ### 28. Pretty good overall **Rating:** 5.0/5.0 stars **Reviewed by:** Kenny S. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 06, 2024 **What do you like best about Google Cloud BigQuery?** Very easy to use and to implement it is quite good **What do you dislike about Google Cloud BigQuery?** the customer support I found that they were not in detail. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** To help resolve analytical bid data findings. ### 29. Things about Google Cloud BigQuery **Rating:** 4.5/5.0 stars **Reviewed by:** Suhail A. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 20, 2024 **What do you like best about Google Cloud BigQuery?** First things which i like in Google Cloud BigQuery is it's easy to use also the support is very good. If don't need to be offline for any upgrades. Very good interface anyone can use. You can easily implement Google Cloud BigQuery. And one thing which I literally love it's speed like speed is very fast. **What do you dislike about Google Cloud BigQuery?** Pricing structure for some organisations must be an issue. Nothing dislike just one thing only **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Very easy to use and it easy to build ETL. Google Cloud BigQuery allows us to analyze a lot data. Also helps in to solve scability. ### 30. My experience to Google cloud bigquery **Rating:** 5.0/5.0 stars **Reviewed by:** Harish K. | Senior Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** March 19, 2024 **What do you like best about Google Cloud BigQuery?** I really like Google cloud big query because it's superfast and handles huge amount of data. Plus it's cost effective which is great for our budget. And integration with other cloud services is very easy. The real time data processing feature is what I like the most. **What do you dislike about Google Cloud BigQuery?** For New comers the learning curve might be a bit steep and if you're not careful with monitoring usage unexpected costs can be pop-up. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It solve the problem of processing large datasets which can be time consuming using traditional method. This save time and resources, enhanced data driver decisions making. ### 31. Ultimate Time Saver in budget **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 22, 2024 **What do you like best about Google Cloud BigQuery?** Few things which i really appreciate of Cloud Bigquery 1. Helps in getting query results in superfast manner even when there is a huge chunk of Data 2. No need to build/rebuild index every time new data is added and no hassle of maintaining infrastructure 3. Comesin handy for building amazing Real-Time time Front End Analytics page **What do you dislike about Google Cloud BigQuery?** Sometimes integrating it with Microsoft tools, such as creating PBI sheet can cause a issue or I say, some limited Integration Capabilities If a user is stuck, there is no query recommendation which few new-age tools have started to provide now **What problems is Google Cloud BigQuery solving and how is that benefiting you?** The major problem it solves for us as compared to other Warehouse solutions is building Front End Consumer facing Real time analytics tools without having to worry about size of Data, it's indexing and maintainence. ### 32. Excellent Response Time - No matter Data Size **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** March 25, 2024 **What do you like best about Google Cloud BigQuery?** We have a Analytics site built by our Dev team which is now works excellent when it comes to response time even with complex Queries. It really helps my team to do Predictive Analytics as it involves lot of complex queries to be executed. Even when a big junk of data daily added we always now getting Rela Time Analytics in easy to use manner and faster response **What do you dislike about Google Cloud BigQuery?** We have integrated our Front End Analytics built on Cloud BigQuery to PowerBi. here we face not much but a bit of a limitation when tried to connect thus you can say it has a bit of limited Integration capabilities **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It is providing capabilities of Building Real Time Analytics on Big Data. There is no need to wait everytime for indexing and maintainence ### 33. Underated DW in the market **Rating:** 4.5/5.0 stars **Reviewed by:** Mario G. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** November 17, 2023 **What do you like best about Google Cloud BigQuery?** Performance is great, as well as easy way to access with native tables and API. It can be incredibly cheap if you use it well, specially considering partitions. Storage is cheaper than file storage, what is something you will never find in a nornal database. **What do you dislike about Google Cloud BigQuery?** It seems that GCP is not marketing it as it should. Other platforms such as Snowflake seem to capture more awareness in the Enterprise market. Also, although I believe in the commitment of GCP on it, GCP is famous for retiring products and leaving developers and customers in general orphans. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** For me BigQuery is the best platform to handle on the cloud time-series industrial process data, like machine metrics and sensor data in general. ### 34. Great tool **Rating:** 4.5/5.0 stars **Reviewed by:** Laura M. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2024 **What do you like best about Google Cloud BigQuery?** BigQuery is a poweful tool to perform data analysis while working with big amount of information. I love how easy it's to integrate with data from different sources like Storage. **What do you dislike about Google Cloud BigQuery?** User interface is sometimes a bit slow while working with it and at the begining it can be difficult to find where some options are. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** BigQuery solves for us being able to work and analyze terabytes of information, helping us to identify issues using raw information that we generate from our systems real time. ### 35. Best warehouse for BI team and building dashboards **Rating:** 5.0/5.0 stars **Reviewed by:** Bhagyashri G. | candere, Retail, Small-Business (50 or fewer emp.) **Reviewed Date:** November 22, 2023 **What do you like best about Google Cloud BigQuery?** The structure of bigquery is the best thing about it, querying a data is super easy and there is not much diffrence between mysql and googlesql hence easy to use. Our environment has never gone down so not need of support , i use it faily for scheduling and pay as you go feature **What do you dislike about Google Cloud BigQuery?** the panel is little difficult to understand for a begginer to views queries of a data need to change tabs betwwen views schedule queries and tables **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Previously data was not on cloud and we use to get data directly from database it was hitting the server now everythong is on bigquery easy to use data for dashboard making and for predictive analytics ### 36. Big query for Analytics **Rating:** 3.5/5.0 stars **Reviewed by:** Jeeban Jyoti D. | Lead Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 08, 2024 **What do you like best about Google Cloud BigQuery?** It is faster as it seems, the UI looks clean **What do you dislike about Google Cloud BigQuery?** It seems lil costly as compared to Azure DB. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We have data warehousing tables and views which are used flr reporting for Financial accounting. So it helps then in re-conciliation ### 37. BigQuery : New generation storage and analytics system. **Rating:** 4.5/5.0 stars **Reviewed by:** Pritam K. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 06, 2024 **What do you like best about Google Cloud BigQuery?** *No need to physically store data. *Real time analysis and results. *Since no need to physically store data , so it's very cost effective. **What do you dislike about Google Cloud BigQuery?** *No one can for sure estimate the pricing for handling and maintaining some specific data **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Earlier we needed to physically store data for maintenance and analysis which was very costly. After the introduction of Google cloud BigQuery this has been resolved as it works on cloud model. ### 38. Future of Data Warehousing **Rating:** 5.0/5.0 stars **Reviewed by:** Nagaraja Harsh K. | Technical Recruiter, Enterprise (> 1000 emp.) **Reviewed Date:** April 03, 2024 **What do you like best about Google Cloud BigQuery?** In Google Cloud Big Queery we don't have to worry about soace very simple in nature.Even we can retrieve old data from the cloud warehouse in very less time. **What do you dislike about Google Cloud BigQuery?** In Google Cloud BigQuery we lost control of data which is required sometimes while doing premises based integration. On call production support are rare in it. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Data security is good . No need for the managemnt of data because so many inbuilt features are there to handle .Data fetching speed is very fast and saves lots of time. ### 39. Believe it or not but i am loving GCP Bigquery **Rating:** 5.0/5.0 stars **Reviewed by:** Sudhanshu P. | Account Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** March 28, 2024 **What do you like best about Google Cloud BigQuery?** The best thing about big query is you can analyse millions of data sets previously we have to wait for longer time to analyse those data. But your google big query you can analyze millions of data sets in a short period of time. It's easy to use. The best thing is it's very frequent and easy for user. **What do you dislike about Google Cloud BigQuery?** For large datasets on e-commerce web implementation i found big query little complicated when optimising data using sql queries. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** For designing data pipeline i found big query easy to use. ### 40. A data warehouse on demand. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Food Production | Enterprise (> 1000 emp.) **Reviewed Date:** February 21, 2024 **What do you like best about Google Cloud BigQuery?** Google Cloud BigQuery simplifies data analysis with an intuitive interface and seamless integration. Its user-friendly query editor and standard SQL support cater to users of all levels, while integration with Google Cloud services like Storage and Dataflow streamlines implementation. With RESTful APIs enabling third-party tool integration, BigQuery facilitates collaboration and interoperability. In essence, it's a powerful platform for efficient data processing and actionable insights. **What do you dislike about Google Cloud BigQuery?** For users with large datasets, Google Cloud BigQuery's pricing based on data processed can pose financial challenges. However, the platform's scalability, seamless integration with Google Cloud services, and robust analytics capabilities outweigh these limitations, making it an excellent choice for organizations aiming to maximize data potential while considering cost-effectiveness and performance fluctuations. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I wanted a database server for which I don't want to maintain the infra. Google Cloud BIgQuery helped me solve that. Also it was very easy to scale. ### 41. Excellent Query Engine on External Data Sources **Rating:** 4.5/5.0 stars **Reviewed by:** Sharad S. | Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** December 29, 2023 **What do you like best about Google Cloud BigQuery?** Accurate implementation of Dremel research paper, Well written client for Integration, Query performance on external and managed data source is admirable, the number of big data format support is high, few custom DSLs are very convenient to use. Migration of data or project data from external sources to BigQuery is very simple which made it really simple to work with **What do you dislike about Google Cloud BigQuery?** Support of the dataframe is missing. Rust client is missing. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Big Query is a unified data processing engine that works on almost all data formats and let the user perform analytics on heterogeneous data formats. Unlike traditional data processing engines, data does not have to be ingested in engine, In fact any layout can be queried and go for the analytics without any migration big query reads the data directly from object storage. ### 42. Efficient syntax handling and useful features **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Accounting | Mid-Market (51-1000 emp.) **Reviewed Date:** November 28, 2023 **What do you like best about Google Cloud BigQuery?** BQ is really good at providing a simple, yet powerful, experience for SQL wranglers. It is relatively easy to implement, and it also has a good customer support team, as well as forums and a engaging community. It also plays well with the GCP family of products, and connectors for BQ can be found in third-party applications. Having used it daily for running queries, I can say that its predictive engine is top-notch, and formatting is quite easy. **What do you dislike about Google Cloud BigQuery?** Some parts, especially the scheduled queries and jobs sections do feel a bit dated. Also, since it is nested in the GCP family, permissions are a nightmare to navigate for new users. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We have to handle a lot of data, coming from multiple sources. We trust in BQ to store and handle the information, making it easy for us to query it and use it in tandem with other applications. ### 43. Most feature-rich data warehousing solution available **Rating:** 5.0/5.0 stars **Reviewed by:** Stacey H. | Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** I've worked with BigQuery for the last 5 years, and it's staggering how far it's come and how often Google keeps adding new features to this solution. It handles complex SQL queries on millions of rows lightning fast, and is highly scalable and customizable in its implementation, so you can tailor the cost. **What do you dislike about Google Cloud BigQuery?** I wish that there were options for generating SQL select and DML scripts by right clicking an object **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Easily unifying disparate sources of corporate data and eliminating silos ### 44. BQ is very easy to use and its UI is user friendly **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** October 09, 2024 **What do you like best about Google Cloud BigQuery?** Ease of use, implementation and easy integration. **What do you dislike about Google Cloud BigQuery?** One cannot add or remove columns from UI using SQL. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** I use BQ tables for analytical reports in Tableau and Power Bi ### 45. A must have db for anyone **Rating:** 5.0/5.0 stars **Reviewed by:** Bilal M. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 10, 2024 **What do you like best about Google Cloud BigQuery?** SPEED - BigQuery is fast - it what drew me to it on the first day. We can query as fast as anything. **What do you dislike about Google Cloud BigQuery?** There are some functionalities that were previously in MS SQL server that still dont seem possible in BQ but slowly more are becoming available. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** We solve problems for clients such as creating a data warehouse, conducting ad hoc analysis and more recently using BQML to build and deploy models very quickly. We also schedule them using scheduled queries ### 46. Bigquery - A data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Sanjana K. | Senior Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2024 **What do you like best about Google Cloud BigQuery?** Bigquery is very helpful as it is SQL powered and SQL is very known language to most of people. It helps to manage the data like data manipulation, definition and it is very structured form so easy to access **What do you dislike about Google Cloud BigQuery?** It is Little expensive for more workloads . And it needs more improvement. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** As a consultant I use bigquery while manipulating the data in jd Edwards or to extract a large amount of data for evaluation or to work on it to give client more insight on the application ### 47. solid databse to manage data lake / **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Luxury Goods & Jewelry | Enterprise (> 1000 emp.) **Reviewed Date:** May 01, 2024 **What do you like best about Google Cloud BigQuery?** bigquery is very scalable and flexiblef when. we appreciate the low storage cost adn the fact hat you ahve several elvel of cold storage. rquery rpocessing sclability is a key factor which allows us to scale our lake **What do you dislike about Google Cloud BigQuery?** cost is somethimes difficult to estimate for new projects **What problems is Google Cloud BigQuery solving and how is that benefiting you?** we are imgrating from SAP BW to Bigquery to build scalable analytics , spported by DBT framework as transformation and data modelling layer ### 48. It's good if you are a beginner in in SQL. Help you understand a lot **Rating:** 3.5/5.0 stars **Reviewed by:** Joshua C. | Accountant, Small-Business (50 or fewer emp.) **Reviewed Date:** May 16, 2024 **What do you like best about Google Cloud BigQuery?** It's compatible for you if you are learning SQL and if you are a beginner. There are several resources available there which can help you learn SQL . And helps you handle complex data **What do you dislike about Google Cloud BigQuery?** It's sometimes difficult to understand and identify the tools. Some options you may not find it easy like excel **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It can handle large amount of data. It can ### 49. It is cost-Effective **Rating:** 5.0/5.0 stars **Reviewed by:** Himanshu S. | Talent Acquisition Lead-Engineering Positions (Automotive & Semiconductor Domain), Mid-Market (51-1000 emp.) **Reviewed Date:** March 28, 2024 **What do you like best about Google Cloud BigQuery?** 1. Bigquery provides the capacity to be changed in size of the data according to the users need. 2. In bigquery, we don't need to managed the servers as they are automatically managed by itself. 3. Bigquery is budget friendly. 4. Bigquery is fast in processing. **What do you dislike about Google Cloud BigQuery?** 1. In Bigquery, maintenance is required on regular basis. 2. As google cloud bigquery is new technology so study materials are not easily available to learn it. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** Bigquery is fast in processing so it saves time to execute the query. ### 50. BigQuery: Big on Easy Use, Big on Data, Big on Analysis **Rating:** 4.5/5.0 stars **Reviewed by:** Cynthia W. | Client Service Executive , Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** March 28, 2024 **What do you like best about Google Cloud BigQuery?** I find this robust data warehouse absolutely easy-to-use, scalable, big on data, query and analytics. its serverless which is great as well because it rescues me from having to maintain it. Its got good security and it integrates well with other Google Cloid services. **What do you dislike about Google Cloud BigQuery?** I didn't like its steep learning curve, quite technical. Its data lock-in and limited control over underlying infrastructure and configuration i don't like as well. **What problems is Google Cloud BigQuery solving and how is that benefiting you?** It avails Marketing and Predictive Analytics for us slong with Big Data Collection, Querying, Processing and Integration. ## 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=7§ion=pricing&secure%5Bexpires_at%5D=2026-06-08+14%3A34%3A06+-0500&secure%5Bsession_id%5D=f04df5a2-2511-4360-913e-b3c6e5057a84&secure%5Btoken%5D=8cf025b97deafa46f1345526caa0c3a1f28713d829393b6edf8da7e5ad71c3c9&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](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 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) - [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.5/5.0 (706 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (781 reviews) - [Cloudera Data Platform](https://www.g2.com/products/cloudera-cloudera-data-platform/reviews) - 4.1/5.0 (131 reviews)