enum ColumnEncoding 🔹

Language	Type name
.NET	Amazon.CDK.AWS.Redshift.Alpha.ColumnEncoding
Go	github.com/aws/aws-cdk-go/awscdkredshiftalpha/v2#ColumnEncoding
Java	software.amazon.awscdk.services.redshift.alpha.ColumnEncoding
Python	aws_cdk.aws_redshift_alpha.ColumnEncoding
TypeScript (source)	@aws-cdk/aws-redshift-alpha » ColumnEncoding

The compression encoding of a column.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html

Example

import { ColumnEncoding } from '@aws-cdk/aws-redshift-alpha';

new Table(this, 'Table', {
  tableColumns: [
    { name: 'col1', dataType: 'varchar(4)', encoding: ColumnEncoding.TEXT32K },
    { name: 'col2', dataType: 'float', encoding: ColumnEncoding.DELTA32K },
  ],
  cluster: cluster,
  databaseName: 'databaseName',
});

Members

Name	Description
AUTO 🔹	Amazon Redshift assigns an optimal encoding based on the column data.
RAW 🔹	The column is not compressed.
AZ64 🔹	The column is compressed using the AZ64 algorithm.
BYTEDICT 🔹	The column is compressed using a separate dictionary for each block column value on disk.
DELTA 🔹	The column is compressed based on the difference between values in the column.
DELTA32K 🔹	The column is compressed based on the difference between values in the column.
LZO 🔹	The column is compressed using the LZO algorithm.
MOSTLY8 🔹	The column is compressed to a smaller storage size than the original data type.
MOSTLY16 🔹	The column is compressed to a smaller storage size than the original data type.
MOSTLY32 🔹	The column is compressed to a smaller storage size than the original data type.
RUNLENGTH 🔹	The column is compressed by recording the number of occurrences of each value in the column.
TEXT255 🔹	The column is compressed by recording the first 245 unique words and then using a 1-byte index to represent each word.
TEXT32K 🔹	The column is compressed by recording the first 32K unique words and then using a 2-byte index to represent each word.
ZSTD 🔹	The column is compressed using the ZSTD algorithm.

---

AUTO 🔹

Amazon Redshift assigns an optimal encoding based on the column data.

This is the default.

---

RAW 🔹

The column is not compressed.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Raw_encoding.html

---

AZ64 🔹

The column is compressed using the AZ64 algorithm.

See also: https://docs.aws.amazon.com/redshift/latest/dg/az64-encoding.html

---

BYTEDICT 🔹

The column is compressed using a separate dictionary for each block column value on disk.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Byte_dictionary_encoding.html

---

DELTA 🔹

The column is compressed based on the difference between values in the column.

This records differences as 1-byte values.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Delta_encoding.html

---

DELTA32K 🔹

The column is compressed based on the difference between values in the column.

This records differences as 2-byte values.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Delta_encoding.html

---

LZO 🔹

The column is compressed using the LZO algorithm.

See also: https://docs.aws.amazon.com/redshift/latest/dg/lzo-encoding.html

---

MOSTLY8 🔹

The column is compressed to a smaller storage size than the original data type.

The compressed storage size is 1 byte.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html

---

MOSTLY16 🔹

The column is compressed to a smaller storage size than the original data type.

The compressed storage size is 2 bytes.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html

---

MOSTLY32 🔹

The column is compressed to a smaller storage size than the original data type.

The compressed storage size is 4 bytes.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html

---

RUNLENGTH 🔹

The column is compressed by recording the number of occurrences of each value in the column.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Runlength_encoding.html

---

TEXT255 🔹

The column is compressed by recording the first 245 unique words and then using a 1-byte index to represent each word.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Text255_encoding.html

---

TEXT32K 🔹

The column is compressed by recording the first 32K unique words and then using a 2-byte index to represent each word.

See also: https://docs.aws.amazon.com/redshift/latest/dg/c_Text255_encoding.html

---

ZSTD 🔹

The column is compressed using the ZSTD algorithm.

See also: https://docs.aws.amazon.com/redshift/latest/dg/zstd-encoding.html