O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Schemas

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required