What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
87 Ratings
89 Ratings

Amazon DynamoDB

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
87 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101
89 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Likelihood to Recommend

Amazon DynamoDB

It is ideal for those projects where you need to store a large amount of data, but you do not know how many will be so you need the database to increase its storage capacity together with the number of users, without having to spend extra money, it also has a great potential thanks to the fast connection it offers, so the data travels at high speed, and this speeds up the performance of the applications, excellent for projects where non-relational databases are used and what matters is to store large quantities of information and use them at high speed.
Winston Mendes profile photo

Google BigQuery

BigQuery is unlike anything we've used as a big data tool. It is perfectly suited to query large data sets quickly and to store those large data sets for any time use. It's perfect for storing data and using it for reports. Logging data is the perfect application for BigQuery, but transactional data is possible as well
Tristan Dobbs profile photo

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
8.6
Google BigQuery
Performance
Amazon DynamoDB
9.0
Google BigQuery
Availability
Amazon DynamoDB
9.3
Google BigQuery
Concurrency
Amazon DynamoDB
9.0
Google BigQuery
Security
Amazon DynamoDB
9.3
Google BigQuery
Scalability
Amazon DynamoDB
9.5
Google BigQuery
Data model flexibility
Amazon DynamoDB
6.7
Google BigQuery
Deployment model flexibility
Amazon DynamoDB
7.3
Google BigQuery

Database-as-a-Service

Amazon DynamoDB
Google BigQuery
8.8
Automatic software patching
Amazon DynamoDB
Google BigQuery
9.3
Database scalability
Amazon DynamoDB
Google BigQuery
9.0
Automated backups
Amazon DynamoDB
Google BigQuery
8.2
Database security provisions
Amazon DynamoDB
Google BigQuery
9.0
Monitoring and metrics
Amazon DynamoDB
Google BigQuery
8.6
Automatic host deployment
Amazon DynamoDB
Google BigQuery
9.1

Pros

Amazon DynamoDB

  • It's very easy to get started, creating a table with a partition/sort key and you're on your way.
  • You can scale up and down your read/write IO as needed.
  • You can store structured and unstructured data.
  • It works great with Web Development as it's JSON based.
Bob Smith profile photo

Google BigQuery

  • How many pros can a person type? This storage program gives workers and students the reality of unlimited storage space. I have never came close to overfilling my google cloud storage because it's huge and the best. I can view anything I save on there from any of my internet devices which is very important.
  • Depending on how you have the program set up - either online or through an application that lives on your desktop, dragging and dropping files to and from Cloud Storage couldn't be any more uncomplicated. Plus, new users who meet certain criteria - like updating personal security, or share the program receive additional free online storage.
  • The array of tools is very impressive, intuitive to use, and well organized in the sense that you don't have to go looking for individual apps. They're all easily accessed via a single dropdown.
Sam Lepak profile photo

Cons

Amazon DynamoDB

  • Complex searching (no support for case-insensitive or full-text search).
  • Only supports up to two-key indexes.
  • Requires choosing the indexes up-front when doing searches.
  • Does not have an SQL compatible query front-end.
  • No join-table support (requires putting all data into one table).
Chris Moyer profile photo

Google BigQuery

  • Though it is SQL some syntax are different but they are getting used to after you use for some time.
  • The legacy SQL is in beta state but can be used and you can run the query with simple SQL.
  • More documentation is needed for using User-defined functions in Big Query.
No photo available

Likelihood to Renew

Amazon DynamoDB

Amazon DynamoDB 8.8
Based on 28 answers
We will most likely continue to use DynamoDB for certain use-cases. If we stopped using DynamoDB as often, it would likely be because we started using Aurora Serverless more. Aurora Serverless may offer similar availability, management and cost benefits while allowing developers to use their MySQL tools and experience.
No photo available

Google BigQuery

No score
No answers yet
No answers on this topic

Usability

Amazon DynamoDB

No score
No answers yet
No answers on this topic

Google BigQuery

Google BigQuery 9.0
Based on 1 answer
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.
No photo available

Support

Amazon DynamoDB

No score
No answers yet
No answers on this topic

Google BigQuery

Google BigQuery 8.7
Based on 3 answers
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.
Tristan Dobbs profile photo

Alternatives Considered

Amazon DynamoDB

We evaluated using MongoDB or Amazon DyanmoDB. For us, the biggest advantage is that there's no maintenance cost for Amazon DynamoDB. Mongo gets complicated when you setup sharding. With Amazon DynamoDB, it's literally a push of button to increase throughput. This saves time and money on DevOps resources.
No photo available

Google BigQuery

Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Csaba Toth profile photo

Return on Investment

Amazon DynamoDB

  • Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
  • Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
  • Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.
Anudeep Palanki profile photo

Google BigQuery

  • 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.
Alex Andrews profile photo

Pricing Details

Amazon DynamoDB

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Google BigQuery

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison