Likelihood to Recommend Like any NoSQL database, whether it's
MongoDB or not, it's best suited for unstructured data. It's also well suited for storing raw data before processing it and performing any type of ETL on the data.
Read full review For organizations looking to avoid the overhead of managing infrastructure, BigQuery's server-less architecture allows teams to focus on analyzing data without worrying about server maintenance or capacity planning. Small projects or startups with limited data analysis needs and tight budgets might find other solutions more cost-effective. Also, it is not suitable for OLTP systems.
Read full review Pros Scalable Instantly and automatically serverless database for any large scale business. Quick access and response to data queries due to high speed in reading and writing data Create a powerful digital experience for your customers with real-time offers and agile access to DB with super-fast analysis and comparison for best recommendation Read full review Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data. Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns. Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds. Read full review Cons Expensive, so be careful of the use case. We had a thought time migrating from traditional DBs to Cosmos. Azure should provide a seamless platform for the migration of data from on-premises to cloud. Read full review Can't use it out of Google's cloud platform which is a minus point if you want a local setup. Can be a little expensive to manage. A little difficult to manage someone with less technical expertise as it requires you to have SQL knowledge of joins, CTEs etc. Read full review Likelihood to Renew It's efficient, easy to scale, and works. We do have to do a bit of administration, but less now than when we started with this a couple of years ago. Microsoft continues to improve its self-management capability.
Read full review We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.
Read full review Usability It has very good compatibility and adaptability with other APIs and developers can safely create new apps because it is compatible with various tools and can be easily managed and run under the cloud, and in terms of security, it is one of the best of its kind, which is very powerful and excellent.
Read full review web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2
Read full review Support Rating Microsoft is the best when it comes to after-sales support. They have a well-structured training and knowledge base portal that anyone can use. They are usually quick to respond to cases and are on point for on-call support. I have no complaints from a support standpoint. Pretty happy with the support.
Read full review BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.
Read full review Alternatives Considered Cosmos DB is unique in the industry as a true multi-model, cloud-native database engine that comes with solutions for geo-redundancy, multi-master writes, (globally!) low latency, and cost-effective hosting built in . I've yet to see anything else that even comes close to the power that Cosmos DB packs into its solution. The simplicity and tooling support are nice bonus features as well.
Read full review Google's
Firebase isn't a competitor but we had to use Google's BigQuery because Google's
Firebase 's database is limited compared to Google's BigQuery. Linking your
Firebase project to BigQuery lets you access your raw, unsampled event data along with all of your parameters and user properties. Highly recommend connecting the two if you have a mobile app.
Read full review Contract Terms and Pricing Model None so far. Very satisfied with the transparency on contract terms and pricing model.
Read full review Professional Services Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
Read full review Return on Investment It's made managing raw data much easier It provides a way to maintain raw data at a low cost It's easy to massage the data Read full review Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams. Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over. Read full review ScreenShots