Account Identifiers

An account identifier uniquely identifies a Snowflake account within your business entity, as well as throughout the global network of Snowflake supported cloud platforms and cloud regions.

Snowflake supports two different options for identifying a Snowflake account. You can identify an account using either its name in your organization or its Snowflake-assigned locator in the cloud region where the account is located.

Note

Either option can be used. However, to use the first option, an ORGADMIN role must be created in one of your accounts. If the role does not exist, contact Snowflake Support.

In this Topic:

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, drivers, connectors, and other clients for connecting to Snowflake.

  • 3rd-party applications and services that comprise the Snowflake ecosystem.

  • Features for securing Snowflake internal operations and communication/interaction with external systems.

  • Global features such as Secure Data Sharing and Database Replication and Failover/Failback.

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

account_identifier.snowflakecomputing.com

For more information about using account identifiers in URLS and drivers, see Using Account Identifiers for Connecting to Your Accounts.

Option 1: Account Name in Your Organization

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

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

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

Account names with underscores also have a dashed version of the URL for features that do not accept URLs with underscores, such as Okta 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 identifier is used:

  • organization_name-account_name (for most URLs and other general purpose usage)

  • organization_name_account_name (for scenarios/features where hyphens are not supported in URLs)

  • organization_name.account_name (for SQL commands and operations)

Where:

organization_name

Name of your Snowflake organization.

account_name

Unique name of your account within your organization:

For more information about organization and account names, see Organization and Account Name (In this topic).

Organization and Account Name

Organization Name

The organization name is the name chosen by the customer. The name must be unique across all Snowflake organizations. It can include uppercase letters and numbers, but not underscores or other delimiters.

To change your organization name, contact Snowflake Support.

As a best practice, review and change the organization name, if needed, before using the organization name as an identifier. Renaming the organization name in the future will also rename all the account URLs.

To identify the name of your organization, see Viewing the Name of Your Organization.

Account Name

Account name must be unique within your organization. You specify an account name when you create a new account (see Creating an Account).

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

To uniquely identify an account in Snowflake, you must append the account name to the organization name. For example, <organization_name>-<account_name>.

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

Consistent with SQL standards for identifiers, account names can have underscores as separators between words (e.g. MARKETING_TEST_ACCOUNT), but only underscores. This will generate account URLs with underscores in them.

URLs with underscores can sometimes cause issues for certain features. For these URLs, Snoeflake publishes an all dashes version of the URL.

For example both these URLs will be functional:

URL with underscores: https://acme-marketing_test_account.snowflakecomputing.com

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

Existing Accounts

When an existing account is added to an organization, the Option 2: Account Locator in a Region is used in place of the account name.

If you have accounts with the same name in different regions, the cloud and region names are prepended to the account name in the new URL format.

For example, if the organization name is ACME, and there are two accounts named TEST, one in the AWS US East 2 region and the other in the Azure West US 2 region, the URLs will look as follows:

Original account URL 1: https://test.us-east-2.aws.snowflakecomputing.com

Original account URL 2: https://test.west-us-2.azure.snowflakecomputing.com

New account URL 1: https://acme-test_aws_us_east_2.snowflakecomputing.com

New account URL 2: 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 Changing Account Name.

Option 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 a company 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 characters and numbers (e.g. xy12345).

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

Using an Account Locator as an Identifier

Each Snowflake account is hosted on a cloud platform in a geographical region.

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 location of the account. Depending on the region and cloud platform for the account, additional segments may be required, in the form of:

account_locator.region_id or

account_locator.region_id.cloud

Where:

region_id

Identifier for the cloud region (dictated by the cloud platform).

cloud

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 be xy12345.snowflakecomputing.com.

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

For a complete list of region and locator formats, see Locator Formats by Cloud Platform and Region (in this topic).

Note

If your Snowflake Edition is VPS, the account locator uses a different format. See Finding the Account Locator for a VPS Account.

Finding the Region and Locator for Your Account

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

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

Locator Formats by Cloud Platform and Region

The following table lists the account locator formats across all the supported regions, including whether the account locator for a given region requires additional segments.

If your account locator is xy12345:

Cloud Platform / . Region

Account Locator . (with additional segments if required)

Amazon Web Services (AWS)

US West (Oregon)

xy12345

US East (Ohio)

xy12345.us-east-2.aws

US East (N. Virginia)

xy12345.us-east-1

US East (Commercial Gov - N. Virginia)

xy12345.us-east-1-gov.aws

Canada (Central)

xy12345.ca-central-1.aws

EU (Ireland)

xy12345.eu-west-1

Europe (London)

xy12345.eu-west-2.aws

EU (Frankfurt)

xy12345.eu-central-1

Asia Pacific (Tokyo)

xy12345.ap-northeast-1.aws

Asia Pacific (Mumbai)

xy12345.ap-south-1.aws

Asia Pacific (Singapore)

xy12345.ap-southeast-1

