A list of mappings from built-in MongoDB document field names to the names you want to use when exposing those columns in the driver's SQL schema.

Data Type

string

Default Value

""

Remarks

When the add-in encounters columns that share a name with one of the the standard built-in columns, you may encounter a "column names must be unique" error.

To avoid this error, you can use this connection property to change the name the add-in uses for each built-in MongoDB column in the metadata of its SQL schema.

The remappable built-in columns are "_index", "P_id", "_id" and "parent_id".

Provide the mappings in the form <built-in name>=<new custom name>, and separate each mapping with a comma.

For example:

_index=BuiltInIndex,P_id=Root_Id,_id=My_Id,parent_id=My_Parent_id

To hide all add-in-generated relational linking columns from external metadata and wildcard projections, set this property to exactly nil. The entire property value must be nil; it cannot be combined with column mappings.