Creates a new organization account.
Syntax¶CREATE ORGANIZATION ACCOUNT <name>
ADMIN_NAME = <string>
{ ADMIN_PASSWORD = '<string_literal>' | ADMIN_RSA_PUBLIC_KEY = <string> }
[ FIRST_NAME = <string> ]
[ LAST_NAME = <string> ]
EMAIL = '<string>'
[ MUST_CHANGE_PASSWORD = { TRUE | FALSE } ]
EDITION = { ENTERPRISE | BUSINESS_CRITICAL }
[ REGION_GROUP = <region_group_id> ]
[ REGION = <snowflake_region_id> ]
[ COMMENT = '<string_literal>' ]
Copy
Required Parameters¶name
Specifies the identifier (that is, name) for the organization account. It must conform to the following:
Must be unique within an organization, regardless of which Snowflake Region the organization account is in.
Must start with an alphabetic character and cannot contain spaces or special characters except for underscores (_).
ADMIN_NAME = string
Login name of the initial administrative user of the organization account. A new user is created in the new organization account with this name and password and granted the GLOBALORGADMIN role in the organization account.
A login name can be any string consisting of letters, numbers, and underscores. Login names are always case-insensitive.
ADMIN_PASSWORD = 'string_literal'
Password for the initial administrative user of the organization account. The password for the user must be enclosed in single or double quotes.
Optional if the ADMIN_RSA_PUBLIC_KEY parameter is specified.
For more information about passwords in Snowflake, see Snowflake-provided password policy.
ADMIN_RSA_PUBLIC_KEY = string
Assigns a public key to the initial administrative user of the organization account in order to implement key pair authentication for the user.
Optional if the ADMIN_PASSWORD parameter is specified.
EMAIL = 'string_literal'
Email address of the initial administrative user of the organization account. This email address is used to send any notifications about the organization account.
EDITION = ENTERPRISE | BUSINESS_CRITICAL
Snowflake Edition of the organization account.
FIRST_NAME = string , . LAST_NAME = string
First and last name of the initial administrative user of the organization account.
Default: NULL
MUST_CHANGE_PASSWORD = TRUE | FALSE
Specifies whether the new user created to administer the organization is forced to change their password upon first login into the organization account.
Default: FALSE
REGION_GROUP = region_group_id
ID of the region group where the organization account is created. To retrieve the region group ID for existing accounts in your organization, execute the SHOW REGIONS command. For information about when you might need to specify region group, see Region groups.
Default: Current region group.
REGION = snowflake_region_id
Snowflake Region ID of the region where the organization account is created. If no value is provided, Snowflake creates the organization account in the same Snowflake Region as the current account (that is, the account in which the CREATE ORGANIZATION ACCOUNT statement is executed.)
To obtain a list of the regions that are available for an organization, execute the SHOW REGIONS command.
Default: Current Snowflake Region.
COMMENT = 'string_literal'
Specifies a comment for the organization account.
Default: No value
Only users with the ORGADMIN role can execute the command.
Examples¶Create an organization account in the same region group and Snowflake Region in which the CREATE ORGANIZATION ACCOUNT statement is executed. The new organization administrator must change their password upon first login:
CREATE ORGANIZATION ACCOUNT myorgaccount ADMIN_NAME = admin ADMIN_PASSWORD = 'TestPassword1' EMAIL = 'myemail@myorg.org' MUST_CHANGE_PASSWORD = true EDITION = enterprise;Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4