Account identifiers | Snowflake Documentation (2024)

An account identifier uniquely identifies a Snowflake account within your organization, as well asthroughout the global network of Snowflake-supported cloud platforms andcloud regions.

The preferred account identifier includes the name of the account along with its organization (e.g. myorg-account123). Although you canalso use the Snowflake-assigned locator as the account identifier, the use of this legacy format is discouraged.

Where are account identifiers used?¶

Account identifiers are required in Snowflake wherever you need to specify the account you are using, including:

URLs for accessing any of the Snowflake web interfaces.
SnowSQL and other clients (connectors, drivers, etc.) for connecting to Snowflake.
3rd-party applications and services that comprise the Snowflake ecosystem.
Security features for protecting Snowflake internal operations and communication/interaction with external systems.
Global features such as Secure Data Sharing and Replication and Failover/Failback.

For example, the URL for an account uses the following format:

account_identifier.snowflakecomputing.com

If your organization uses the Client Redirect feature, the name of aconnection object can be used in place of the account name in the account identifierto connect to a Snowflake account using a Snowflake client. For more information, see Using a connection URL.

For more information about using account identifiers and connections to connect to a Snowflake account, seeConnecting to your accounts.

Format 1 (preferred): Account name in your organization¶

An organization is a Snowflake object that links the accounts owned by your businessentity. Organizations enable organization administrators (i.e. users with the ORGADMIN role) to view, create, and manage all of youraccounts across different cloud platforms and regions.

Account names must be unique within your organization, and can be changed, which allows more flexibility and leads to shorter and moreintuitive account names. You specify an account name when you create a new account(see Creating an account). To change a namefor an existing account, see Renaming an account.

While an account name uniquely identifies an account within your organization, it is not a unique identifier of an accountacross Snowflake organizations.

Account names with underscores also have a dashed version of the URL for features that do not accept URLs with underscores, such asOkta SSO/SCIM.

Using an account name as an identifier¶

The account identifier for an account in your organization takes one of the following forms, depending on where and how the identifieris used:

orgname-account_name (for most URLs and other general purpose usage, including Snowflake drivers)
orgname-account-name (for scenarios/features where underscores in an account name are not supported)
orgname.account_name (for SQL commands and operations)

Where:

orgname is the name of your Snowflake organization.
account_name is the unique name of your account within your organization.

Finding the organization and account name for an account¶

To find the account name for an account, you can use Snowsight or SQL.

Snowsight:

Open the account selector and review the list of accounts that you previously signed in to.
See Also
8 criteria to ensure you select the right cloud service provider - Cloud Industry Forum 10 key factors to consider when choosing a cloud service provider Supported Cloud Regions | Snowflake Documentation 7 Factors to Help You Choose the Right Cloud Service Provider - Collaboration Corner
Locate the account for which you want to copy the account name.
Hover over the account to view additional details, and then select the copy icon to copy the account identifier in the formatorgname.account_name to your clipboard.

Note

The account identifier is copied in the format orgname.account_name, which is used for SQL commands and operations.

If you need to use the account identifier with a Snowflake driver (for example, JDBC or ODBC), you need to replace the period (.) witha hyphen (-) so the identifier is formatted as orgname-account_name.

SQL:

To retrieve the name of the current account, execute the CURRENT_ACCOUNT_NAME function.
To retrieve the organization of the current account, execute the CURRENT_ORGANIZATION_NAME function.

Organization and account names¶

Organization name¶

For users who sign up for a Snowflake account using the self-service option, an organization is automatically created with asystem-generated name when the account is created. For entities who work directly with Snowflake personnel to set up accounts,Snowflake can assign the organization a custom name. This custom name must be unique across all other organizations in Snowflake.The name must start with a letter and can only contain letters (lowercase and uppercase) and numbers. The name cannot contain underscoresor other delimiters.

If you want to change the name of an organization, for example to change a system-generated name to a more user-friendly one,contact Snowflake Support.

As a best practice, review and change your organization name, if needed, before using the name in any account identifiers. Renamingthe organization name in the future will result in changing all the URLs for your Snowflake accounts to match the new name.

To view the name of your organization, see Viewing the name of your organization and its accounts.

Account name¶

Each account name must be unique within your organization. You specify an account name when you create the account (see Creating an account).

While an account name uniquely identifies an account within your organization, it is not a unique identifier of an account acrossSnowflake organizations. To uniquely identify an account in Snowflake, you must prepend your organization name to the account name. Forexample:

orgname-account_name

Consistent with SQL standards for identifiers, account names can include underscores as separators between words (e.g.MARKETING_TEST_ACCOUNT).

