Amazon Redshift Spectrum

This lesson covers Amazon Redshift Spectrum, including what it is, what it does, how it works, and some points to take into consideration when using Redshift Spectrum.

Learning Objectives

• How to manage cold data in Redshift using Amazon S3
• What Amazon Redshift Spectrum is and does
• How Spectrum Queries work
• Supported data formats of Spectrum
• File optimization using Spectrum
• Amazon Redshift Spectrum Considerations

Intended Audience

This lesson is intended for people that want to learn more about Amazon Redshift Spectrum and how it can be used to perform SQL queries on data stored in Amazon S3.

Prerequisites

To get the most from this lesson, you should have a basic understanding of Amazon Redshift, Amazon Athena, AWS Glue, and data analytics concepts.