Syntax

SYNC BOTTOMLESS DATABASE <database_name>;

Remarks

• This command applies only to universal storage databases.

• You must specify the name of the database to synchronize in the command.

• You must have BACKUP privilege to run this command.

• This command causes implicit commits. See COMMIT for more information.

• This command can be run on the master aggregator, or on the child aggregators provided DDL forwarding is enabled. DDL forwarding is enabled by default.

• SingleStore recommends using this command to flush all the data to remote object storage before a large or critical operation.

Example

SYNC BOTTOMLESS DATABASE db01;