Overall Satisfaction with Amazon Redshift
Amazon Redshift is a PostgreSQL based solution was seen as a drop-in replacement for several Postgres based databases (or schemas in Postgres parlance).
The eventual product: a Bill Inmon principles-based Data Warehouse served as a point or source of a single truth. It aided in decision making, historical outlooks and forecasting across various organizational verticals - the Finance, Marketing, and Medical Research. It was also possible to deliver data extracts to 3rd parties or visualize data on demand.
The eventual product: a Bill Inmon principles-based Data Warehouse served as a point or source of a single truth. It aided in decision making, historical outlooks and forecasting across various organizational verticals - the Finance, Marketing, and Medical Research. It was also possible to deliver data extracts to 3rd parties or visualize data on demand.
- Data retrieval experience really gets improved.
- In terms of database management, it is really a no management at all in AWS. There is no even an OS to take care or worry about.
- Auto or on-demand scaling is nice.
- Integrates quite well with other products within the AWS ecosystem.
- The number of connections is too small, I think at around 50 are allowed in parallel. With some ETL and apps connecting all the time, this brings an undesired possibility to some users or tools being unable to connect.
- Needs some tuning.
- The logging part is almost nonexistent.
- Can be quite costly in the long run as opposed to just RDS or on-prem/dedicated solutions.
- Redshift as a solution is viable in case an enterprise wants a relatively uncomplicated relational data storage engine that is elastic and autonomous.
- The costs are reasonable compared to other storage systems provided Redshift is capable to grow with your business and reduce administrative costs.
- Redshift integrates well with many of the offerings within AWS and outside it. The programmability story is also good.
Azure SQL Database was discarded because of a less attractive licensing, costs, plus its integrates poorly with many of the Azure offerings as say Azure Data Factory - it is not a true ETL yet. Also, the rest of the tools used were of Open Source type and it did not look like a good fit for Azure.
AWS Aurora in Postgres mode could be easier to migrate, but it wasn't that much cheaper than Redshift, minus its limitations.
Snowflake looked like the most promising and yet modern data warehousing solution that is able to elastically autoscale and provision more connections than Redshift, but it wasn't in wide use and hard to experiment with (not a native AWS citizen and wasn't whitelisted in GCP back then).
Redshift won because most of the developers and analysts knew Postgres.
Do you think Amazon Redshift delivers good value for the price?
Yes
Are you happy with Amazon Redshift's feature set?
No
Did Amazon Redshift live up to sales and marketing promises?
Yes
Did implementation of Amazon Redshift go as expected?
Yes
Would you buy Amazon Redshift again?
Yes