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.