> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.

# SET DEFAULT STORAGE VOLUME

SET DEFAULT STORAGE VOLUME sets a storage volume as the default storage volume. After creating a storage volume for an external data source, you can set it as the default storage volume of your StarRocks cluster. This feature is supported from v3.1.

> **CAUTION**
>
> * Only users with the ALTER privilege on a specific storage volume can perform this operation.
> * The default storage volume cannot be dropped or disabled.
> * You must set the default storage volume for a shared-data StarRocks cluster because StarRocks stores the system statistics information in the default storage volume.

## Syntax[​](#syntax "Direct link to Syntax")

```sql
SET <storage_volume_name> AS DEFAULT STORAGE VOLUME

```

## Parameters[​](#parameters "Direct link to Parameters")

| **Parameter**         | **Description**                                                         |
| --------------------- | ----------------------------------------------------------------------- |
| storage_volume_name | The name of the storage volume to be set as the default storage volume. |

## Examples[​](#examples "Direct link to Examples")

Example 1: Set the storage volume `my_s3_volume` as the default storage volume.

```sql
MySQL > SET my_s3_volume AS DEFAULT STORAGE VOLUME;
Query OK, 0 rows affected (0.01 sec)

```

## Relevant SQL statements[​](#relevant-sql-statements "Direct link to Relevant SQL statements")

* [CREATE STORAGE VOLUME](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/CREATE_STORAGE_VOLUME.md)
* [ALTER STORAGE VOLUME](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/ALTER_STORAGE_VOLUME.md)
* [DROP STORAGE VOLUME](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/DROP_STORAGE_VOLUME.md)
* [DESC STORAGE VOLUME](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/DESC_STORAGE_VOLUME.md)
* [SHOW STORAGE VOLUMES](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/SHOW_STORAGE_VOLUMES.md)