ColumnEncoding

class aws_cdk.aws_redshift_alpha.ColumnEncoding(value)

Bases: Enum

(experimental) The compression encoding of a column.

See:: https://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html
Stability:: experimental
ExampleMetadata:: fixture=cluster infused

Example:

from aws_cdk.aws_redshift_alpha import ColumnEncoding


Table(self, "Table",
    table_columns=[Column(name="col1", data_type="varchar(4)", encoding=ColumnEncoding.TEXT32K), Column(name="col2", data_type="float", encoding=ColumnEncoding.DELTA32K)
    ],
    cluster=cluster,
    database_name="databaseName"
)

Attributes

AUTO

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

This is the default.

Stability:: experimental

AZ64

(experimental) The column is compressed using the AZ64 algorithm.

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

BYTEDICT

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

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

DELTA

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

This records differences as 1-byte values.

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

DELTA32K

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

This records differences as 2-byte values.

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

LZO

(experimental) The column is compressed using the LZO algorithm.

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

MOSTLY16

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

The compressed storage size is 2 bytes.

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

MOSTLY32

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

The compressed storage size is 4 bytes.

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

MOSTLY8

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

The compressed storage size is 1 byte.

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

RAW

(experimental) The column is not compressed.

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

RUNLENGTH

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

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

TEXT255

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

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

TEXT32K

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

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

ZSTD

(experimental) The column is compressed using the ZSTD algorithm.

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