Displays information about replication groups and failover 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.
SHOW REPLICATION GROUPS [ IN ACCOUNT <account> ]
Copy
Parameters¶account
Specifies the identifier for the account.
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 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.
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
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