Amazon Redshift Software Reviews, Demo & Pricing – 2023

Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business.

PROS

Redshift is a reliable cloud data warehouse that’s easy to set up especially if your tech infra already runs on AWS.

CONS

Scaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it’s still limited to just halving/doubling your current cluster. It’s not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses.

Reason for choosing Amazon Redshift

Redshift’s pricing is straightforward and more predictable compared to other cloud data warehouses. Also, our existing tech infrastructure already runs on AWS so using Redshift gave us much better integration with our current tech stack.

Reasons for switching to Amazon Redshift

Our datasets are getting larger and larger. We needed an OLAP database which was more appropriate for our reporting and analytics workloads.