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;
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