What is Redshift?

Amazon Redshift is a fully-managed, petabyte-scale data warehouse, offered only in the cloud through AWS. Like other analytical data warehouses, Redshift is a columnar store, making it particularly well-suited to large analytical queries against massive datasets.

Redshift is also fast enough for interactive querying against large-scale data sets. Redshift makes it easy to scale clusters up or down through the AWS Console,the command-line, or an API and can support clusters with as few as one node and as many as 128. Queries run on Redshift Spectrum are allocated compute resources dynamically, with no pre-planning necessary and no maximum.

Redshift is a hugely popular data warehouse, offering a nice balance between easy set-up/maintenance and robust customization options. This means that Redshift provides a powerful cloud database solution. As organizations build the knowledge to monitor and optimize the redshift cluster for their specific workloads, they can achieve even greater throughput.