SHOW MANAGED ACCOUNTSΒΆ
Lists the managed accounts created for your account. Currently used by data providers to create reader accounts for their consumers. For more details, see Manage reader accounts.
- See also:
SyntaxΒΆ
SHOW MANAGED ACCOUNTS [ LIKE '<pattern>' ]
ParametersΒΆ
LIKE 'pattern'
Optionally 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%' ...
. Default: No value (no filtering is applied to the output).
Usage notesΒΆ
The command can be executed by users with the ACCOUNTADMIN role (or a role that has been granted the MONITOR USAGE global privilege).
Columns that start with the prefix
is_
return eitherY
(yes) orN
(no).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 managed account properties and metadata in the following columns:
Column |
Description |
---|---|
|
Name of the account. |
|
Cloud in which the managed account is located. For reader accounts, this is always the same as the cloud for the provider account. |
|
Region in which the managed account is located. For reader accounts, this is always the same as the region for the provider account. |
|
Legacy identifier for the account. |
|
Date and time when the managed account was created. |
|
Account URL that is used to connect to the account, in the account name format. The account identifier in this format follows the pattern |
|
Account URL that is used to connect to the account, in the legacy account locator format. |
|
Specifies whether the managed account is a reader account (for sharing data). |
|
Comment for the managed account. |
|
Region group in which the managed account is located. |
ExamplesΒΆ
SHOW MANAGED ACCOUNTS;
+--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+
| name | cloud | region | locator | created_on | url | account_locator_url | is_reader | comment | region_group |
|--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------|----------------|
| ACCT1 | aws | us-west-2 | RE47190 | 2018-05-30 14:38:54.479 -0700 | https://bazco-acct1.snowflakecomputing.com | https://re47190.snowflakecomputing.com | true | | PUBLIC |
+--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+