From the course: Amazon Web Services: Data Analytics

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Query Redshift Spectrum

Query Redshift Spectrum - Amazon Web Services (AWS) Tutorial

From the course: Amazon Web Services: Data Analytics

Start my 1-month free trial

Query Redshift Spectrum

“

- [Instructor] So, a new service that we're going to take a minute to discuss is something called Redshift Spectrum. This is interesting in it's implementation. In the previous movie, we looked at working with a very large table in our fact table, our load orders. We had millions of rows in it. In traditional data warehousing, in order to make tables of that size more manageable, they were commonly partitioned or split into smaller tables which then would have to be rejoined. Not only is this inefficient, it also adds to the management overhead. So, what Redshift Spectrum does is it allows for a new kind of partitioning strategy. Rather than creating separate tables and keeping the size of the Redshift Cluster so large, you can now move the archive tables, or the archive sections of the table, into the much cheaper, much easier to use S3 blob storage. So, you can see conceptually you have N number of Redshift clusters, or you have what's called your warm or your hot data warehouse…

Contents