DROP ACCOUNTΒΆ

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

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:

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

Alternate interfacesΒΆ

Language: English