Account Management and Data Governance · Topic 2 of 9

Accounts, Names and Account Identifiers

Create, list and rename accounts, and choose the right account name, locator, region ID and region group for connections, sharing and replication.

  • 4 min
In a nutshell
  • CREATE ACCOUNT needs ADMIN_NAME, a password or public key, EMAIL and EDITION; the first user gets ACCOUNTADMIN.
  • ALTER ACCOUNT ... RENAME TO ... SAVE_OLD_URL; the default keeps the old URL working; DROP OLD URL removes it.
  • Preferred identifier is orgname-account_name; the locator is fixed and legacy.

What it is

An organization administrator manages the life cycle of each account: create it, list it, rename it, change its edition, drop it. Every account can be addressed in two ways. The preferred identifier is orgname-account_name. The older identifier is the account locator, assigned at creation and never changed, which in many regions needs extra region and cloud segments.

The exam asks which identifier fits which task and what happens to URLs when an account is renamed.

Org administratorCREATE ACCOUNTNew accountname, edition, regionALTER ACCOUNT RENAMENew nameold URL kept or dropped

How it works

View, create and list accounts

Only an organization administrator can create an account. A new account needs these settings:

ParameterMeaning
ADMIN_NAMELogin name of the first user, who receives ACCOUNTADMIN
ADMIN_PASSWORD or ADMIN_RSA_PUBLIC_KEYHow that user signs in; one of the two is required
EMAILAddress for account notifications
EDITIONSTANDARD, ENTERPRISE or BUSINESS_CRITICAL
REGION_GROUP, REGIONOptional; default to the current region group and region
ADMIN_USER_TYPEOptional; unset behaves like PERSON; SERVICE for a non-human admin (LEGACY_SERVICE is being deprecated)
CREATE ACCOUNT analytics_eu
  ADMIN_NAME = admin_eu
  ADMIN_RSA_PUBLIC_KEY = 'MIIBIjANBgkqh...'
  EMAIL = '[email protected]'
  EDITION = ENTERPRISE
  REGION = aws_eu_west_1;

A new account can take about 30 seconds to be reachable because DNS has to propagate. List accounts with SHOW ACCOUNTS or in Snowsight under Admin, then Accounts. Use SHOW REGIONS before creating to find valid region IDs.

Change account names

ALTER ACCOUNT analytics_eu RENAME TO analytics_europe SAVE_OLD_URL = TRUE;
ALTER ACCOUNT analytics_europe DROP OLD URL;
  • An organization administrator cannot rename the account they are logged in to; they must sign in to a different account first. If the organization has a single account, contact Snowflake Support.
  • SAVE_OLD_URL defaults to TRUE: both the old and new URLs work. With FALSE, users must switch to the new URL at once.
  • DROP OLD URL removes the original URL later. A separate command, DROP OLD ORGANIZATION URL, exists for URLs left by an organization name change, which are otherwise dropped automatically after 90 days.

Name rules: the name must be unique in the organization, start with a letter, contain only letters, digits and underscores, and not end with an underscore. The organization name, the account name and the hyphen together must not exceed 63 characters.

Account name versus account locator

Account nameAccount locator
Formmyorg-account123xy12345, sometimes xy12345.us-east-2.aws
Chosen byThe administratorSnowflake, at creation
Can changeYes, with RENAME TONo
StatusPreferredSupported, no longer preferred

Functions help find the values: CURRENT_ORGANIZATION_NAME(), CURRENT_ACCOUNT_NAME(), CURRENT_ACCOUNT() (the locator) and CURRENT_REGION().

When each identifier is needed

UseIdentifier
Snowsight sign in URL, BI toolsorgname-account_name.snowflakecomputing.com
Drivers, Snowflake CLI, SnowSQLorgname-account_name
Okta SSO or SCIM (no underscores accepted)The hyphenated form of the same identifier
Fully qualified name in SQL, data sharingorgname.account_name with a period
Replication and failover (preferred)organization_name.account_name
Private connectivityURL from SYSTEM$GET_PRIVATELINK_CONFIG

Note the separator: a hyphen in URLs and client configuration, a period in SQL and data sharing.

For replication and failover, locator-based forms depend on where the target is:

Target locationForm
Same region, other accountaccount_locator
Same region group, other regionsnowflake_region.account_locator
Other region groupregion_group.snowflake_region.account_locator

SHOW REPLICATION ACCOUNTS gives the region and region group values.

Region IDs and region groups

A region ID (for example aws_us_east_2, azure_westeurope, gcp_us_central1) names a Snowflake region across clouds, and is needed when you create accounts or configure replication in an organization. A region group decides which accounts can share and replicate across regions. All commercial multi-tenant regions are in the PUBLIC group. Each government region has its own group, and each Virtual Private Snowflake deployment is in a VPS-specific group.

Account nameorgname and account_namepreferred forClients, SSO, replicationAccount locatorxy12345 plus regionlegacy forSame region and region group cases

Common mistakes

Typing a period in a URL, or a hyphen in SQL. URLs and drivers use orgname-account_name; SQL and data sharing use orgname.account_name.

Renaming the account you are logged in to. It is not allowed; use another account.

Assuming the old URL stops working at once. SAVE_OLD_URL defaults to TRUE, so both URLs work until you drop the old one.

Giving Okta an underscore name. Use the hyphenated form of the identifier rather than renaming.

Ignoring region groups. Accounts in different region groups need the region group in the locator form, or the organization name form.

What to remember for the exam

  • CREATE ACCOUNT needs ADMIN_NAME, a password or public key, EMAIL and EDITION; the first user gets ACCOUNTADMIN.
  • ALTER ACCOUNT ... RENAME TO ... SAVE_OLD_URL; the default keeps the old URL working; DROP OLD URL removes it.
  • Preferred identifier is orgname-account_name; the locator is fixed and legacy.
  • Replication prefers organization_name.account_name and works regardless of region.
  • Region ID is the canonical name; the region group controls cross-region sharing and replication.

Check yourself

  • Which identifier is preferred for replication and failover?

    organization_name.account_name, which works regardless of region or region group.

  • What does SAVE_OLD_URL do when you rename an account?

    It keeps the old URL working alongside the new one; it defaults to TRUE.

  • Where do you find valid regions for a new account?

    SHOW REGIONS, which lists the regions enabled for the organization.

Topic 2 of 9 in Account Management and Data Governance

Test yourself on Account Management and Data Governance

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.