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
CREATE ACCOUNTneedsADMIN_NAME, a password or public key,EMAILandEDITION; the first user getsACCOUNTADMIN.ALTER ACCOUNT ... RENAME TO ... SAVE_OLD_URL; the default keeps the old URL working;DROP OLD URLremoves 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.
How it works
View, create and list accounts
Only an organization administrator can create an account. A new account needs these settings:
| Parameter | Meaning |
|---|---|
ADMIN_NAME | Login name of the first user, who receives ACCOUNTADMIN |
ADMIN_PASSWORD or ADMIN_RSA_PUBLIC_KEY | How that user signs in; one of the two is required |
EMAIL | Address for account notifications |
EDITION | STANDARD, ENTERPRISE or BUSINESS_CRITICAL |
REGION_GROUP, REGION | Optional; default to the current region group and region |
ADMIN_USER_TYPE | Optional; 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_URLdefaults toTRUE: both the old and new URLs work. WithFALSE, users must switch to the new URL at once.DROP OLD URLremoves 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 name | Account locator | |
|---|---|---|
| Form | myorg-account123 | xy12345, sometimes xy12345.us-east-2.aws |
| Chosen by | The administrator | Snowflake, at creation |
| Can change | Yes, with RENAME TO | No |
| Status | Preferred | Supported, 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
| Use | Identifier |
|---|---|
| Snowsight sign in URL, BI tools | orgname-account_name.snowflakecomputing.com |
| Drivers, Snowflake CLI, SnowSQL | orgname-account_name |
| Okta SSO or SCIM (no underscores accepted) | The hyphenated form of the same identifier |
| Fully qualified name in SQL, data sharing | orgname.account_name with a period |
| Replication and failover (preferred) | organization_name.account_name |
| Private connectivity | URL 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 location | Form |
|---|---|
| Same region, other account | account_locator |
| Same region group, other region | snowflake_region.account_locator |
| Other region group | region_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.
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 ACCOUNTneedsADMIN_NAME, a password or public key,EMAILandEDITION; the first user getsACCOUNTADMIN.ALTER ACCOUNT ... RENAME TO ... SAVE_OLD_URL; the default keeps the old URL working;DROP OLD URLremoves it.- Preferred identifier is
orgname-account_name; the locator is fixed and legacy. - Replication prefers
organization_name.account_nameand 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_URLdo 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.