Amazon Redshift Review

Allows you write complex queries and perform row by row processes

What is our primary use case?

We use it to build a data warehouse and a centralized location for all of our data sources, allowing for in-depth analysis by using SQL queries.

How has it helped my organization?

  • Allows for the storage of huge amounts of data.¬†
  • Assists users to perform ad hoc analysis on a lot sources together.

What is most valuable?

  • Windows functions, such as LEAD and LAG.
  • Allows you write complex queries and perform row by row processes.

What needs improvement?

In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations.

For how long have I used the solution?

Three to five years.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Amazon Redshift reviews from users
...who work at a Comms Service Provider
...who compared it with Snowflake
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: April 2021.
474,857 professionals have used our research since 2012.
Add a Comment