SHOW GLOBAL ACCOUNTS¶

Lists all the accounts in your organization and indicates the region in which each account is located.

Syntax¶

SHOW GLOBAL ACCOUNTS [ LIKE '<pattern>' ]

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%' ...

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.

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

| region_group | snowflake_region | created_on | name | comment |

Column	Description
`region_group`	Virtual Private Snowflake customers only: Region group where the account is located.
`snowflake_region`	Snowflake Region where the account is located.
`created_on`	Date and time when the account was created.
`name`	Name of the account.
`comment`	Comment for the account.

Show all the global accounts whose name starts with myaccount:

SHOW GLOBAL ACCOUNTS LIKE 'myaccount%';