Docs Menu
Docs Home
BI Connector

Resample Schema Data with "FLUSH SAMPLE"

On this page

  • Overview

When the mongosqld process starts it creates a schema, either from a schema file or by sampling data from a MongoDB instance. If the data in your MongoDB instance changes shape significantly with new fields or collections, you may wish to regenerate the schema BI Connector uses. You can regenerate the schema either by restarting mongosqld or by issuing the FLUSH SAMPLE command from within the MySQL shell.

By default, mongosqld does not automatically resample data after generating the schema. Specify the --schemaRefreshIntervalSecs option to direct mongosqld to automatically resample the data and regenerate the schema on a fixed schedule.


To use the FLUSH SAMPLE command, you must have the insert and update privileges. To learn more, see User Authorization Model. You can't use the FLUSH SAMPLE command if mongosqld starts with a schema file via the --schema option.


See also:

← Load a Schema from a DRDL File

On this page