Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Will star schema benefit in redshift?

I'm new to redshift and I have a basic question on redshift's compatibility with star schema.

In general , will star schema benefit in redshift ?

Specific question ,

"KEY" distribution method in redshift supports distribution based on just one key , will it help in case of star schema where the fact table's key is combination of foreign keys.

Thanks Sridhar

like image 791
user3279189 Avatar asked Mar 18 '14 21:03

user3279189


1 Answers

Redshift works very well with star schemas, but you must do some optimizations. See their whitepaper, http://aws.amazon.com/articles/8341516668711341, for some good guidelines.

like image 155
mike_pdb Avatar answered Oct 21 '22 08:10

mike_pdb