View the original community article here
Last tested: Sep 12, 2019
Since we use "CREATE TABLE AS" for our PDTs, these Redshift rules apply.
Redshift automatically analyzes the tables and determines what it thinks is the best compression per column. We build PDT using CTAS (create table as select), and Redshift does not support specifying compression as part of the CTAS statement