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=Flatten). 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 property provides a method in which the data can still be read as a JSON value.

Valid Values

true | false

Behavior

If set to 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 false, the driver exposes documents and arrays embedded within a collection according to the relational view specified by the SchemaFormat property.

Notes

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

Data Source Methods

public Boolean getJsonColumns()

public void setJsonColumns(Boolean)

Default Value

false

Data Type

Boolean