> 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.

# DESC STORAGE VOLUME

DESC STORAGE VOLUME describes a storage volume. This feature is supported from v3.1.

> **CAUTION**
>
> Only users with the USAGE privilege on a specific storage volume can perform this operation.

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

```sql
DESC[RIBE] STORAGE VOLUME <storage_volume_name>

```

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

| **Parameter**         | **Description**                             |
| --------------------- | ------------------------------------------- |
| storage_volume_name | The name of the storage volume to describe. |

## Return value[​](#return-value "Direct link to Return value")

| **Return** | **Description**                                                         |
| ---------- | ----------------------------------------------------------------------- |
| Name       | The name of the storage volume.                                         |
| Type       | The type of the remote storage system. Valid values: `S3` and `AZBLOB`. |
| IsDefault  | Whether the storage volume is the default storage volume.               |
| Location   | The location of the remote storage system.                              |
| Params     | The credential information used to access the remote storage system.    |
| Enabled    | Whether the storage volume is enabled.                                  |
| Comment    | The comment on the storage volume.                                      |

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

Example 1: Describe the storage volume `my_s3_volume`.

```plain
MySQL > DESCRIBE STORAGE VOLUME my_s3_volume\G
*************************** 1. row ***************************
     Name: my_s3_volume
     Type: S3
IsDefault: false
 Location: s3://defaultbucket/test/
   Params: {"aws.s3.access_key":"xxxxxxxxxx","aws.s3.secret_key":"yyyyyyyyyy","aws.s3.endpoint":"https://s3.us-west-2.amazonaws.com","aws.s3.region":"us-west-2","aws.s3.use_instance_profile":"true","aws.s3.use_aws_sdk_default_behavior":"false"}
  Enabled: false
  Comment: 
1 row in set (0.00 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)
* [SET DEFAULT STORAGE VOLUME](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/SET_DEFAULT_STORAGE_VOLUME.md)
* [SHOW STORAGE VOLUMES](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/storage_volume/SHOW_STORAGE_VOLUMES.md)