REPLICATION_GROUP_USAGE_HISTORY view¶

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.

The REPLICATION_GROUP_USAGE_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the replication history for replication and failover groups in your organization within a specified date range. The view includes the name of the replication or failover group, credits consumed, and bytes transferred for replication.

Columns¶

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization where the usage took place.
ACCOUNT_NAME	VARCHAR	Name of the account where the usage took place.
ACCOUNT_LOCATOR	VARCHAR	Name of the account locator.
REGION	VARCHAR	Name of the region where the account is located.
USAGE_DATE	DATE	Date (in the UTC time zone) of this usage record.
REPLICATION_GROUP_NAME	VARCHAR	Name of the replication or failover group.
REPLICATION_GROUP_ID	NUMBER	Internal/system-generated identifier for the replication or failover group.
CREDITS_USED	NUMBER	Total number of credits used for replication during the USAGE_DATE.
BYTES_TRANSFERRED	NUMBER	Number of bytes transferred for replication during the USAGE_DATE.

Usage notes¶

Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).