FlattenUDTColumn

This property specifies how the connector handles user-defined types (UDT).

  • 1: The connector flattens UDT data into columns. During read and write operations, the subtypes and metadata of the UDT data are retained in the column typing and metadata.
  • When this property is enabled, the following limitations also apply:

    • The connector cannot insert nested collections as VARCHAR data.
    • If a map contains two user-defined types with identical field names (that is, if the key and value of the map are of the same user-defined type), then a column name collision occurs.
    • If a table uses a user-defined type as its primary key, then when you execute an INSERT statement on that table, the fields of the primary key cannnot be NULL.

  • 0: The connector exposes UDT values as string values. The subtypes and metadata of the UDT data are not maintained during read and write operations, and the connector provides only partial support for write operations.
Default Value Data Type Required

0

Integer

No