Getting started with organizations¶
This topic discusses how to work with an organization.
Organization creation¶
Snowflake customers never directly create an organization. For users who sign-up for a Snowflake account using the self-service option, an organization is automatically created with a system-generated name when the account is created. For entities who work directly with Snowflake personnel to set up accounts, Snowflake creates the organization to which the accounts belong using a custom name. In either case, users can create additional accounts that belong to the organization after it is created with the initial account.
Viewing the name of your organization and its accounts¶
If you are the organization administrator, you can view the name of your organization and its accounts through the web interface or using SQL:
- SQL:
Execute a SHOW ACCOUNTS command.
- Snowsight:
Select Admin » Accounts. The organization name is listed above the account names.
Users with any role can execute the CURRENT_ORGANIZATION_NAME function to return the organization of the current account.
Users with any role can also find the organization name and account name for a specific account that they have previously signed in to. See Finding the organization and account name for an account.
Changing the name of your organization¶
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.
When you contact Snowflake Support, you must decide whether users can temporarily access accounts in the organization using the original account URL. If you keep the original account URL, it is automatically dropped after 90 days, at which time users must use the new account URL to access the account. If you want to drop the account URL before the 90 days expire, see Deleting an organization URL.
Deleting an organization¶
To delete your Snowflake organization:
Delete all accounts in the organization, except the account being used for the deletion.
Contact Snowflake Support to delete the last account and the organization.