Knowledge Drop

What column compression encodings are used for PDTs in Redshift?

  • 7 July 2021
  • 0 replies
  • 18 views

Userlevel 5
Badge
  • New Member
  • 168 replies

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.                

 

 


0 replies

Be the first to reply!

Reply