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