Knowledge Drop

What column compression encodings are used for PDTs in Redshift?

Userlevel 5
  • Looker Staff
  • 173 replies

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


This content is subject to limited support.                



0 replies

Be the first to reply!