The maximum number of rows that can result from a single flattened element.

Syntax

Connect-JSON -FlattenRowLimit int

Data Type

int

Default Value

250000

Remarks

In some cases the FlattenedDocuments DataModel may try to output more rows than intended, either because of the shape of the data or the table identification options. If the number of rows to be generated is large enough this can lead to memory issues as the cmdlet has to store all the generated rows in memory before returning them.

To avoid this the cmdlet will check that the number of rows to be output does not exceed this limit (250000 by default). If the cmdlet would output more rows than this for a single flattened element it will instead fail the query and report an error.