Categories:

Account & Session DDL

SHOW FAILOVER GROUPS

  • Lists each primary or secondary failover group in this account.

  • Lists primary failover groups in other accounts enabled for replication and failover to this account.

  • Lists secondary failover groups in other accounts linked to groups in this account.

See also:

CREATE FAILOVER GROUP , ALTER FAILOVER GROUP , DROP FAILOVER GROUP

In this Topic:

Syntax

SHOW FAILOVER GROUPS [ IN ACCOUNT <account> ]

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 function 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.

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      |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+
| 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     |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+
| 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       |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+------------+
Back to top