SurplusBytesHandlingAction

class aws_cdk.aws_glue_alpha.SurplusBytesHandlingAction(value, names=None, *, module=None, qualname=None, type=None, start=1, boundary=None)

Bases: Enum

(experimental) Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARBYTE data.

By default, Redshift Spectrum sets the value to null for data that exceeds the width of the column.

See:

https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html#r_CREATE_EXTERNAL_TABLE-parameters - under “TABLE PROPERTIES” > “surplus_bytes_handling”

Stability:

experimental

Attributes

DISABLED

(experimental) Doesn’t perform surplus byte handling.

Stability:

experimental

DROP_ROW

(experimental) Drop all rows that contain data exceeding column width.

Stability:

experimental

FAIL

(experimental) Cancels queries that return data exceeding the column width.

Stability:

experimental

SET_TO_NULL

(experimental) Replaces data that exceeds the column width with null.

Stability:

experimental

TRUNCATE

(experimental) Removes the characters that exceed the maximum number of characters defined for the column.

Stability:

experimental