Amazon Redshift Spectrum: Quickly Query Exabytes of Data in S3 – June 2017 AWS Online Tech Talks – #AWS
– 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.