Subject
2 entries
Amazon Redshift
Bookmarks
The Lazy Analyst's Guide to Amazon Redshift
Periscope Data's practical guide to Amazon Redshift — covering the distribution and sort key mechanics that determine query performance, plus common gotchas for analysts who know SQL but not columnar databases. Still one of the clearest explanations of why Redshift behaves differently from Postgres.
Building Analytics at 500px
A first-person account of building 500px's analytics infrastructure from scratch — Amazon Redshift data warehouse, Luigi ETL, Periscope BI. The 20% evangelism rule and 'don't bake your own ETL' lesson make it one of the most practical early data engineering retrospectives.