Last month we hosted an AWS Redshift meetup group which went really well, we took advantage of the AWS Summit and had Russell Nash fly down to Wellington just to run an architecture session, the attendees enjoyed the open and responsive whiteboard style of discussion driven by their questions.
If you are Wellington based you can join our meetup (see this post for more details) and if you are Auckland based watch this space as we are working with other AWS partners to start a Big Data on AWS community in Auckland encompassing Redshift.
Redshift Reading Resources
AWS provide a wealth of resources ranging from getting started guides through to detailed technical guides. Russell sent through these links after our meetup event to provide further insight:
Link to the Redshift Getting Started Guide:
Link to the Redshift User Guide:
A specific topic of discussion was Optimizing Star Schemas:
For best practices, see the following documentation in the Amazon Redshift Database Developer Guide:
- Best practices for loading data
- Best practices for designing tables
- Tuning query performance
- Loading tables with automatic compression
- Increasing the available memory
If you are a Tableau front end customer this whitepaper will also be of interest:
New to AWS Redshift? we have a post that provides you with A Brief Introduction to Amazon Redshift for the non-techo reader.
Redshift is a cornerstone of our MagnumBI Private Cloud BI platform, we have thoroughly enjoyed our experience with AWS and Redshift so far and are very happy to share what we have learned. Enjoy, Vic.