Specifies the number of rows that the provider scans when dynamically determining table columns.

Syntax

Connect-CSV -RowScanDepth string

Data Type

cstr

Default Value

"100"

Remarks

This property applies when TypeDetectionScheme is set to RowScan. The cmdlet scans the specified number of rows to infer column names and data types when a schema definition file is not available, such as when using GenerateSchemaFiles.

Higher values increase detection accuracy, but may lengthen processing time. Setting this property to 0 instructs the cmdlet to scan the entire file.

This property is useful for improving schema accuracy when files contain variable data patterns across rows.