Specifies the maximum number of rows that can be generated from a single flattened element.

Data Type

int

Default Value

250000

Remarks

When flattening large or deeply nested JSON data, the add-in must generate multiple rows for each flattened element. If the number of rows grows excessively, it can cause high memory usage or query failures.

When this property is set, the add-in verifies that the number of rows produced by a single flattened element does not exceed the specified limit. If the expected output exceeds this limit, the query fails and an error is reported instead of attempting to generate all rows.

This property is useful for preventing excessive memory consumption and ensuring predictable performance when flattening complex JSON documents.