What is Redshift?
Amazon Redshift is the Cloud Data Warehouse service available on AWS that allows you to efficiently perform analytical queries in SQL for Big Data.
Internally, it is an MPP (Massively Parallel Processing) database that analyzes data using multiple nodes in parallel. Each of these nodes is responsible for executing a subset of the query on the data.