One of the key things that cloud computing in general has brought to the industry is the elastic capacity of being able to allocate additional resources as it becomes necessary, and again shrink that capacity when it is no longer needed. There are a couple of points to understand how this works for Redshift. In general, this is a powerful and inexpensive tool to have at your disposal. Depending on your daily workload, for an enterprise data warehouse, you may not have a tremendous need for elastic capacity on a periodic basis. Personally, I work in an environment that will require a much higher (computing) capacity two times a year. With Redshift, you can size up to as many nodes as necessary with no changes to your load processes, query ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.