URLs that include underscores can sometimes cause issues for certain features, such as Okta SSO/SCIM. For this reason, Snowflake alsosupports a version of the account name that substitutes the hyphen character (-) in place of the underscore character. For exampleboth of the following URLs are supported:

URL with underscores: https://acme-marketing_test_account.snowflakecomputing.com
URL with dashes: https://acme-marketing-test-account.snowflakecomputing.com

Existing accounts¶

If you have any accounts that existed before the Organizations feature was enabled, the Format 2: Account locator in a region is used as theaccount name.

In addition, if you have existing accounts with the same name in different regions, the cloud and region names are appended to theaccount name in the new URL format.

For example, if your organization name is ACME, and there are two accounts named TEST, one in the AWS us-east-2 regionand the other in the Azure west-us-2 region, the new URLs will use the following structure:

First account:
See Also
What is the Data Cloud?
Original URL:
https://test.us-east-2.aws.snowflakecomputing.com
New URL:
https://acme-test_aws_us_east_2.snowflakecomputing.com
Second account:
Original URL:
https://test.west-us-2.azure.snowflakecomputing.com
New URL:
https://acme-test_azure_west_us_2.snowflakecomputing.com

These account names can be changed as long as the new names are unique. For instructions on how to change an account name, see Renaming an account.

Format 2: Account locator in a region¶

An account locator is an identifier assigned by Snowflake when the account is created:

If the account is created by a Snowflake representative, you may be able to request a specific value for the locator, such as acompany name, acronym, or other recognizable string.
If the account is created through self-service or an automated/background process, the locator is a random string of unique charactersand numbers (e.g. xy12345).

The locator for an account cannot be changed once the account is created.

Note

Account locators continue to be supported for identifying accounts in Snowflake, but this is no longer the preferred method. Thepreferred method for identifying accounts is now the account name within your organization (as described earlier in this topic).

Using an account locator as an identifier¶

Each Snowflake account is hosted on a cloud platform in a geographicalregion.

The region determines where the data in the account is stored and where the compute resources used by the account are provisioned.

When using an account locator to identify an account, the locator by itself is not always sufficient to identify the account. Dependingon the region and cloud platform for the account, additional segments may be required, in the form of:

account_locator.cloud_region_id or

account_locator.cloud_region_id.cloud

Where:

cloud_region_id is the identifier for the cloud region (dictated by the cloud platform).
cloud is the identifier for the cloud platform (aws, azure, or gcp).

For example, if your account locator is xy12345:

If the account is located in the AWS US West (Oregon) region, no additional segments are required and the URL would bexy12345.snowflakecomputing.com.
If the account is located in the AWS US East (Ohio) region, additional segments are required and the URL would bexy12345.us-east-2.aws.snowflakecomputing.com.

For a complete list of regions and locator formats, see Non-VPS Account Locator Formats by Cloud Platform and Region (in this topic).

Note

If your Snowflake Edition is VPS, the account locator uses a different format. SeeFinding the account locator format for a VPS account (in this topic).

Finding the region and locator for an account¶

If you can connect to your Snowflake account, you can query the following context functions to identify the region and account locatorfor the Snowflake account you are connected to:

CURRENT_REGION retrieves the region in which your account is located.
CURRENT_ACCOUNT retrieves the account locator.

If you are unable to connect to Snowflake, contact the Snowflake administrator for your account to retrieve this information.

Finding the account locator format for a VPS account¶

If your Snowflake Edition is VPS, the account locator format uses differentnaming conventions than the accounts for other Snowflake Editions. This results in a different structure for the hostnames and URLs used toaccess VPS accounts.

For details, please contact Snowflake Support or your Snowflake representative.

As an alternative, you can use the preferred format of organization_name-account_name as your account identifier. Thisformat works for accounts that use the VPS edition. For details, see Format 1 (preferred): Account name in your organization (in this topic).

Non-VPS account locator formats by cloud platform and region¶

The following table lists the account locator formats across all the supported non-VPS regions, including whether the account locatorfor a given region requires additional segments:

If your account locator is xy12345:

