Schema:

ACCOUNT_USAGE

REPLICATION_GROUP_USAGE_HISTORY view¶

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 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;
    
    Copy