Categories:

Account & Session DDL

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

In this Topic:

Syntax

SHOW REPLICATION GROUPS [ IN ACCOUNT <account> ]

Parameters

account

Specifies the identifier for the account.

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.

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

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   |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+---------+
| 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  |
+------------------+-------------------------------+--------------+------+----------+---------+------------+-----------------------+---------------------------------------------+---------------------------+----------------------------------------------+-------------------+-------------------+----------------------+-----------------+-------------------------------+---------+
| 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