Creates a new account in your organization.
Tip
In addition to SQL, you can also use other interfaces, such as Snowflake REST APIs, Snowflake Python APIs, and Snowflake CLI. See Alternate interfaces.
CREATE ACCOUNT <name>
ADMIN_NAME = '<string_literal>'
{ ADMIN_PASSWORD = '<string_literal>' | ADMIN_RSA_PUBLIC_KEY = '<string_literal>' }
[ ADMIN_USER_TYPE = { PERSON | SERVICE | LEGACY_SERVICE | NULL } ]
[ FIRST_NAME = '<string_literal>' ]
[ LAST_NAME = '<string_literal>' ]
EMAIL = '<string_literal>'
[ MUST_CHANGE_PASSWORD = { TRUE | FALSE } ]
EDITION = { STANDARD | ENTERPRISE | BUSINESS_CRITICAL }
[ REGION_GROUP = <region_group_id> ]
[ REGION = <snowflake_region_id> ]
[ COMMENT = '<string_literal>' ]
[ POLARIS = { TRUE | FALSE } ]
Copy
Required parameters¶name
Specifies the identifier (i.e. name) for the account. It must conform to the following:
Must be unique within an organization, regardless of which Snowflake Region the account is in.
Must start with an alphabetic character and cannot contain spaces or special characters except for underscores (_). Note that if the account name includes underscores, features that do not accept account names with underscores (e.g. Okta SSO or SCIM) can reference a version of the account name that substitutes hyphens (-) for the underscores.
ADMIN_NAME = 'string_literal'
Login name of the initial administrative user of the account. A new user is created in the new account with this name and password and granted the ACCOUNTADMIN role in the 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 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_literal'
Assigns a public key to the initial administrative user of the 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 account. This email address is used to send any notifications about the account.
EDITION = { STANDARD | ENTERPRISE | BUSINESS_CRITICAL }
Snowflake Edition of the account.
ADMIN_USER_TYPE = { PERSON | SERVICE | LEGACY_SERVICE | NULL }
Used for setting the type of the first user that is assigned the ACCOUNTADMIN role during account creation.
Default: NULL (Same as PERSON).
FIRST_NAME = string , . LAST_NAME = string
First and last name of the initial administrative user of the account.
Default: NULL
MUST_CHANGE_PASSWORD = { TRUE | FALSE }
Specifies whether the new user created to administer the account is forced to change their password upon first login into the account.
Default: FALSE
REGION_GROUP = region_group_id
ID of the region group where the 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 account is created. If no value is provided, Snowflake creates the account in the same Snowflake Region as the current account (i.e. the account in which the CREATE 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 account.
Default: No value
POLARIS = { TRUE | FALSE }
Specifies whether to create a Snowflake Open Catalog account.
Default: FALSE
Only organization administrators can execute this SQL command.
Usage notes¶An account can be associated with your organization in one of the following ways:
Create a new account using the SQL command described in the current topic.
Contact Snowflake Support to link an existing account to your organization.
By default, the maximum number of accounts in an organization cannot exceed 25. To have this limit raised, contact Snowflake Support.
It takes about 30 seconds for the DNS changes to propagate before you can access a newly created account. If the account is not accessible immediately, wait for approximately 30 seconds and try again.
Regarding metadata:
Attention
Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.
Create a new Snowflake account in the aws_us_west_2 Snowflake Region on Amazon Web Services (AWS). The user who executes the CREATE ACCOUNT statement can be logged into an account in the same or a different Snowflake Region:
create account myaccount1 admin_name = admin admin_password = 'TestPassword1' first_name = Jane last_name = Smith email = 'myemail@myorg.org' edition = enterprise region = aws_us_west_2;Copy
Create a new Snowflake account in the same region group and Snowflake Region in which the CREATE ACCOUNT statement is executed. The new account administrator user must change their password upon first login:
create account myaccount2 admin_name = admin admin_password = 'TestPassword1' email = 'myemail@myorg.org' edition = enterprise;Copy
Create a new Open Catalog account in the aws_us_west_2 Snowflake Region on Amazon Web Services (AWS):
Alternate interfaces¶create account myaccount1 admin_name = admin admin_password = 'TestPassword1' first_name = Jane last_name = Smith email = 'myemail@myorg.org' edition = enterprise region = aws_us_west_2 polaris = true;Copy
Snowflake REST APIs
Create an account endpoint
Snowflake Python APIs
Snowflake CLI
snow object create command
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