UNDROP EXTERNAL VOLUME¶

Restores the most recent version of a dropped external volume.

See also:

CREATE EXTERNAL VOLUME , ALTER EXTERNAL VOLUME, DESCRIBE EXTERNAL VOLUME , SHOW EXTERNAL VOLUMES , DROP EXTERNAL VOLUME

Syntax¶

UNDROP EXTERNAL VOLUME <name>
Copy

Parameters¶

name

Specifies the identifier for the external volume to restore.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

Usage notes¶

  • If an external volume with the same name already exists, the UNDROP command returns an error.

  • UNDROP relies on the Snowflake Time Travel feature. An object can be restored only if the object was deleted within the Data retention period. The default value is 24 hours.

Examples¶

Restore the most recent version of a dropped external volume named my_external_volume:

UNDROP EXTERNAL VOLUME my_external_volume;
Copy