REPLICATION_
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.