I found this white paper helpful when thinking about Redshift schema design for Looker. Unfortunately, you have to provide an email address to get it.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.