Managing Accounts in Your Organization

All organization tasks can be performed from the Snowflake classic web interface or using the DDL commands for organizations.

In this Topic:

Viewing the Name of Your Organization

You can view the name of your organization through the web interface or using SQL:

Web Interface

In the top-right corner, click your name. The name of your organization is displayed in the drop-down list.

SQL

Execute a SHOW ORGANIZATION ACCOUNTS command.

URL

In your account URL, if using the new URL format: https://<organization_name>-<account_name>.snowflakecomputing.com

Changing the Name of Your Organization

Organization name must be unique across all Snowflake organizations. It cannot include underscores or other delimiters.

To change your organization name, contact Snowflake Support.

Creating an Account

An account can be created by an ORGADMIN through the web interface or using SQL:

Web Interface

Click Organization » Accounts » Create New Account.

SQL

Execute a CREATE ACCOUNT command.

By default, the maximum number of accounts in an organization cannot exceed 25. Contact Snowflake Support to have this limit raised.

When creating an account, you can specify a cloud platform, a region, and a Snowflake edition. You can optionally specify a region group if you have, or want to have, accounts in multiple region groups. For more details see Region Groups.

Note

You can only create an account in a region that is enabled for your organization. For a list of available regions, see Viewing a List of Regions Available for Your Organization (In this topic). To request access to additional regions, contact Snowflake Support.

Each account in your organization can have its own set of users, roles, databases, and warehouses.

You will be billed for usage in all of your accounts on a single bill. To monitor usage for your organization accounts, see Organization Usage views.

Viewing a List of Organization Accounts

A user with the ORGADMIN role can view a list of all accounts created in your organization through the web interface or using SQL:

Web Interface

Click Organization » Accounts.

SQL

Execute a SHOW ORGANIZATION ACCOUNTS command.

Changing Account Name

During the preview period, to change a name for an account in your organization, contact Snowflake Support and provide a unique identifier for your account, which can be one of the following:

  • Organization name and account name

  • Account locator

Deleting an Account

At this time, to delete an account, contact Snowflake Support and provide a unique identifier for your account, which can be one of the following:

  • Organization name and account name

  • Account locator

During the preview period, it may take up to a few days for a deleted account to be deducted from the number of created accounts allowed for your organization.

Viewing a List of Regions Available for Your Organization

A user with the ORGADMIN role can view a list of regions available for your organization through the web interface or using SQL:

Web Interface

Click Organization » Accounts » Create New Account » Choose Your Region.

SQL

Execute a SHOW REGIONS command.

Enabling Accounts for Replication

A user with the ORGADMIN role can enable an account for replication by setting the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true from the ORGADMIN account.

Note

If you have more than one account with the same account locator in different regions, to enable replication, contact Snowflake Support.

Example 1: Enabling Replication for a Single Account

-- Assume the ORGADMIN role
use role orgadmin;

-- View the list of the accounts
show organization accounts;

-- Enable replication for an account
select system$global_account_set_parameter('<account1_locator>',
'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');

Example 2: Enabling Replication for Multiple Accounts

-- Assume the ORGADMIN role
use role orgadmin;

-- View the list of the accounts
show organization accounts;

-- Enable replication for the first account
select system$global_account_set_parameter('<account1_locator>',
'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');

-- Enable replication for the second account
select system$global_account_set_parameter('<account2_locator>',
'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');