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.
CREATE FAILOVER GROUP , ALTER FAILOVER GROUP , DROP FAILOVER GROUP
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.
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.
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 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
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