Amazon Redshift: Reliable and powerful cloud-based data warehouse
June 25, 2019

Amazon Redshift: Reliable and powerful cloud-based data warehouse

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

AWS Redshift is the cloud-based data warehouse where we store our application level datasets and is used further for insights from the stored dataset. It improves the decision support for our business based on data analytics on a large set of real-time datasets which force the business processes to the next level. It provides good performance with high availability for essential data analysis and valuable intelligence.
  • Easy query and fast execution
  • High performance and availability
  • Support of large datasets
  • Scalable solution
  • Database optimization
  • Time consuming process for schema design and modification
  • Integration is little bit difficult
  • Realtime and high availability, add quick access of the data.
  • Improve decision support based on quick data analytics.
  • Costlier compared to others, but we can generate ROI within a year, based on large scale applications.
As our applications are hosted on AWS service, Redshift is the best option for us. Also, it provide a near to real-time performance on limited datasets and less complex queries. High availability is the major concern for any growing business and AWS is the best option for this. Compared to other services like Google and Azure, this one has limited functionality but great support by the AWS customer service.
Providing a great interface for queering the complex dataset and also provides a wide range of libraries for multi-language support. But initial setup and schema design and modification is complex compared to others.
Amazon Redshift is the data warehouse under the umbrella of AWS services, so if your application is functioning under the AWS, Redshift is the best solution for this. For large amounts of data, the application is the best fit for real-time insight from the data and added decision capability for growing businesses. If your application is outside of AWS it might add more time in data management.