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

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.