Redshift Column Compression types.sql

CREATE TABLE Test_Compression_Types
(
  key INTEGER NOT NULL encode raw,
  employee_num CHAR(11) NOT NULL encode lzo,
  employee_type CHAR(1) NOT NULL encode runlength,
  employee_status CHAR(1) NOT NULL encode lzo,
  employee_tier CHAR(1) NOT NULL encode lzo,
  service_flag char(1) NOT NULL encode runlength,
  employee_flag char(1) NOT NULL encode ZSTD,
  account_update_date DATE NOT NULL encode delta32k,
  period_months INTEGER NOT NULL encode bytedict,
  creation_date DATE NOT NULL encode delta32k,
  category char(5) NOT NULL encode bytedict,
  extended_flag CHAR(1) NOT NULL encode runlength,
  business_date DATE NOT NULL encode delta32k,
 address1 varchar(100) NOT NULL encode TEXT32K,
 address2 varchar(100) NOT NULL encode TEXT255,
 mobile_number INTEGER NOT NULL encode MOSTLY16,
 pin SMALLINT NOT NULL encode MOSTLY8
 )
distkey (key);