Skip to main content
Updates the configuration of the specified account. For more information, see Managing accounts.

​
ALTER ACCOUNT RENAME TO

Renames an account.

​
Syntax

ALTER ACCOUNT [IF EXISTS] <account_name> RENAME TO <new_account_name>;

​
Parameters

ParameterDescription
<account_name>The name of the account to be altered.
<new_account_name>The new name for the account. The account name must start and end with an alphabetic character and cannot contain spaces or special characters except for hyphens (-).

​
Example

The following command will rename the “dev” account to “staging”. 
ALTER ACCOUNT dev RENAME TO staging;

​
ALTER ACCOUNT OWNER TO

Changes the owner of an account. You can view the current owner in the account_owner column of the information_schema.accounts view. For more information, see ownership.

​
Syntax

ALTER ACCOUNT [IF EXISTS] <account_name> OWNER TO <identity>

​
Parameters

ParameterDescription
<account_name>The name of the account to change the owner of.
<identity>The new owner of the account, which can be the name of a login or service account.

​
Example

The following command will set account “dev” owner to “alice@acme.com”. 
ALTER ACCOUNT "dev" OWNER TO "alice@acme.com";

​
ALTER ACCOUNT SET LLM_TOKEN_BUDGET

Sets the LLM token budget for the account, which limits the total number of tokens that can be processed daily by AI functions such as AWS_BEDROCK_AI_QUERY. By default, accounts are created with a zero token budget. You can view the current budget and usage in the information_schema.quotas view.

​
Syntax

ALTER ACCOUNT [IF EXISTS] <account_name> SET (LLM_TOKEN_BUDGET = <new_budget>)

​
Parameters

ParameterDescription
<account_name>The name of the account to be altered.
<new_budget>The new token budget for the account.

​
Example

The following command will set the token budget for account “dev” to 10000 tokens. 
ALTER ACCOUNT "dev" SET (LLM_TOKEN_BUDGET = 10000);