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.

Add a Comment

Guest
Why do you like it?

Sign Up with Email