Amazon Redshift is a cloud-based fully managed data storage service of a petabyte-scale. With only a few hundred gigabytes of data and a petabyte or larger, you can begin using Redshift. This enables you to use your data to derive new insights for your business and customers. In the following video, our SME will explain ‘What is Amazon Redshift?’.
As you learnt from the video, Amazon Redshift is a fast, scalable data warehouse that makes it simple and cost-effective to analyse all the data across your data warehouse and data lake. It delivers performance that is 10 times faster than other cloud-based data warehouses by using machine learning, massively parallel query execution, and columnar storage on a high-performance disk.
Amazon Redshift achieves extremely fast query execution by employing the following performance features:
- Massive parallel processing (MPP).
- Online analytical processing (OLAP).
- Columnar storage.
- Platform as a service (PaaS).
- Fully managed on the cloud (AWS).
- Supports stored procedures.
Additional Reading
Amazon Redshift Documentation