Cmdlets for JSON

Build 25.0.9539

TypeDetectionScheme Parameter (Connect-JSON Cmdlet)

Specifies how the provider determines the data types of columns in the generated schema.

Syntax

Connect-JSON -TypeDetectionScheme string

Possible Values

None, RowScan

Data Type

cstr

Default Value

"RowScan"

Remarks

When this property is set to None, all columns are returned as string values without data type inference.

When this property is set to RowScan, the cmdlet scans a sample of rows to heuristically infer column data types. The number of rows scanned is determined by the RowScanDepth property.

This property is useful for controlling the method of type inference during schema discovery.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539