When an account is dropped, it enters a specified grace period (between 3 and 90 days) before it is removed. During the grace period, a user with the organization administrator role (ORGADMIN) can undrop, or restore, a Snowflake account to prevent it from being permanently deleted. This allows the ORGADMIN to restore accounts that may have been accidentally flagged for removal.
Undropping an account also unlocks it, allowing users to access the account as if it had never been dropped.
To undrop an account, the ORGADMIN can run the following commands using Snowsight or SQL:
Snowsight
- Select Admin » Accounts.
- Select the Dropped Accounts tab.
- Find the account, and select … » Undrop Account.
- Select Undrop Account.
SQL
Use the UNDROP ACCOUNT command.
USE ROLE ORGADMIN;
UNDROP ACCOUNT <account_name>
You can find additional information on dropped accounts, including how to view a list of currently dropped accounts, in our Documentation.
