Attribute

JSONColumns (jcs)

Purpose

Determines whether the driver exposes documents and arrays embedded within a collection as JSON formatted fields, in addition to exposing individual collection and array elements as fields, when mapping to a flattened view (SchemaFormat=1). Exposing documents and arrays as JSON values can make certain operations more convenient, such as when tools use this data as a single object for communication. In addition, in rare instances where variations in data structure might cause this data to not be sampled, enabling this option provides a method in which the data can still be read as a JSON value.

Valid Values

0 | 1

Behavior

If set to 1 (true), the driver exposes documents and arrays embedded within a collection as JSON formatted fields. In addition, the individual collections and arrays are also exposed as fields in accordance to the flattened view.

If set to 0 (false), the driver exposes documents and arrays embedded within a collection according to the relational view specified by the Schema Format (SchemaFormat) option.

Notes

  • Querying JSON values can be an expensive operation that could negatively impact performance; therefore, you should only query JSON values when necessary.

Default Value

0 (false)