MigrationPolicies

The policies for source data that doesn't fit the destination schema.

incompatibleValuesPolicy

The migration policy for a source value that the destination column's type can't hold. Valid values:

fail - Fails the migration. This is the default.
setNull - Writes null for a value that the destination column's type can't hold. If a column's type in a source object is incompatible with the destination column's type, the column is null for that whole object.

A required column, or a type that migration doesn't support, fails the migration under either value.

Type: String

Valid Values: fail | setNull

Required: No

unmatchedSourceFieldsPolicy

The migration policy for a source field that has no matching column in the destination schema. Valid values:

fail - Fails the migration. This is the default.
drop - Leaves source columns that the destination schema doesn't have out of the destination table, and doesn't migrate source objects outside the AWS Glue table's partition locations.

A destination schema that leaves out a partition column or a field of a struct column fails the migration under either value.

Type: String

Valid Values: fail | drop

Required: No

Contents