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.