From the course: Introduction to Amazon Redshift: Data Management Essentials

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

More Redshift features to explore

More Redshift features to explore

- There's so much more I could tell you about Redshift. AWS data exchange allows data providers to upload large data sets that you can subscribe to, and pull directly into your Redshift database, such as TV viewership and census data and stock data. Redshift Spectrum allows you to store raw data in a cheap S3 bucket and to load it into Redshift, and query it only when you need it. Materialized views can speed up the processing of certain queries and are great if you'll always be asking the data warehouse for an update on this quarter sales numbers. And if you need to extend Redshift, and have your queries compute some values, you can extend the standard set of SQL functions using user defined functions and program your own functions. Amazon is still releasing many great features for Redshift, and I expect many more improvements to the service. So dive into your data lakes, and make an impressive data warehouse that'll turn…

Contents