Scalable and cost-effective data warehousing tool
October 12, 2017

Scalable and cost-effective data warehousing tool

Vinaybabu Raghunandha Naidu | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

Redshift is one of the most scalable yet simple data warehousing tools. It is not only used within the engineering team but widely used by the business team too. One of the major use cases are to power the dashboards and reports which are in looker. It helped to migrate from the traditional email reports to dynamic dashboards and reports which can be shared to various end users and businesses. It helped in faster data retrieval and can scale well with ease.
  • Scalability with less downtime.
  • Performance optimization without affecting the business i.e zero downtime during optimization
  • Powerful yet simple to use. Very easy to optimize and improve performance during the regular read/write operations
  • No need of DBA to operate and maintain Redshift as it is a completely managed data warehousing tool
  • Good customer support and will respond in very quick time with clear information and documentation
  • Well documented commands
  • Can propose better optimization techniques based on the business use case.
  • Can provide option to set the upper bound on number of connections to cluster
  • Can improve on optimized writes/updates
  • Increased the end users as the reports and dashboards was very helpful to give a clear insights of business
  • Increased business as the analysts were able to retrieve the data in quick time
  • Improved the data retrieval as most are familiar with SQL
From an engineers perspective data must be available in near real time and from business perspective data must to consistent all over which is perfectly supported by Amazon Redshift. Scalability and performance tuning is well designed in Redshift.
Business can make decisions and write queries for data retrieval instead of requesting engineers to fetch data.
Well suited for faster data retrieval and powering OLTP need and perfectly suited for generating dynamic dashboards and reports.
Not suited for massive data storage and analytics. Can-not handle unstructured data.