Amazon Redshift
Amazon Redshift is a specialized type of managed relational database called a data warehouse. A data warehouse stores large amounts of structured data from other relational databases and allows you to perform complex queries and analysis against that data. For example, Redshift can combine data from financial, sales, and inventory databases into a single data warehouse and then analyze or generate reports on that data.
Because data warehouses can grow quite large, they require a lot of storage. To use Redshift, you create a cluster consisting of at least one compute node and up to 128 nodes. Using dense compute nodes, you can store up to 326 TB of data on magnetic disks, and with dense storage nodes you can store up to 2 PB of data on SSDs.
Redshift’s usefulness isn’t limited to pulling in data from relational databases. Redshift Spectrum is a feature of Redshift that lets you analyze data stored in S3. The data must be structured, and you must define the...
