VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping
SHOW SNAPSHOT
Description
This statement is used to view backups that already exist in the repository.
Syntax
SHOW SNAPSHOT ON `<repo_name>`
[WHERE SNAPSHOT = "<snapshot_name>" [AND TIMESTAMP = "<backup_timestamp>"]];
Parameters
1.<repo_name>
Back up the selected repository name.
2.<snapshot_name>
Backup name.
3.<backup_timestamp>
Backup timestamp.
Return Value
| Column | Description |
|---|---|
| Snapshot | The name of the backup |
| Timestamp | corresponds to the time version of the backup |
| Status | corresponds to the time version of the backup |
| Database | The name of the database to which the backup data originally belonged |
| Details | In the form of Json, the data directory and file structure of the entire backup are displayed |
Example
- View the existing backups in the repository example_repo
SHOW SNAPSHOT ON example_repo;
- View only the backup named backup1 in the repository example_repo:
SHOW SNAPSHOT ON example_repo WHERE SNAPSHOT = "backup1";
- View the details of the backup named backup1 in the warehouse example_repo with the time version "2018-05-05-15-34-26":
SHOW SNAPSHOT ON example_repo WHERE SNAPSHOT = "backup1" AND TIMESTAMP = "2018-05-05-15-34-26";