- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
REPLICATION_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
Organization Usage performance
When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in
Performance (Organization Usage): bound every scan on history views, list
columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.
This Organization Usage view displays a row for each replication group and failover group in each account in your organization.
The returned results include details such as the replication or failover group name, the types of objects that it applies to, and its schedule for replication refresh operations.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column Name | Data Type | Description |
|---|---|---|
| CREATED | TIMESTAMP_LTZ | Date and time the replication or failover group was created. |
| DELETED | TIMESTAMP_LTZ | Date and time the replication or failover group was deleted. |
| NAME | VARCHAR | Name of the replication or failover group. |
| TYPE | VARCHAR | Type of group. Valid values are REPLICATION or FAILOVER. |
| COMMENT | VARCHAR | Comment string. |
| 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 weren’t specified in the CREATE or ALTER command. |
| REPLICATION_SCHEDULE | VARCHAR | Scheduled interval for refresh; NULL if no replication schedule is set. |
| OWNER | VARCHAR | Name of the role with the OWNERSHIP privilege on the replication or failover group. |
| IS_LISTING_AUTO_FULFILLMENT_GROUP | BOOLEAN | TRUE if the replication group is used for Cross-Cloud Auto-Fulfillment. FALSE otherwise. |
| ERROR_INTEGRATION | VARCHAR | The name of the notification integration for the replication group or failover group to which the error notification is sent in cases of refresh failures. |
| IS_OPTIMIZED_REFRESH_ENABLED | BOOLEAN |
Available to all Business Critical Edition (or higher) accounts. TRUE if optimized refresh is enabled for the group. FALSE otherwise. Only failover groups support optimized refresh; for replication groups the column is always FALSE. |
Usage notes¶
- Latency for the view may be up to 240 minutes (4 hours).