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.
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).
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 doesn’t require a running warehouse to execute.
The command only returns objects for which the current user’s current role has been granted at least one access privilege.
The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.
To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.
The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.
The command returns a maximum of ten thousand records for the specified object type, as dictated by the access privileges for the role used to execute the command. Any records above the ten thousand records limit aren’t returned, even with a filter applied.
To view results for which more than ten thousand records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.
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¶+--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+ | 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 | +--------------+-------+-----------+---------+-------------------------------+--------------------------------------------+----------------------------------------+-----------+---------+----------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4