Class ColumnEncoding

(experimental) The compression encoding of a column.

Inheritance

System.Object

ColumnEncoding

Namespace: Amazon.CDK.AWS.Redshift.Alpha

Assembly: Amazon.CDK.AWS.Redshift.Alpha.dll

Syntax (csharp)

public sealed class ColumnEncoding : Enum

Syntax (vb)

Public NotInheritable Class ColumnEncoding
    Inherits

     Enum

Remarks

Stability: Experimental

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

ExampleMetadata: fixture=cluster infused

Examples

using Amazon.CDK.AWS.Redshift.Alpha;


new Table(this, "Table", new TableProps {
    TableColumns = new [] { new Column { Name = "col1", DataType = "varchar(4)", Encoding = ColumnEncoding.TEXT32K }, new Column { Name = "col2", DataType = "float", Encoding = ColumnEncoding.DELTA32K } },
    Cluster = cluster,
    DatabaseName = "databaseName"
});

Synopsis

Fields

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

Fields

AUTO

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

public const ColumnEncoding AUTO

Field Value

Type	Description
ColumnEncoding

Remarks

This is the default.

Stability: Experimental

AZ64

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

public const ColumnEncoding AZ64

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

BYTEDICT

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

public const ColumnEncoding BYTEDICT

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

DELTA

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

public const ColumnEncoding DELTA

Field Value

Type	Description
ColumnEncoding

Remarks

This records differences as 1-byte values.

Stability: Experimental

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

DELTA32K

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

public const ColumnEncoding DELTA32K

Field Value

Type	Description
ColumnEncoding

Remarks

This records differences as 2-byte values.

Stability: Experimental

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

LZO

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

public const ColumnEncoding LZO

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

MOSTLY16

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

public const ColumnEncoding MOSTLY16

Field Value

Type	Description
ColumnEncoding

Remarks

The compressed storage size is 2 bytes.

Stability: Experimental

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

MOSTLY32

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

public const ColumnEncoding MOSTLY32

Field Value

Type	Description
ColumnEncoding

Remarks

The compressed storage size is 4 bytes.

Stability: Experimental

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

MOSTLY8

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

public const ColumnEncoding MOSTLY8

Field Value

Type	Description
ColumnEncoding

Remarks

The compressed storage size is 1 byte.

Stability: Experimental

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

RAW

(experimental) The column is not compressed.

public const ColumnEncoding RAW

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

RUNLENGTH

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

public const ColumnEncoding RUNLENGTH

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

TEXT255

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

public const ColumnEncoding TEXT255

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

TEXT32K

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

public const ColumnEncoding TEXT32K

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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

value__

public int value__

Field Value

Type	Description
System.Int32

ZSTD

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

public const ColumnEncoding ZSTD

Field Value

Type	Description
ColumnEncoding

Remarks

Stability: Experimental

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