Categories:

Account & Session DDL

CREATE ACCOUNT

Creates a new account in your organization.

See also:

SHOW ORGANIZATION ACCOUNTS

Syntax

CREATE ACCOUNT <name>
      ADMIN_NAME = <string>
      ADMIN_PASSWORD = '<string_literal>'
    [ FIRST_NAME = <string> ]
    [ LAST_NAME = <string> ]
      EMAIL = <string>
    [ MUST_CHANGE_PASSWORD = { TRUE | FALSE } ]
      EDITION = { STANDARD | ENTERPRISE | BUSINESS_CRITICAL }
    [ REGION_GROUP = <region_group_id> ]
    [ REGION = <snowflake_region_id> ]
    [ COMMENT = '<string_literal>' ]

Required Parameters

name

Specifies the identifier (i.e. name) for the account; must be unique within an organization, regardless of which Snowflake Region the account is in.

In addition, the identifier 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

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, including spaces and non-alphanumeric characters, such as exclamation points (!), percent signs (%), and asterisks (*); however, if the string contains spaces or non-alphanumeric characters, it must be enclosed in single or double quotes. 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.

For more information about passwords in Snowflake, see Snowflake Password Policy.

EMAIL = string

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.

Optional Parameters

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

ID of the Snowflake 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.)

Default: Current Snowflake Region.

COMMENT = 'string_literal'

Specifies a comment for the table.

Default: No value

Usage Notes

  • Only organization administrators (users with the ORGADMIN role) can execute this SQL command.

  • 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.

Examples

Create a new 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;

Create a new 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;