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, organizations must be enabled in your account(s). Organizations are currently in preview and must be requested to be enabled through 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

Option 1: Account Name in Your Organization — Preview

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.

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. Currently, organization names are assigned by Snowflake, but you can request the name to be changed.

account_name

Unique name of your account within your organization:

  • If you are an organization administrator and create an account within your organization, you can specify the name of the account at creation.

  • If an account is created for your organization, either through self-service or a Snowflake representative, the account name is provided by Snowflake, but you can request the name to be changed.

For example, if your organization name is abccorp and account name is usprod1, either of the following formats would work for the account URL:

abccorp-usprod1.snowflakecomputing.com or

abcorp_usprod1.snowflakecomputing.com (if hyphens aren’t supported)

For more details about organizations and account identifiers, see Understanding Organization and Account Names.

Finding Your Organization and Account Name

To determine your organization and account name, contact your Snowflake administrator.

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

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

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

Important

If either of the following conditions is true, your account locator is different than the structure described in the above examples:

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 — Preview.

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

Where:

snowflake_region Snowflake Region ID.

name The account locator for replication commands is the value of the name column in SHOW REPLICATION ACCOUNTS or the account_name column in 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

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