In order to create an ARRAY data type or to run array functions, users must have either the UDTTYPE or UDTMETHOD privilege on the SYSUDTLIB database.

GRANT UDTMETHOD ON SYSUDTLIB TO <USER>
GRANT SELECT ON UDTInfo TO <USER>

Configuration options for arrays enable users to specify element types and array length to work within Teradata's 64KB array size limit. This is necessary because Teradata uses structured UDT-based arrays with predefined options, while PySpark employs dynamic allocation without size constraints.

default_array_size is a configuration option used to set the array size irrespective of type, defaulted to 100. This affects the maximum number of elements that can be stored in array columns.

Usage Example

>>> from teradatamlspk import TeradataSession
>>> session = TeradataSession.builder.getOrCreate(...)
# Set the configuration option to store only 10 elements across the session.
>>> session.conf.set("default_array_size", 10)

Configuration Options