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