FlattenArrays
Specifies how many elements to return from nested arrays when TypeDetectionScheme is set to SchemaRegistry.
Data Type
string
Default Value
"0"
Remarks
When TypeDetectionScheme is set to SchemaRegistry, nested arrays are not exposed by default.
Set this property to expose a specific number of elements from a nested array as individual columns. The driver creates one column per element, starting with index 0.
For example, consider the following array:
["FLOW-MATIC","LISP","COBOL"]
If this property is set to 1, the driver exposes only the element at index 0:
| Column Name | Column Value |
| languages.0 | FLOW-MATIC |
If this property is set to 0, no elements of nested arrays are exposed as columns.