Reader accounts: DROP ACCOUNT command not supported

Attention

This behavior change is in the 2023_06 bundle.

For the current status of the bundle, refer to Bundle History.

The behavior of a reader account is as follows:

Previously:

When you use the DROP ACCOUNT command to remove a reader account from your account, Snowflake returns a successful status message but the reader account is not dropped.

Currently:

Snowflake returns an error message if you try to use the DROP ACCOUNT command to remove a reader account from your account.

DROP ACCOUNT reader_acct1;
Copy
Drop account command not allowed for managed accounts. Use command drop managed account. For more details visit https://docs.snowflake.com/en/sql-reference/sql/drop-managed-account.

Instead, use the DROP MANAGED ACCOUNT command to remove a reader account from your account.

For details, see Dropping a reader account.

Ref: 1271