SurplusCharHandlingAction

class aws_cdk.aws_glue.SurplusCharHandlingAction(*values)

Bases: Enum

Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARCHAR, CHAR, or string 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_char_handling”

Attributes

DISABLED

Doesn’t perform surplus character handling.

DROP_ROW

Replaces each value in the row with null.

FAIL

Cancels queries that return data exceeding the column width.

SET_TO_NULL

Replaces data that exceeds the column width with null.

TRUNCATE

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