Amazon Redshift Spectrum: Quickly Query Exabytes of Data in S3 – June 2017 AWS Online Tech Talks – #AWS

Learning Objectives:
– Learn about Redshift Spectrum, a new feature that allows you to run Redshift queries directly against your data in Amazon S3 – Understand common use cases for Redshift Spectrum
– Identify strategies for improving performance and saving costs when querying your data in Amazon S3

Amazon Redshift Spectrum is a new feature that extends Amazon Redshift’s analytics capabilities beyond the data stored in your data warehouse to also query your data in Amazon S3. You can use Amazon Redshift and your existing business intelligence tools to run SQL queries against exabytes of data.

In this session, we will show you how you can easily start querying your data stored in Amazon S3 with Redshift Spectrum. You can run Amazon Redshift queries on Amazon S3 data on its own, or you can run queries that join together data in S3 with data already in your Redshift data warehouse. We will highlight technical details of query execution and implementation of Redshift Spectrum. We will talk about supported queries, data formats, and strategies to save cost by compressing or transforming your data into a columnar format.

About The Author
- Launched in 2006, Amazon Web Services offers a robust, fully featured technology infrastructure platform in the cloud comprised of a broad set of compute, storage, database, analytics, application, and deployment services from data center locations in the U.S., Australia, Brazil, China, Germany, Ireland, Japan, and Singapore. More than a million customers, including fast-growing startups, large enterprises, and government agencies across 190 countries, rely on AWS services to innovate quickly, lower IT costs and scale applications globally. To learn more about AWS, visit

Tell us what you think...