What users are saying about
43 Ratings
17 Ratings
43 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101
17 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

Snowflake

Snowflake is great in quick process and ad hoc queries of JSON files (with built-in JSON support). Snowflake would not be the best alternative for sitting on top of Tableau Dashboards - mostly because of the engine being idle and filtering might take additional time. The fact that you only pay for engine time you actually use makes Snowflake is very cost-effective.
No photo available

Pros

  • Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
  • Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
  • Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
Vasco Mendes profile photo
  • Process Engine control - we can stop/pause/start engines for various tasks.
  • Processing speed is adequate unless there are many users on at the same time.
  • Web interface is easy and intuitive, like the fact that your queries are automatically saved in tabs.
No photo available

Cons

  • The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
  • Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
  • Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Vasco Mendes profile photo
  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
Snowflake8.0
Based on 1 answer
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
No photo available

Alternatives Considered

Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
Vasco Mendes profile photo
Snowflake is cheaper, but TreasureData has a better interface and much more functionality. Also, TreasureData is able to process a greater number of records more efficiently. TreasureData has the ability to run both Hive and Presto. Also, TreasureData has native APIs for many various products, as well as native SDKs. We are currently using both of them for various things.
No photo available

Return on Investment

  • Moderately reduced database running costs
  • Improved performance of database cluster which in turn has had a positive impact on the response times of our API services
Andrew Raines profile photo
  • Significantly improved the efficiency of analytics and reporting.
  • Performance of queries has gone up.
  • Allows for easy changes, making project timelines move faster.
No photo available

Pricing Details

Amazon Aurora

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

Snowflake

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