What column compression encodings are used for PDTs in Redshift?

[sam8]

Knowledge Drop

Last tested: Sep 12, 2019
 

Since we use "CREATE TABLE AS" for our PDTs, these Redshift rules apply.

TLDR:

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

This content is subject to limited support.