:

It supports Online Analytical Processing (OLAP) type of DB

workloads and analyzes them using standard SQL and existing

Business Intelligence (BI) tools (AWS QuickSight or Tableau).

It is used for executing complex analytic queries on semi-structured

and structured data using query optimization, columnar-based

storage, and Massively Parallel Query Execution (MPP).

Redshift Spectrum helps to directly query from the objects (files)

on S3 without actually loading them.

It has the capability to automatically copy snapshots (automated

or manual) of a cluster to another AWS Regi