"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The feature that we find most useful is the ability to do analytics on the fly."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"The initial setup is easy."
"The most valuable feature is the scalability, as it grows according to our needs."
"This service can merge and integrate well with all databases."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The pricing is reasonable and matches the rest of the market."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"Can be leveraged with respect to better performance, auto tuning and competition."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The technical support is pretty good, particularly if you are a more technical user."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Planting is the primary key enforcement that should be improved."
"The OLAP slide and dice features need to be improved."
"It takes a lot of time to ingest and update the data."
"In our experiments, the handling of unstructured data was not very smooth."
"There are too many limitations with respect to concurrency."
"Improvement could be made in the area of streaming data."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"Pricing is an issue for many customers."
"I would like to see a client version of the GUI."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.
Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.
Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.
As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.
Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 12 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 42 reviews. Amazon Redshift is rated 7.6, while Snowflake is rated 8.4. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Amazon Redshift is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Vertica, Teradata and Oracle Autonomous Data Warehouse, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Vertica, Teradata, Oracle Exadata and AWS Lake Formation. See our Amazon Redshift vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.