All insights from Redshift academic paper: Amazon Redshift re-invented in 2022 - https://blog.det.life/i-spent-another-8-hours-understanding-the-design-of-amazon-redshift-heres-what-i-found-85c31a59fd19