Question: what is the difference between redshift and redshift spectrum?
Answer: Redshift is a managed data warehouse service delivered by AWS. Redshift stores data in local storage distributed across multiple compute nodes. Redshift Spectrum uses a Redshift cluster to query data stored in S3, instead of local storage.