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
In addition to SQL, you can also use other interfaces, such as Snowflake REST APIs, Snowflake Python APIs, and Snowflake CLI. See Alternate interfaces.
- See also:
SyntaxΒΆ
UNDROP ACCOUNT <name>
ParametersΒΆ
name
Specifies the name of the account being restored. As an example, if the full account identifier is
myorg-account123
, then specifyaccount123
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;
Alternate interfacesΒΆ
Snowflake REST APIs
Restore an account endpoint
Snowflake Python APIs
Snowflake CLI
Not supported