SampleCollections

Key Name	Default Value	Required
SampleCollections	1	No

Description

This option specifies whether the connector samples collections when generating an in-memory schema map with the Enable JSON Read/Write Mode UseJsonColumn property enabled.

• 1: The connector samples collections.
• 0: The connector does not sample collections. If the Enable JSON Read/Write Mode UseJsonColumn property is enabled, a table is generated for each encountered collection, containg two columns: _id (VARCHAR) and DocumentAsJson (VARCHAR). Virtual tables are not created in this case.

Related topics

• Configuration Options Having Only Key Names
• Advanced Connector Configuration Options
• Using a Connection String
• Enable JSON Read/Write Mode