REPLICATION_GROUPS View¶

This Information Schema view displays a row for each primary and secondary replication and/or failover group in your organization.

Note

This view uses Snowflake terminology of “database”, whereas other Information Schema views use the standard INFORMATION_SCHEMA terminology of “catalog”. The two terms have the same meaning.

Columns¶

Column Name	Data Type	Description
REGION_GROUP	TEXT	Region group where the account that stores the replication or failover group is located.
SNOWFLAKE_REGION	TEXT	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	TIMESTAMP_LTZ	Date and time replication or failover group was created.
ACCOUNT_NAME	TEXT	Name of the account.
NAME	TEXT	Name of the replication or failover group.
TYPE	TEXT	Type of group. Valid values are `REPLICATION` or `FAILOVER`.
COMMENT	TEXT	Comment string.
IS_PRIMARY	TEXT	Indicates whether the replication or failover group is the primary group.
PRIMARY	TEXT	Name of the primary group.
OBJECT_TYPES	TEXT	List of specified object types enabled for replication (and failover in the case of a `FAILOVER` group).
ALLOWED_INTEGRATION_TYPES	TEXT	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	TEXT	List of accounts enabled for replication and failover.
ORGANIZATION_NAME	TEXT	Name of your Snowflake organization.
ACCOUNT_LOCATOR	TEXT	Account locator in a region.
REPLICATION_SCHEDULE	TEXT	Scheduled interval for refresh; NULL if no replication schedule is set.
SECONDARY_STATE	TEXT	Current state of scheduled refresh. Valid values are `started` or `suspended`. NULL if no replication schedule is set.
NEXT_SCHEDULED_REFRESH	TEXT	Date and time of the next scheduled refresh.
OWNER	TEXT	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.

Usage Notes¶

The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.