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

Data Type

string

Default Value

"100"

Remarks

This property applies when TypeDetectionScheme is set to RowScan. The provider 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 provider to scan the entire file.

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