SHOW EXTERNAL VOLUMES

Lists the external volumes in your account for which you have access privileges.

The output returns external volume metadata and properties.

See also:

CREATE EXTERNAL VOLUME , DROP EXTERNAL VOLUME , ALTER EXTERNAL VOLUME , DESCRIBE EXTERNAL VOLUME

Syntax

SHOW EXTERNAL VOLUMES [ LIKE '<pattern>' ]
Copy

Parameters

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

Access control requirements

A role used to execute this SQL command must have the following privileges at a minimum:

Privilege

Object

Notes

USAGE

External volume

To see a particular external volume in the output for SHOW EXTERNAL VOLUMES, a role must have the USAGE privilege on that external volume.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes

  • The command does not require a running warehouse to execute.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Output

The command output provides table properties and metadata in the following columns:

Column

Description

name

Name of the external volume.

allow_writes

Signifies whether Snowflake can write files to the storage location(s).

comment

Comment for the external volume.

Examples

Show all external volumes:

SHOW EXTERNAL VOLUMES;
Copy

Show all the external volumes whose name starts with aws that you have privileges to view:

SHOW EXTERNAL VOLUMES LIKE 'aws%';
Copy