Can anyone list down the main differences between Amazon Redshift and RDS? I know both are relational DB's but why choose one over the other ?
RDS is a managed service for Online Transaction Processing databases (OLTP), i.e. a managed service for the usual MySQL, PostgreSQL, Oracle, MariaDB, Microsoft SQL Server or Aurora (Amazon's own relational database)
Redshift is a managed service for data warehousing, i.e. columnar oriented storage, typical for business analytics type of workloads.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With