Excel Add-In for MongoDB

Build 24.0.9060

DataModel

By default, the provider will not automatically discover the metadata for a child table as its own distinct table. To enable this functionality, set DataModel to Relational .

Possible Values

DOCUMENT, RELATIONAL

Data Type

string

Default Value

"DOCUMENT"

Remarks

When setting DataModel to Relational, the discovery of child tables extends to root level elements and those found within top-level array elements. Additionally, the provider exposes _id and parent_id columns to enable JOIN operations between parent and child tables. The _id column acts as a primary key for the flattened table, while the parent_id column identifies the parent document.

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