- Schema:
REPLICATION_GROUP_REFRESH_HISTORY View¶
This Account Usage view can be used to query the refresh history for a specified replication or failover group.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
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. |
PHASE_NAME |
TEXT |
Current phase in the replication operation. For the list of phases, see the Usage Notes. |
START_TIME |
TIMESTAMP_LTZ |
Time when the replication operation began. |
END_TIME |
TIMESTAMP_LTZ |
Time when the replication operation finished, if applicable. |
JOB_UUID |
TEXT |
Query ID for the refresh job. |
TOTAL_BYTES |
VARIANT |
A JSON object that provides detailed information about refreshed databases:
|
OBJECT_COUNT |
VARIANT |
A JSON object that provides detailed information about refreshed objects:
|
PRIMARY_SNAPSHOT_TIMESTAMP |
TIMESTAMP_LTZ |
Timestamp when the primary snapshot was created. |
ERROR |
VARIANT |
NULL if the refresh operation is successful. If the refresh operation fails, returns a JSON object that provides detailed information about the error:
|
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).