Google Cloud BigQuery Pros and Cons

Google Cloud offers a wide range of solutions for technology development and deployment, including Computing, Networking, data Storage and management, AI and machine learning, all in one integrated platform. GCP has user-friendly learning tutorials and reliable community support, which makes it easy to solve whatever challenges might come up. Review collected by and hosted on G2.com.

The user interface can appear complex to newcomers, as it lacks customization options for the left navigation menu. The inability to remove services not used by users can make the interface unnecessarily crowded. Review collected by and hosted on G2.com.

BigQuery has been a reliable tool for marketing data integration. It's serverless, so it's easy to scale and let's us focus on other things rather than maintenance overall.

It's fast, so big querys that requires a lot of data takes just a few seconds to get the data. Review collected by and hosted on G2.com.

While BigQuery is an awesome tool, there are a few things that can be a bit frustrating.

Costs can add up quickly if you’re not careful. You need to focus on optimization and spend time setting up tables propperly.

Another thing is that the learning curve requires time if you’re not familiar with SQL, getting started can feel overwhelming (a lot of traditional SQL techniques does not work on BigQuery, and some capabilities in BigQuery are not industry standards) Review collected by and hosted on G2.com.

- Ease to use

- Ease of Implementation

- Number of Features

- Support

- Price

- Efficiency

- Lots of functions available

- Easy project and Dataset handling Review collected by and hosted on G2.com.

The way Google Cloud Big Query has evolved from it's inception is really comendable. So there are very less dislikes at the moment.

SQL Support could be further enhanced and integrations with different platforms via APIs can be added Review collected by and hosted on G2.com.

Quick onboarding for begginer with clear UI and comprehensive documentation and supports ad-hoc quering and scheduled batch jobs and native interactions with google ecosystem products make workflows seamless as ease of implementation having robust customer support. For Data analysis helpful for daily use. Review collected by and hosted on G2.com.

Misunderstanding of how queries are billed can lead to unexpected costs and requires careful optimization and awareness of best practices and while basic quering is simple, features like partitioning, clustering, and BigQuery ML reequire some learning and users heavily reliant on UI might find some limitations compared to standalone SQL clientsof third-party tools. Review collected by and hosted on G2.com.

It's a powerful data science tool with serverless architecture and excellent scalability

It efficiently processes large datasets using SQL

It works well with other Google Cloud services and visualization tools

It offers flexible pay-as-you-go pricing

Despite some limitations (like query costs and table renaming restrictions), it's considered highly valuable for data scientists' careers Review collected by and hosted on G2.com.

Cannot rename tables.Must replace entire datasets if table names need changing

Querying can be expensive. Testing queries on live data can incur significant costs

No 'undo' function for queries. Datasets can expire and be lost if not monitored

Need to be cautious with live data. Review collected by and hosted on G2.com.

The efficiency of handling a large set of data to query and retrieve results within few seconds/minutes of time depending on the size of dataset. Review collected by and hosted on G2.com.

Sometimes the constraints of not clearly stating the errors while uploading dataset. Review collected by and hosted on G2.com.

I am learning BigQuery during my internship at Brainwave Matrix Solutions, and it is easy to use. It works fast. I can run SQL queries quickly and get results, even as a beginner. It also works well with other Google Cloud tools. BigQuery handles big data easily. It’s really helping me as I learn. Review collected by and hosted on G2.com.

It can be hard to understand all the features for someone who is new. The UI of the system can be made simpler to understand and can be remembered easily for someone new like me. Review collected by and hosted on G2.com.

The best thing was to use google cloud run and to test it for real time task - that is using faas approach - testing the deep learning seq2seq model for classification task of the video frame in real time. Gcloud run offer multiple parameters like public and private URL to test the app internally ( in the gcloud Ip addresses) or externally ( making the app available for the public), scalability, CPU boost to boost the request from the clients and scalability using minimum and maximum number of instances. And I got results in real time for 20 clients efficiently, accurately and quickly.

Also google offered my project with the grant of 25K$ so I can use the services for free and experiment them. Review collected by and hosted on G2.com.

Although I'm able to get real time results which I expected - but there I faced cold start problem - even though I set the minimum instances set to 1; but after remaining idle for above 1 to 2 hours - when there is the request of the user to the server - the model started to load and thus - the gcloud run app/link couldn't give results faster and even sometimes give no results.

Secondly, I faced Domain Sharing issue here, even though I have admin acces of my account but I solved after doing experimenting multiple things - there was no proper documentation on how to give access to the user inside the account other users. Review collected by and hosted on G2.com.

It's very easy to use and it's familier to all also auto save option and file edit history will help for backup no need separate backup, Most comenly using by all, its ease to implement and have very good support from google, also it is very easy to integrate to all.also google cloud platform have AI feachers are very useful, Review collected by and hosted on G2.com.

Compare to other cloud platform its costly, Most of the customers have trust issues with google cloud, Review collected by and hosted on G2.com.

I liked the Services like Cloud Run, Cloud Run functions, BigQuery, VPN Gateways , VPC Access connector, App Engine. Also the Cloud DNS service is an amazing thing to ensure more security with the resources and Concept of Project is another intresting factors when comparing to AWS or Azure Review collected by and hosted on G2.com.

I Faced some challenges mostly with App engine and IAM , i didn't feel easiness in these areas. Also the authenication part is bit complex and not quite easy Review collected by and hosted on G2.com.