SHOW SNAPSHOTS

Syntax Description

SHOW SNAPSHOTS Returns the information about the snapshot created under the current tenant, including the snapshot name, creation timestamp (UTC time), snapshot level, tenant name, database name, and table name.

Syntax Structure

> SHOW SNAPSHOTS [WHERE expr]

Example

--Execute under instance 585b49fc_852b_4bd1_b6d1_d64bc1d8xxxx
create snapshot sp1 for account `585b49fc_852b_4bd1_b6d1_d64bc1d8d485`;

mysql> show snapshots;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| SNAPSHOT_NAME | TIMESTAMP | SNAPSHOT_LEVEL | ACCOUNT_NAME | DATABASE_NAME | TABLE_NAME |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| sp1 | 2024-07-09 06:34:09.381035637 | account | 585b49fc_852b_4bd1_b6d1_d64bc1d8xxxx | | |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.16 sec)