SHOW REPLICATION GROUPS¶

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

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

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

See also:

CREATE REPLICATION GROUP , ALTER REPLICATION GROUP , DROP REPLICATION GROUP

Syntax¶

SHOW REPLICATION GROUPS [ IN ACCOUNT <account> ]
Copy

Parameters¶

account

Specifies the identifier for the account.

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 replication or failover group was created.

account_name

Name of the account.

name

Name of the replication or failover group.

type

Type of group. Valid values are REPLICATION or FAILOVER.

comment

Comment string.

is_primary

Indicates whether the replication or failover group is the primary group.

primary

Name of the primary group.

object_types

List of specified object types enabled for replication (and failover in the case of a FAILOVER group).

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 <object> or ALTER <object> 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 replication or failover group. NULL if the replication or 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.

Usage notes¶

  • Executing this command requires a role with any one of the following privileges on a replication group:

    • MONITOR

    • OWNERSHIP

    • REPLICATE

  • The output of SHOW REPLICATION GROUPS includes groups of types FAILOVER and REPLICATION.

  • 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 RESULT_SCAN function, which treats the output as a table that can be queried.

Examples¶

List replication groups in myaccount1:

SHOW REPLICATION 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            |                 |                               | 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
Language: English