ALTER ORGANIZATION ACCOUNT¶

Modifies the properties of an existing organization account.

See also:

CREATE ORGANIZATION ACCOUNT, SHOW ORGANIZATION ACCOUNTS

Syntax¶

ALTER ORGANIZATION ACCOUNT SET { [ accountParams ] | [ objectParams ] | [ sessionParams ] }

ALTER ORGANIZATION ACCOUNT UNSET <param_name> [ , ... ]

ALTER ORGANIZATION ACCOUNT SET RESOURCE_MONITOR = <monitor_name>

ALTER ORGANIZATION ACCOUNT SET { PASSWORD | SESSION } POLICY <policy_name>

ALTER ORGANIZATION ACCOUNT UNSET { PASSWORD | SESSION } POLICY

ALTER ORGANIZATION ACCOUNT SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]

ALTER ORGANIZATION ACCOUNT UNSET TAG <tag_name> [ , <tag_name> ... ]

ALTER ORGANIZATION ACCOUNT <name> RENAME TO <new_name> [ SAVE_OLD_URL = { TRUE | FALSE } ]

ALTER ORGANIZATION ACCOUNT <name> DROP OLD URL
Copy

Note

The accountParams, objectParams, and sessionParams for the organization account are identical to the parameters for other accounts. See ALTER ACCOUNT for their syntax.

Parameters¶

name

Specifies the identifier for the organization account to alter.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

SET ...

Specifies one (or more) account, session, and object parameters to set for your organization account (separated by blank spaces, commas, or new lines):

  • Account parameters cannot be changed by any other users.

  • Session and object parameters set at the account level serve only as defaults and can be changed by other users.

For descriptions of the parameters you can set for your organization account, see Parameters.

UNSET ...

Specifies one (or more) account, session, and object parameters to unset for your account, which resets them to the system defaults.

You can reset multiple properties with a single ALTER statement; however, each property must be separated by a comma. When resetting a property, specify only the name; specifying a value for the property will return an error.

SET RESOURCE_MONITOR resource_monitor_name

Special parameter that specifies the name of the resource monitor used to control all virtual warehouses created in the account.

The organization account is not intended to be heavily used for analytics or other workloads.

{ PASSWORD | SESSION } POLICY policy_name

Specifies the password policy or the session policy to set for the account.

TAG tag_name = 'tag_value' [ , tag_name = 'tag_value' , ... ]

Specifies the tag name and the tag string value.

The tag value is always a string, and the maximum number of characters for the tag value is 256.

For information about specifying tags in a statement, see Tag quotas for objects and columns.

RENAME TO new_name

Changes the name of an organization account to the specified name.

For more details about identifiers, see Identifier requirements.

Organization administrators cannot rename an organization account while they are logged in to it, so they must log in to a different organization account before executing the ALTER ORGANIZATION ACCOUNT command.

SAVE_OLD_URL = { TRUE | FALSE }

Optional parameter used in conjunction with RENAME TO that preserves the account URL used to access Snowflake prior to renaming. By default, Snowflake saves the original URL, which means you can access the organization account with either the old URL or the URL that contains the new account name. When set to FALSE, you must use the new URL to access the organization account.

Default:

TRUE

DROP OLD URL

Removes the original account URL of an organization account that was renamed. Once the old URL is dropped, you must access the organization account with the URL that contains the new account name.

Access Control Requirements¶

Only a user with the GLOBALORGADMIN role can execute this command.

Examples¶

Rename the organization account while allowing users to use either the new or the old account URL to access the account.

ALTER ORGANIZATION ACCOUNT original_acctname RENAME TO new_acctname;
Copy
Language: English