- Categories:
SHOW GLOBAL ACCOUNTS¶
Lists all the accounts in your organization and indicates the region in which each account is located.
- See also:
Syntax¶
SHOW GLOBAL 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¶
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:
| region_group | snowflake_region | created_on | name | comment |
Column |
Description |
---|---|
|
Virtual Private Snowflake customers only: Region group where the account is located. |
|
Snowflake Region where the account is located. |
|
Date and time when the account was created. |
|
Name of the account. |
|
Comment for the account. |
Examples¶
Show all the global accounts whose name starts with myaccount
:
SHOW GLOBAL ACCOUNTS LIKE 'myaccount%';