What users are saying about
Top Rated
147 Ratings
Top Rated
81 Ratings
Top Rated
147 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 100
Top Rated
81 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100

Highlights

Amazon Redshift and Snowflake are both data warehouse software designed to store data for querying, analysis, and extraction. Mid-sized businesses are the most frequent users of both data warehouse solutions. Large enterprises are more likely to use Snowball, likely due to its ability to work with many types of data. Smaller businesses tend to use Amazon Redshift due to its usability and affordable pricing.

Features

Amazon Redshift and Snowflake both offer essential data warehouse features, including storage and querying data, but they also have some standout features that set them apart.

Amazon Redshift provides end-to-end encryption and highly customizable security features at all price points. Additionally, Amazon Redshift offers many integrations with other technologies, particularly with technologies on the AWS platform. Lastly, Amazon Redshift requires less technical expertise to use as it has a usable interface and secure backup features.

Snowflake provides native support for JSON documents, allowing for built-in functions and querying for JSON data. Additionally, Snowflake includes robust automation tools for data vacuuming and compression, which can save time for users. Lastly, Snowflake can handle complex data types like arrays and objects, making it a great choice for businesses with a lot of complex data.

Limitations

Though Amazon Redshift and Snowflake both offer robust data warehouse features, they also have some limitations that are important to consider.

Amazon Redshift has limited JSON support. By default, it splits all JSON data into strings, which can make it difficult to query and analyze. Database management for Amazon Redshift mostly has to be handled manually, as opposed to Snowflakes automation features. Lack of automation may make Amazon Redshift a poor choice for companies with small technical teams that can benefit from automation. Lastly, Amazon Redshift provides limited support for complex data types like arrays and objects.

Snowflake offers advanced security features, but they are not available at every price point. Users with small data storage needs, but important security needs may struggle to find the right Snowflake package for them. Snowflake also lacks the seamless AWS technology integrations that Amazon Redshift provides. Businesses with few technical staff members may also struggle with Snowflake’s user interface and backup features.

Pricing

Amazon Redshift offers a two-month trial where users can see if they like the technology before purchasing. Beyond the trial, Amazon Redshift is priced depending on storage needs and feature requirements. Pricing can start as low as $0.25 per hour, and reach as high as $13.04 per hour.

Snowflake offers a one-month free trial for users to try the software. Pricing for Snowflake is dependent on storage needs, platform, and geographic region and starts as low as $2.00 per hour. Snowflake includes scaling pricing based on workload, so a business with a rapidly changing workload may have some savings with Snowflake.

Likelihood to Recommend

Amazon Redshift

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)
Arthur Zubarev | TrustRadius Reviewer

Snowflake

Specific scenarios where Snowflake is very strong include analytical data processing scenarios. Snowflake is wonderful at inexpensively consolidating and storing data and allowing very fast access to that data while maintaining a low cost profile with it's ability to automatically resume and suspend virtual warehouses. Snowflake is less suited to transaction processing scenarios and isn't a best choice to back up an online order processing system.
Brian Bickell | TrustRadius Reviewer

Pros

Amazon Redshift

  • Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
  • Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
  • Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
  • Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.
Gavin Hackeling | TrustRadius Reviewer

Snowflake

  • Resources that scale up and down automatically to ensure that queries run quickly and efficiently without paying for computing power that is not being used
  • Much more reliable than our previous software
  • No noticable limit to query size
  • Runs very quickly
Jake Schlingman | TrustRadius Reviewer

Cons

Amazon Redshift

  • It could benefit from adding data integrity and programming tools common to other database management systems.
  • Amazon Redshift is based on PostgreSQL 8.0.2. That version of PostgreSQL was released in December 2006. While PostgreSQL was much improved since then, the new features were not implemented in Redshift. Many basic features are missing from it.
  • Primary keys can be declared but not enforced. Referential integrity (foreign keys) can be declared but not enforced. UNIQUE and CHECK constraints are not supported and cannot be declared.
  • IDENTITY can be declared on a column, and Redshift will put unique values into it. However: IDENTITY values in the newly inserted rows won’t be incremental or sequential. To implement a sequential number, you need to write your own custom code.
  • There are no stored procedures in Redshift. We are writing SQL script files, and then parsing and running them one statement at a time from a Python program. This also enabled us to implement execution-time error logging.
  • In SQL scripts, to check for the row count of affected rows, a complicated join query against some system tables or views has to be executed.
  • Data Control Language (DCL) does not exist. No statements like IF, WHILE, DO, RAISERROR, etc.
  • On performance of views… Views do not “pass-through” a query parameter which is a potential problem for performance.
  • When selecting against a view with the WHERE clause outside of the view, the inner query of the view will be executed first without consideration for the WHERE clause, and only then the WHERE clause will be applied.
  • Certain clauses of SQL work many times faster than other clauses. So be careful and test your statements for performance earlier rather than later, especially if working with a large data set.
  • There was a situation when DELETE FROM JOIN was unacceptably slow. Replacing JOIN with the USING clause made DELETE instantaneous.
Michael Romm | TrustRadius Reviewer

Snowflake

  • 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.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Amazon Redshift

No score
No answers yet
No answers on this topic

Snowflake

Snowflake 8.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
Anonymous | TrustRadius Reviewer

Usability

Amazon Redshift

Amazon Redshift 8.5
Based on 8 answers
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Brendan McKenna | TrustRadius Reviewer

Snowflake

Snowflake 8.7
Based on 11 answers
Extensive documentation and several tutorial videos are available online which reduces learning and deployment time. User Interface is very intuitive and provide flexibility to create databases, schema, tables and assign permissions in a few clicks (no need to write SQL queries). SQL History helps to track usages and billing dashboard provide credit breakup per warehouse. Create views and write procedures in JavaScript for more complex data transformation requirement
Anonymous | TrustRadius Reviewer

Support Rating

Amazon Redshift

Amazon Redshift 7.9
Based on 7 answers
The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support
Anonymous | TrustRadius Reviewer

Snowflake

Snowflake 8.5
Based on 10 answers
Overall, the support from Snowflake has been very good. Since we are one of the major users for Snowflake and have a dedicated tech team to solve all the technical problem on our way. On the side of the technical problem, any sql related questions can be found from everywhere online.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Amazon Redshift

Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.
Anonymous | TrustRadius Reviewer

Snowflake

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.
Andrew Goss | TrustRadius Reviewer

Return on Investment

Amazon Redshift

  • Redshift has had a very positive impact on our business. It has been used to provide analytics on marketing campaigns to boost revenue.
  • Redshift is instrumental in our payment collection business processes. It powers everything from who gets called to who gets sent collection emails.
Seth Goldberg | TrustRadius Reviewer

Snowflake

  • Quick installation/setup for a data warehouse solution.
  • Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model.
  • Make easy and simplified the workload management using virtual warehouses and materialized views.
Jacob Biguvu | TrustRadius Reviewer

Pricing Details

Amazon Redshift

General

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

Amazon Redshift Editions & Modules

Edition
Current Generation$0.25 - $13.041
Previous Generation$0.25 - $4.081
Redshift Spectrum$5.002
Redshift Managed Storage$0.243
  1. per hour
  2. per terabyte of data scanned
  3. per GB per month
Additional Pricing Details

Snowflake

General

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

Snowflake Editions & Modules

Additional Pricing Details

Add comparison