DROP ACCOUNT

Drops an account, which initiates the process of deleting the account.

Tip

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

See also:

CREATE ACCOUNT, SHOW ACCOUNTS, UNDROP ACCOUNT

Syntax

DROP ACCOUNT [ IF EXISTS ] <name> GRACE_PERIOD_IN_DAYS = <integer>
Copy

Parameters

name

Specifies the name of the account being dropped. As an example, if the full account identifier is myorg-account123, then specify account123 as the name. If you do not know the account name, execute the SHOW ACCOUNTS command, and find the name in the account_name column.

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

GRACE_PERIOD_IN_DAYS = integer

Specifies the number of days during which the account can be restored (“undropped”). The minimum is 3 days and the maximum is 90 days.

Usage notes

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

  • The organization administrator cannot drop the account they are currently logged in to.

Example

To drop an account my_account and allow a 14-day grace period for restoring the account, enter:

DROP ACCOUNT my_account GRACE_PERIOD_IN_DAYS = 14;
Copy
Language: English