SHOW MANAGED ACCOUNTS¶
Provider sharing not enabled for all accounts
Provider sharing is enabled by default for most, but not all accounts.
If you encounter errors when attempting to share data with consumers, the feature may not be enabled for your account. To inquire about enabling it, please contact Snowflake Support.
Lists the managed accounts created for your account. Currently used by data providers to create reader accounts for their consumers. For more details, see Managing Reader Accounts.
- See also:
Syntax¶
SHOW MANAGED 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 can be executed by users with the ACCOUNTADMIN role (or a role that has been granted the MONITOR USAGE global privilege).
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:
| name | cloud | region | locator | created_on | url | is_reader | comment |
Column |
Description |
|---|---|
|
Internal identifier for the managed 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. |
|
Display name of the managed account; used for accessing the account through the web interface or client applications. Also used when adding the account to a share (for sharing data). |
|
Date and time when the managed account was created. |
|
URL for accessing the managed account, particularly through the web interface. |
|
Specifies whether the managed account is a reader account (for sharing data). |
|
Comment for the managed account. |
Examples¶
SHOW MANAGED ACCOUNTS;
+--------------+-------+-----------+---------+-------------------------------+----------------------------------------+-----------+---------+
| name | cloud | region | locator | created_on | url | is_reader | comment |
|--------------+-------+-----------+---------+-------------------------------+----------------------------------------+-----------+---------|
| READER_ACCT1 | aws | us-west-2 | RE47190 | 2018-05-30 14:38:54.479 -0700 | https://re47190.snowflakecomputing.com | true | |
+--------------+-------+-----------+---------+-------------------------------+----------------------------------------+-----------+---------+