# CREATE SNAPSHOT

## Syntax Description

The `CREATE SNAPSHOT` command is used to create snapshots. An instance can only create snapshots for this instance, and the snapshots created are only visible to this instance.

## Syntax Structure

```sql
CREATE SNAPSHOT snapshot_name FOR ACCOUNT account_name
```

## Example

```text
--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)
```

## limit

- Currently, only instance-level snapshots are supported, and cluster-level, database-level, and table-level snapshots are not supported.