SHOW FAILOVER GROUPS¶

Lists the primary and secondary failover groups in your account, as well as the failover groups in other accounts that are associated with your account.

For the other accounts:

Lists the primary failover groups enabled for replication and failover to this account.
Lists the secondary failover groups linked to groups in this account.

See also:: CREATE FAILOVER GROUP , ALTER FAILOVER GROUP , DROP FAILOVER GROUP

Syntax¶

SHOW FAILOVER GROUPS [ IN ACCOUNT <account> ]

Copy

Parameters¶

account: Specifies the identifier for the account. Account name is a unique identifier within your organization. For more details about account name, see Format 1 (preferred): Account name in your organization.

Usage notes¶

Executing this command requires a role with any one of the following privileges on a failover group:
- FAILOVER
- MONITOR
- OWNERSHIP
- REPLICATE
The output of SHOW FAILOVER GROUPS only includes groups of type FAILOVER.

Output¶

The command returns the following columns:

Column	Description
`region_group`	Region group where the account is located. Note: this column is only visible to organizations that span multiple Region groups.
`snowflake_region`	Snowflake Region where the account is located. A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. A Snowflake Region can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account).
`created_on`	Date and time failover group was created.
`account_name`	Name of the account.
`name`	Name of the failover group.
`type`	Type of group. Valid value is `FAILOVER`.
`comment`	Comment string.
`is_primary`	Indicates whether the failover group is the primary group.
`primary`	Name of the primary group.
`object_types`	List of specified object types enabled for replication and failover.
`allowed_integration_types`	A list of integration types that are enabled for replication. Snowflake always includes this column in the output even if integrations were not specified in the CREATE FAILOVER GROUP or ALTER FAILOVER GROUP command.
`allowed_accounts`	List of accounts enabled for replication and failover.
`organization_name`	Name of your Snowflake organization.
`account_locator`	Account locator in a region.
`replication_schedule`	Scheduled interval for refresh; NULL if no replication schedule is set.
`secondary_state`	Current state of scheduled refresh. Valid values are `started` or `suspended`. NULL if no replication schedule is set.
`next_scheduled_refresh`	Date and time of the next scheduled refresh.
`owner`	Name of the role with the OWNERSHIP privilege on the failover group. NULL if the failover group is in a different region.
`is_listing_auto_fulfillment_group`	TRUE if the replication group is used for Cross-Cloud Auto-Fulfillment. FALSE otherwise.

Examples¶

List failover groups in account myaccount1.

SHOW FAILOVER GROUPS IN ACCOUNT myaccount1;

+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+-----------------------------------+
| snowflake_region | created_on                    | account_name | name | type     | comment | is_primary | primary               | object_types                                | allowed_integration_types |  allowed_accounts                            | organization_name | account_locator   | replication_schedule | secondary_state | next_scheduled_refresh        | owner      | is_listing_auto_fulfillment_group |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+-----------------------------------+
| AWS_US_EAST_1    | 2021-10-25 19:08:15.209 -0700 | MYACCOUNT1   | MYFG | FAILOVER |         | true       | MYORG.MYACCOUNT1.MYFG | DATABASES, ROLES, USERS, WAREHOUSES, SHARES |                           | MYORG.MYACCOUNT1.MYFG,MYORG.MYACCOUNT2.MYFG  | MYORG             | MYACCOUNT1LOCATOR | 10 MINUTE            | NULL            |                               | MYROLE     | false                             |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+-----------------------------------+
| AWS_US_WEST_2    | 2021-10-25 19:08:15.209 -0700 | MYACCOUNT2   | MYFG | FAILOVER |         | false      | MYORG.MYACCOUNT1.MYFG |                                             |                           |                                              | MYORG             | MYACCOUNT2LOCATOR | 10 MINUTE            | STARTED         | 2022-03-06 12:10:35.280 -0800 | NULL       | false                             |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+-----------------------------------+

Copy