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