- Schema:
REPLICATION_GROUP_USAGE_HISTORY View¶
Standard & Business Critical Feature
Database and share replication are available to all accounts.
Replication of other account objects & failover/failback require Business Critical Edition (or higher). To inquire about upgrading, please contact Snowflake Support.
This Account Usage view can be used to query the replication history for a specified replication or failover group. The returned results include the replication or failover group name, credits consumed, and bytes transferred for replication. Usage data is retained for 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
START_TIME |
TIMESTAMP_LTZ |
The date and beginning of the hour (in the local time zone) in which the replication usage took place. |
END_TIME |
TIMESTAMP_LTZ |
The date and end of the hour (in the local time zone) in which the replication usage took place. |
REPLICATION_GROUP_NAME |
TEXT |
Name of the secondary 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 START_TIME and END_TIME window. |
BYTES_TRANSFERRED |
NUMBER |
Number of bytes transferred for replication during the START_TIME and END_TIME window. |
Usage Notes¶
Latency for the view may be up to 180 minutes (3 hours).
Results are only returned for secondary failover or replication groups in the current account (i.e. the target account).
If you want to reconcile the data in this view with a corresponding view in the ORGANIZATION USAGE schema, you must first set the timezone of the session to UTC. Before querying the Account Usage view, execute:
ALTER SESSION SET TIMEZONE = UTC;