Cloud Platform / Region	Account Identifier	Notes
Amazon Web Services (AWS)
US West (Oregon)	`xy12345`	No additional segments required.
US Gov West 1	`xy12345.us-gov-west-1.aws`
US Gov West 1 (FedRAMP High Plus)	`xy12345.fhplus.us-gov-west-1.aws`
US Gov East 1 (FedRAMP High Plus)	`xy12345.fhplus.us-gov-east-1.aws`
US East (Ohio)	`xy12345.us-east-2.aws`
US East (N. Virginia)	`xy12345.us-east-1`	Cloud region ID is the only additional segment required.
US East (Commercial Gov - N. Virginia)	`xy12345.us-east-1-gov.aws`
Canada (Central)	`xy12345.ca-central-1.aws`
South America (Sao Paulo)	`xy12345.sa-east-1.aws`
EU (Ireland)	`xy12345.eu-west-1`	Cloud region ID is the only additional segment required.
Europe (London)	`xy12345.eu-west-2.aws`
EU (Paris)	`xy12345.eu-west-3.aws`
EU (Frankfurt)	`xy12345.eu-central-1`	Cloud region ID is the only additional segment required.
EU (Zurich)	`xy12345.eu-central-2.aws`
EU (Stockholm)	`xy12345.eu-north-1.aws`
Asia Pacific (Tokyo)	`xy12345.ap-northeast-1.aws`
Asia Pacific (Osaka)	`xy12345.ap-northeast-3.aws`
Asia Pacific (Seoul)	`xy12345.ap-northeast-2.aws`
Asia Pacific (Mumbai)	`xy12345.ap-south-1.aws`
Asia Pacific (Singapore)	`xy12345.ap-southeast-1`	Cloud region ID is the only additional segment required.
Asia Pacific (Sydney)	`xy12345.ap-southeast-2`	Cloud region ID is the only additional segment required.
Asia Pacific (Jakarta)	`xy12345.ap-southeast-3.aws`
Google Cloud Platform (GCP)
US Central1 (Iowa)	`xy12345.us-central1.gcp`
US East4 (N. Virginia)	`xy12345.us-east4.gcp`
Europe West2 (London)	`xy12345.europe-west2.gcp`
Europe West4 (Netherlands)	`xy12345.europe-west4.gcp`
Microsoft Azure		The Azure account locators were implemented with hyphens for consistency with AWS and GCP.
West US 2 (Washington)	`xy12345.west-us-2.azure`
Central US (Iowa)	`xy12345.central-us.azure`
South Central US (Texas)	`xy12345.south-central-us.azure`
East US 2 (Virginia)	`xy12345.east-us-2.azure`
US Gov Virginia	`xy12345.us-gov-virginia.azure`
Canada Central (Toronto)	`xy12345.canada-central.azure`
UK South (London)	`xy12345.uk-south.azure`
North Europe (Ireland)	`xy12345.north-europe.azure`
West Europe (Netherlands)	`xy12345.west-europe.azure`
Switzerland North (Zurich)	`xy12345.switzerland-north.azure`
UAE North (Dubai)	`xy12345.uae-north.azure`
Central India (Pune)	`xy12345.central-india.azure`
Japan East (Tokyo)	`xy12345.japan-east.azure`
Southeast Asia (Singapore)	`xy12345.southeast-asia.azure`
Australia East (New South Wales)	`xy12345.australia-east.azure`

Account identifiers for private connectivity¶

If private connectivity to the Snowflake service is enabled for your account and you wish to use the feature to connect to Snowflake,run the SYSTEM$GET_PRIVATELINK_CONFIG function to determine the private connectivity URL to use.You can use either the account name or account locator in the URL to connect to the Snowflake web interface.

If you want to connect to Snowsight using private connectivity, use the following instructions in theSigning in to Snowsight.

Account identifiers for replication and failover¶

The preferred method of identifying an account in replication and failover related SQL commands uses the organization name and account name as the account identifier. If you decide to use the legacy account locator instead, it may need to contain additional segments in order touniquely identify the account. See the table below for reference:

Account Identifier
Location of the Remote Account
organization_name.account_name
Preferred account identifier that can be used regardless of the region or region group of the account that stores the primary database.
account_locator
Same region but a different account from the account that stores the primary database.
snowflake_region.account_locator
Same region group but a different region from the account that stores the primary database.
region_group.snowflake_region.account_locator
Different region group from the account that stores the primary database.

Account Identifier	Location of the Remote Account
`organization_name.account_name`	Preferred account identifier that can be used regardless of the region or region group of the account that stores the primary database.
`account_locator`	Same region but a different account from the account that stores the primary database.
`snowflake_region.account_locator`	Same region group but a different region from the account that stores the primary database.
`region_group.snowflake_region.account_locator`	Different region group from the account that stores the primary database.

The values for snowflake_region and region_group can be found in the output of SHOW REPLICATION ACCOUNTS.

Snowflake region IDs and region groups¶

A Snowflake Region is a distinct region (deployed within an AWS, Azure, or GCP cloud region) that is isolated from other SnowflakeRegions. A Snowflake Region can be either multi-tenant (containing accounts for multiple organizations) or single-tenant(aka Virtual Private Snowflake for a single organization).

Each Snowflake Region has an unique identifier and belongs to a region group, which enables global features such as data sharing andreplication.

Region IDs¶

