SHOW ORGANIZATION ACCOUNTS¶

Lists all the accounts in your organization, excluding managed accounts.

See also:: SHOW REPLICATION ACCOUNTS, SHOW MANAGED ACCOUNTS

Syntax¶

SHOW ORGANIZATION ACCOUNTS [ LIKE '<pattern>' ]

Parameters¶

LIKE 'pattern'

Filters the command output by account identifier. The pattern can match the account name or the account locator. 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 Snowflake 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:

| organization_name | account_name | snowflake_region | edition  | account_url | created_on | comment | account_locator | account_locator_url | managed_accounts | consumption_billing_entity_name | marketplace_consumer_billing_entity_name | marketplace_provider_billing_entity_name | old_account_url | is_org_admin |

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

| organization_name | account_name | region_group | snowflake_region | edition  | account_url | created_on | comment | account_locator | account_locator_url | managed_accounts | consumption_billing_entity_name | marketplace_consumer_billing_entity_name | marketplace_provider_billing_entity_name | old_account_url | is_org_admin |

Column	Description
`organization_name`	Name of the organization.
`account_name`	User-defined name that identifies an account within the organization.
`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).
`edition`	Snowflake Edition of the account.
`account_url`	Preferred Snowflake access URL that includes the values of organization_name and account_name.
`created_on`	Date and time when the account was created.
`comment`	Comment for the account.
`account_locator`	System-assigned identifier of the acccount.
`account_locator_url`	Legacy Snowflake access URL syntax that includes the region_name and account_locator.
`managed_accounts`	Indicates how many managed accounts have been created by the account.
`consumption_billing_entity_name`	Name of the consumption billing entity.
`marketplace_consumer_billing_entity_name`	Name of the marketplace consumer billing entity.
`marketplace_provider_billing_entity_name`	Name of the marketplace provider billing entity.
`old_account_url`	The previous account URL for a given account.
`is_org_admin`	Indicates whether the ORGADMIN role is enabled in an account. If TRUE, the role is enabled.

Examples¶

Show all the accounts whose name starts with myaccount:

SHOW ORGANIZATION ACCOUNTS LIKE 'myaccount%';