Categories:

Account & Session DDL

SHOW ORGANIZATION ACCOUNTS

Lists all the accounts in your organization.

See also:

SHOW REPLICATION ACCOUNTS

Syntax

SHOW ORGANIZATION ACCOUNTS [ LIKE '<pattern>' ]

Parameters

LIKE 'pattern'

Filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

Usage Notes

  • Only organization administrators (users with the ORGADMIN role) can execute this SQL command.

  • The command does not require a running warehouse to execute.

  • The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

    To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Information Schema.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Output

The command output provides global account properties and metadata in the following columns:

| snowflake_region | name | edition  | created_on | account_url | comment | managed_accounts | account_locator_url

The command output for organizations that span multiple region groups includes an additional region_group column:

| region_group | snowflake_region | name | edition  | created_on | account_url | comment | managed_accounts | account_locator_url

Column

Description

region_group

Region group where the account is located. Note: this column is only displayed for organizations that span multiple region groups.

snowflake_region

Snowflake Region where the account is located. A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. A Snowflake Region can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account).

name

Name of the account.

edition

Snowflake Edition of the account.

created_on

Date and time when the account was created.

account_url

Snowflake access URL that simplifies the older syntax of region_name and account_locator by using the user-friendly organization_name and account_name values instead.

comment

Comment for the account.

managed_accounts

Indicates whether the account is a managed account.

account_locator_url

Older Snowflake access URL syntax that includes the region_name and account_locator.

Examples

Show all the accounts whose name starts with myaccount:

SHOW ORGANIZATION ACCOUNTS LIKE 'myaccount%';