Encoding Property for Columns
Go Up to Distributing Columns for Amazon Redshift
Amazon Redshift uses a keyword called ENCODE to define the specific compression encoding for a column. the following compression encodings are supported:
- BYTEDICT
- DELTA
- DELTA32K
- LZO
- MOSTLY8
- MOSTLY16
- MOSTLY32
- RAW (no compression)
- RUNLENGTH
- TEXT32K
- ZSTD
In the Column Editor for Redshift tables, under the datatype tab, a dropdown next to the Identity Property section allows you to select the encoding for this property.