What is Amazon Redshift?

Amazon Redshift is a fully managed data warehouse solution from AWS that allows you to store and query large volumes of analytical data. It is fast and scalable providing a 10x performance lift over other data warehouses by using machine learning and parallel processing of queries against columnar storage held on very high performance disk.

The difference between a traditional relational database like Amazon Aurora is that a relational database is designed to store individual transactional data and records, whereas data warehouses are designed to store aggregated data from multiple sources like relational databases and S3 buckets.

Amazon Redshift data warehouses can be provisioned quickly. Redshift automatically provisions the resources required for the database and also automates the administrative functions like replication, backups and fault tolerance.

Redshift concurrency scaling provides the ability to store and retrieve almost unlimited amounts of data in your data warehouse. When enabled, concurrency scaling will automatically scale the number of clusters available to process concurrent read queries. When the concurrent query demand subsides, the additional cluster capacity…