The number of rows to scan when dynamically determining columns for the table.

Syntax

Connect-JSON -RowScanDepth string

Data Type

cstr

Default Value

"100"

Remarks

The number of rows (objects) to scan when dynamically determining columns for the table -- the row scan follows nested objects, counting 1 object array as 1 row. Columns are dynamically determined when a schema (RSD) file is not available for the table, such as when using GenerateSchemaFiles.

Higher values will result in a longer request, but will be more accurate.

Setting this value to 0 (zero) will parse the entire JSON document.

See Also

• Automatic Schema Discovery: Shows how to configure column discovery using RowScanDepth, FlattenObjects, and FlattenArrays.
• Modeling JSON Data: Introduces the different options for modeling data in the cmdlet.