Because each cloud platform utilizes different conventions and formats for naming their regions, Snowflake assigns a canonical ID toeach Snowflake Region that uniquely identifies it across all the cloud platforms and their regions.

If the Organizations feature is enabled, specifying the Snowflake Region ID as part of an account identifier is required when you createa new account, as well as when you configure replication and failover.

The following table displays the complete list of Snowflake Region IDs:

CloudRegion	CloudRegionID	SnowflakeRegionID	Notes
Amazon Web Services (AWS)
US West (Oregon)	`us-west-2`	`aws_us_west_2`
US Gov West 1	`us-gov-west-1`	`aws_us_gov_west_1`	Available only for accounts on Business Critical (or higher); located in AWS GovCloud (US).
US Gov West 1 (FedRAMP High Plus)	`fhplus.us-gov-west-1.aws`	`aws_us_gov_west_1_fhplus`	Available only for accounts on Business Critical (or higher); located in AWS GovCloud (US).
US East (Ohio)	`us-east-2`	`aws_us_east_2`
US East (N. Virginia)	`us-east-1`	`aws_us_east_1`
US East (Commercial Gov - N. Virginia)	`us-east-1`	`aws_us_gov_east_1`	Available only for accounts on Business Critical (or higher); located in US East 1, not AWS GovCloud (US).
Canada (Central)	`ca-central-1`	`aws_ca_central_1`
South America (Sao Paulo)	`sa-east-1`	`aws_sa_east_1`
EU (Ireland)	`eu-west-1`	`aws_eu_west_1`
Europe (London)	`eu-west-2`	`aws_eu_west_2`
EU (Paris)	`eu-west-3`	`aws_eu_west_3`
EU (Frankfurt)	`eu-central-1`	`aws_eu_central_1`
EU (Zurich)	`eu-central-2`	`aws_eu_central_2`
EU (Stockholm)	`eu-north-1`	`aws_eu_north_1`
Asia Pacific (Tokyo)	`ap-northeast-1`	`aws_ap_northeast_1`
Asia Pacific (Osaka)	`ap-northeast-3`	`aws_ap_northeast_3`
Asia Pacific (Seoul)	`ap-northeast-2`	`aws_ap_northeast_2`
Asia Pacific (Mumbai)	`ap-south-1`	`aws_ap_south_1`
Asia Pacific (Singapore)	`ap-southeast-1`	`aws_ap_southeast_1`
Asia Pacific (Sydney)	`ap-southeast-2`	`aws_ap_southeast_2`
Asia Pacific (Jakarta)	`ap-southeast-3`	`aws_ap_southeast_3`
Google Cloud Platform (GCP)
US Central1 (Iowa)	`us-central1`	`gcp_us_central1`
US East4 (N. Virginia)	`us-east4`	`gcp_us_east4`
Europe West2 (London)	`europe-west2`	`gcp_europe_west2`
Europe West4 (Netherlands)	`europe-west4`	`gcp_europe_west4`
Microsoft Azure
West US 2 (Washington)	`westus2`	`azure_westus2`
Central US (Iowa)	`centralus`	`azure_centralus`
South Central US (Texas)	`southcentralus`	`azure_southcentralus`
East US 2 (Virginia)	`eastus2`	`azure_eastus2`
US Gov Virginia	`usgovvirginia`	`azure_usgovvirginia`	Available only for accounts on Business Critical (or higher); located in Microsoft Azure Government.
Canada Central (Toronto)	`canadacentral`	`azure_canadacentral`
UK South (London)	`uk-south`	`azure_uksouth`
North Europe (Ireland)	`northeurope`	`azure_northeurope`
West Europe (Netherlands)	`westeurope`	`azure_westeurope`
Switzerland North (Zurich)	`switzerlandnorth`	`azure_switzerlandnorth`
UAE North (Dubai)	`uaenorth`	`azure_uaenorth`
Central India (Pune)	`central-india.azure`	`azure_centralindia`
Japan East (Tokyo)	`japaneast`	`azure_japaneast`
Southeast Asia (Singapore)	`southeastasia`	`azure_southeastasia`
Australia East (New South Wales)	`australiaeast`	`azure_australiaeast`

Region groups¶

A region group is a group of Snowflake Regions that offer similar security controls, isolation, and compliance. The region group to whicha Snowflake Region belongs differs depending on the region:

All Snowflake multi-tenant commercial regions (across all the supported cloud platforms) are in the same shared/general PUBLICgroup.
Each Snowflake multi-tenant government region is in a separate group specific to the region.
Each single-tenant Virtual Private Snowflake (VPS) is in a separate region group specific to the VPS. If your organization has more thanone VPS, you can have one VPS per region group or multiple VPSs can share the same region group.

Specifying the region group as part of an account identifier is required when you want to createaccounts in different region groups.