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 component 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 component 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 component-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.