Excel Add-In for Azure Cosmos DB

Build 24.0.9060

TypeDetectionScheme

Comma-separated options for how the provider will scan the data to determine the fields and datatypes in each document collection.

Data Type

string

Default Value

"RowScan,Recent"

Remarks

NoneSetting TypeDetectionScheme to None will return all columns as a string type. Cannot be combined with other options.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. Can be used with Recent.
RecentSetting TypeDetectionScheme to Recent will determine whether RowScan is executed on the most recent documents in the collection. Can be used with RowScan.
RawValueSetting TypeDetectionScheme to RawValue will push each document as single aggregate on a column named JsonData, along with its resource identifier on the separate Primary Key column. Cannot be combined with other options.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060