For this proof of concept, we are going to keep the implementation simple and not worry about schemas and views yet. Clearly, when you are ready to work out your production database schema, you will need to give some thought to those details. This point also brings me to an "early adoption issues" story. Don't worry, this story has a happy ending too. However, this little trick lead to me losing my data and learning about cluster restores early in my testing. My initial configuration, to get things up and running for a proof of concept at the lowest cost, was a single node extra-large cluster. As I saw schemas were supported, I thought, why not go through the handful of extra steps to create the schema and build my target configuration. ...

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.