Asia Pacific (Sydney)

xy12345.ap-southeast-2

Google Cloud Platform (GCP)

US Central1 (Iowa)

xy12345.us-central1.gcp

Europe West2 (London)

xy12345.europe-west2.gcp

Europe West4 (Netherlands)

xy12345.europe-west4.gcp

Microsoft Azure

West US 2 (Washington)

xy12345.west-us-2.azure

Central US (Iowa)

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

West Europe (Netherlands)

xy12345.west-europe.azure

Switzerland North (Zurich)

xy12345.switzerland-north.azure

Southeast Asia (Singapore)

xy12345.southeast-asia.azure

Australia East (New South Wales)

xy12345.australia-east.azure

Finding the Account Locator for a VPS Account

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

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

As an alternative, you can use the preferred format of organizationName-accountName as your account identifier. This format works for accounts that use the VPS edition. See Option 1: Account Name in Your Organization for details.

Account Identifier for Private Connectivity

If AWS PrivateLink or Azure Private Link is enabled for your account and you wish to use private connectivity to connect to Snowflake, run the SYSTEM$GET_PRIVATELINK_CONFIG function to determine the private connectivity URL to use.

For more details on private connectivity, see:

Account Identifier for Replication and Fail-over

If you have the Organization feature enabled for your account, see Option 1: Account Name in Your Organization.

Replication and fail-over related SQL commands require using the Snowflake Region ID as part of the account identifier. For more details and a complete list, see Snowflake Region IDs (in this topic).

snowflake_region.account_locator

Where:

snowflake_region Snowflake Region ID.

account_locator The account locator for replication commands is the value of the account_locator column in

SHOW REPLICATION ACCOUNTS or SHOW REPLICATION DATABASES.

For replication and fail-over across different region groups, you will also need to specify the region group in the account identifier. For more details, see Region Groups (in this topic).

The region_group column can be found in the output of SHOW REPLICATION ACCOUNTS.

region_group.snowflake_region_id.name

Region Groups

A region group is a group of regions that offer similar security controls, isolation and compliance. Specifying the region group as part of the account identifier is required if you have the Organizations feature enabled and want to create accounts in different region groups, or for replication and fail-over to and from accounts in different region groups.

Snowflake accounts are in one of three region groups:

  • PUBLIC is the region group for all multi-tenant Snowflake regions across all clouds.

  • Virtual Private Snowflake (VPS) region groups contain a group of single-tenant (VPS) regions that belong to the same customer.

  • Government region groups contain government regions.

Snowflake Region IDs

A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. It can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account). Specifying the Snowflake Region ID as part of the account identifier is required if you have the Organizations feature enabled when you create a new account, and when configuring replication and fail-over.

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

Region

Region ID

Snowflake Region ID

Notes

Amazon Web Services (AWS)

US West (Oregon)

us-west-2

aws_us_west_2

US East (Ohio)

us-east-2.aws

aws_us_east_2

US East (N. Virginia)

us-east-1

aws_us_east_1

US East (Commercial Gov - N. Virginia)

us-east-1-gov.aws

aws_us_east_1_gov

Available only for accounts on Business Critical (or higher); not located in AWS GovCloud (US), which is a separate, dedicated cloud not yet supported by Snowflake.

Canada (Central)

ca-central-1.aws

aws_ca_central_1

EU (Ireland)

eu-west-1

aws_eu_west_1

Europe (London)

eu-west-2.aws

aws_eu_west_2

EU (Frankfurt)

eu-central-1

aws_eu_central_1

Asia Pacific (Tokyo)

ap-northeast-1.aws

aws_ap_northeast_1

Asia Pacific (Mumbai)

ap-south-1.aws

aws_ap_south_1

Asia Pacific (Singapore)

ap-southeast-1

aws_ap_southeast_1

Asia Pacific (Sydney)

ap-southeast-2

aws_ap_southeast_2

Google Cloud Platform (GCP)

US Central1 (Iowa)

us-central1.gcp

gcp_us_central1

Europe West2 (London)

europe-west2.gcp

gcp_europe_west2

Europe West4 (Netherlands)

europe-west4.gcp

gcp_europe_west4

Microsoft Azure

West US 2 (Washington)

west-us-2.azure

azure_westus2

Central US (Iowa)

central-us.azure

azure_centralus

East US 2 (Virginia)

east-us-2.azure

azure_eastus2

US Gov Virginia

us-gov-virginia.azure

azure_usgovvirginia

Available only for accounts on Business Critical (or higher).

Canada Central (Toronto)

canada-central.azure

azure_canadacentral

West Europe (Netherlands)

west-europe.azure

azure_westeurope

Southeast Asia (Singapore)

southeast-asia.azure

azure_southeastasia

Switzerland North (Zurich)

switzerland-north.azure

azure_switzerlandnorth

Australia East (New South Wales)

australia-east.azure

azure_australiaeast