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

データ型

string

デフォルト値

"100"

解説

When this property is set, the 本製品 scans the specified number of rows (objects) in the JSON document to detect columns and data types. The scan follows nested objects, counting each object array as a single row.

If no schema (RSD) file is available for a table, columns are determined dynamically using this scan. This behavior applies when using GenerateSchemaFiles or when a schema file is not present.

Higher values improve detection accuracy but may increase request time. Setting this property to 0 causes the 本製品 to parse the entire JSON document.

This property is useful for controlling the trade-off between schema detection accuracy and query performance when parsing JSON data.

See Also

• 自動スキーマ検出: Shows how to configure column discovery using RowScanDepth, FlattenObjects, and FlattenArrays.
• JSON データのモデリング: Introduces the different options for modeling data in the 本製品.