SHOW ORGANIZATION ACCOUNTS¶
Lists all the accounts in your organization, excluding 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 |
---|---|
|
Name of the organization. |
|
User-defined name that identifies an account within the organization. |
|
Region group where the account is located. Note: This column is only displayed for organizations that span multiple region groups. |
|
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). |
|
Snowflake Edition of the account. |
|
Preferred Snowflake access URL that includes the values of organization_name and account_name. |
|
Date and time when the account was created. |
|
Comment for the account. |
|
System-assigned identifier of the acccount. |
|
Legacy Snowflake access URL syntax that includes the region_name and account_locator. |
|
Indicates how many managed accounts have been created by the account. |
|
Name of the consumption billing entity. |
|
Name of the marketplace consumer billing entity. |
|
Name of the marketplace provider billing entity. |
|
The previous account URL for a given account. |
|
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%';