Amazon Redshift - a new generation of data warehouse platform
December 19, 2018

Amazon Redshift - a new generation of data warehouse platform

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

Overall Satisfaction with Amazon Redshift

Amazon Redshift is being used as the main data warehouse across the whole organization. It provides essential business performance data and valuable intelligence. Different departments utilize it for a variety of operations, and decision makers rely on the data analytic tools built upon its data for tracking and enhancement, wherever needed.
  • It does very well in data ingestion, and compresses data efficiently.
  • Most of the queries return results quickly even with large data sets.
  • It has a hard limit of total number of concurrent connections to the database. Compared with conventional databases that limit is very low.
  • Its workload management (WLM) mechanism could be improved, such as made more dynamic and easier to tune and manage.
  • Data loading is much faster
  • Database physical footprint got much smaller
  • No need for our own data center and hardware
Amazon Redshift is much easier to set up and start using. It interacts well with the PostgreSQL client (psql) and shares certain basic data dictionary, and people familiar with PostgreSQL feel right at home. The cluster is part of AWS services offering, and it works well with other services such as S3 and EC2.
It is best for large structured data sets with data normally loaded from files, instead of through heavy SQL data manipulation. If there are SQL data manipulation, better to have mainly DDL (create/drop/alter) instead of DML (insert/update/delete) to achieve the same goals. It is also better for smaller number of concurrent connections (less than 500).