UNDROP ACCOUNT

Restores a dropped account that has not yet been permanently deleted (a dropped account that is within its grace period).

To obtain a list of dropped accounts that can be restored, refer to Viewing dropped accounts.

Tip

You can also use the Snowflake REST APIs to perform this operation. For information, see Restore an account (REST endpoint reference).

See also:

CREATE ACCOUNT, DROP ACCOUNT, SHOW ACCOUNTS

Syntax

UNDROP ACCOUNT <name>
Copy

Parameters

name

Specifies the name of the account being restored. As an example, if the full account identifier is myorg-account123, then specify account123 as the name.

The legacy account locator cannot be used to identify the account.

Usage notes

Only organization administrators (i.e. a user with the ORGADMIN role) can execute the command.

Example

To restore the dropped account myaccount123, which was still within the grace period, enter:

UNDROP ACCOUNT myaccount123;
Copy
Language: English