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:: CREATE MANAGED ACCOUNT , DROP MANAGED ACCOUNT

Syntax¶

SHOW MANAGED ACCOUNTS [ LIKE '<pattern>' ]

Copy

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 either Y (yes) or N (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
`account_name`	Name of the account.
`cloud`	Cloud in which the managed account is located. For reader accounts, this is always the same as the cloud for the provider account.
`region`	Region in which the managed account is located. For reader accounts, this is always the same as the region for the provider account.
`account_locator`	Legacy identifier for the account.
`created_on`	Date and time when the managed account was created.
`account_url`	Account URL that is used to connect to the account, in the account name format. The account identifier in this format follows the pattern `<orgname>-<account_name>`.
`account_locator_url`	Account URL that is used to connect to the account, in the legacy account locator format.
`is_reader`	Specifies whether the managed account is a reader account (for sharing data).
`comment`	Comment for the managed account.
`region_group`	Region group in which the managed account is located.
`old_account_url`	If the original account URL was saved when the account was renamed, provides the original URL. If the original account URL was dropped, the value is NULL even if the account was renamed.
`account_old_url_saved_on`	If the original account URL was saved when the account was renamed, provides the date and time when the original account URL was saved.
`account_old_url_last_used`	If the original account URL was saved when the account was renamed, indicates the last time the account was accessed using the original URL.
`organization_old_url`	If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the original account URL. If the original account URL was dropped, the value is NULL even if the organization changed.
`organization_old_url_saved_on`	If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the date and time when the original account URL was saved.
`organization_old_url_last_used`	If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, indicates the last time the account was accessed using the original account URL.

Examples¶

SHOW MANAGED ACCOUNTS;

Copy

+--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+
| 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     |
+--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+