SHOW LISTINGS IN FAILOVER GROUP¶

Shows the listings in a failover group.

See also:: SHOW DATABASES IN FAILOVER GROUP, SHOW SHARES IN FAILOVER GROUP

Syntax¶

SHOW LISTINGS IN FAILOVER GROUP <name>

Parameters¶

name: Specifies the identifier for the failover group.

Access control requirements¶

To review the roles that are required to monitor replication and failover on group objects in the system, see Replication privileges.

Usage notes¶

Executing this command requires a role with either the OWNERSHIP or MONITOR privilege on the failover group. The command only returns objects for which the current user’s current role has been granted at least one access privilege.
To retrieve the list of failover groups in your organization, use SHOW FAILOVER GROUPS.

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.

For example, you can use the pipe operator or RESULT_SCAN function to select specific columns from the SHOW command output or filter the rows.

When you refer to the output columns, use double-quoted identifiers for the column names. For example, to select the output column type, specify SELECT "type".

You must use double-quoted identifiers because the output column names for SHOW commands are in lowercase. The double quotes ensure that the column names in the SELECT list or WHERE clause match the column names in the SHOW command output that was scanned.

Output¶

The command output provides listing properties and metadata in the following columns:


Column	Description
`global_name`	Global name of the listing
`name`	Name specified when the listing was created.
`title`	Title specified in the listing manifest.
`subtitle`	Sub title specified in the listing manifest.
`profile`	Provider profile name as specified in the listing manifest.
`created_on`	Date and time when the listing was created.
`updated_on`	Date and time when the listing was last updated.
`published_on`	Date and time when the listing was last published.
`state`	State of the listing, one of: DRAFT PUBLISHED UNPUBLISHED
`review_state`	Review state for public listings only, one of: UNSENT PENDING REJECTED APPROVED CANCELLED
`comment`	Associated comment, if present.
`owner`	Listing owner.
`owner_role_type`	Owner role type.
`regions`	List of regions where a public listing is available.
`target_accounts`	Comma separated list of target accounts.
`is_monetized`	Is monetized flag.
`is_application`	Is application flag. If `true` a Snowflake Native App is attached to the listing.
`is_targeted`	Is targeted flag.
`is_limited_trial`	Whether the listing is available for limited trial before purchasing.
`is_by_request`	Whether the listing is a personalized listing.
`distribution`	Whether the listing is an EXTERNAL or ORGANIZATION listing.
`is_mountless_queryable`	Whether the listing can be queried by a consumer without mounting using the Uniform Listing Locator (ULL) for the listing.
`rejected_on`	Date and time when the public listing for approval was last rejected.
`organization_profile_name`	The profile associated with the ORGANIZATION listing.
`uniform_listing_locator`	The ULL tha allows consumers to access the organization listing without mounting.
`detailed_target_accounts`	Private listing target account details with company name included.
`compliance_badges`	List of compliance certifications that were approved by Snowflake’s compliance team for the listing, if any. Available certifications include: SOC2 HIPAA ISO27001

Examples¶

List the listings in the failover group myfg:

SHOW LISTINGS IN FAILOVER GROUP myfg;