SYNC BOTTOMLESS DATABASE

Synchronizes any currently committed data in the database with the remote object storage.

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 either the SUPER or 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;

Last modified: November 3, 2022

Was this article helpful?