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

Data Type

string

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 add-in.