Categories:

Information Schema , Table functions

REPLICATION_GROUP_REFRESH_HISTORY, REPLICATION_GROUP_REFRESH_HISTORY_ALL¶

You can use the REPLICATION_GROUP_REFRESH_HISTORY family of table functions to query the replication history for one secondary replication or failover group, or all such groups.

By default (when no date-range arguments are provided), these functions return data for the last 12 hours. You can use the optional DATE_RANGE_START and DATE_RANGE_END arguments to query a custom range within the 14-day retention window.

See also:

REPLICATION_GROUP_REFRESH_HISTORY view

Syntax¶

REPLICATION_GROUP_REFRESH_HISTORY(
      '<secondary_group_name>'
      [ , DATE_RANGE_START => <constant_expr> ]
      [ , DATE_RANGE_END => <constant_expr> ] )

REPLICATION_GROUP_REFRESH_HISTORY_ALL(
      [ DATE_RANGE_START => <constant_expr> ]
      [ , DATE_RANGE_END => <constant_expr> ] )

Arguments¶

'secondary_group_name'

Name of the secondary group. The entire name must be enclosed in single quotes. Required for REPLICATION_GROUP_REFRESH_HISTORY. Not used with REPLICATION_GROUP_REFRESH_HISTORY_ALL.

The following arguments are optional for both functions.

DATE_RANGE_START => constant_expr ,
DATE_RANGE_END => constant_expr

The date/time range for which to return replication refresh history.

• If neither a start date nor an end date is specified, the default is the last 12 hours.
• If a start date is specified but no end date, CURRENT_DATE at midnight is used as the end of the range.
• If an end date is specified but no start date, the range starts 12 hours prior to the start of DATE_RANGE_END.

Data is retained for 14 days. If the requested range extends beyond the 14-day retention window, the function returns an error.

Output¶

The function returns the following columns. REPLICATION_GROUP_REFRESH_HISTORY_ALL has additional columns that are the first two columns in the result set.

Usage notes¶

• When no DATE_RANGE_START or DATE_RANGE_END arguments are provided, the functions return data for the last 12 hours. To retrieve data beyond the last 12 hours, specify the date range explicitly. Data is available for up to 14 days.

• Only returns rows for a role with any privilege on the replication or failover group.

• Only returns rows for a secondary replication or failover group in the current account.

• When calling an Information Schema table function, the session must have an INFORMATION_SCHEMA schema in use or the function name must be fully-qualified. For more details, see Snowflake Information Schema.

• The following is the list of phases in the order processed:

  #	Phase name	Description
  1	SECONDARY_SYNCHRONIZING_MEMBERSHIP	The secondary replication or failover group receives information from the primary group about the objects included in the group, and updates its membership metadata.
  2	SECONDARY_UPLOADING_INVENTORY	The secondary replication or failover group sends an inventory of its objects in the target account to the primary group.
  3	PRIMARY_UPLOADING_METADATA	The primary replication or failover group creates a snapshot of metadata in the source account and sends it to the secondary group.
  4	PRIMARY_UPLOADING_DATA	The primary replication or failover group copies the files the secondary group needs to reconcile any deltas between the objects in the source and target accounts.
  5	SECONDARY_DOWNLOADING_METADATA	The secondary replication or failover group applies the snapshot of the metadata that was sent by the primary. The metadata updates are not applied atomically and instead applied over time.
  6	SECONDARY_DOWNLOADING_DATA	The secondary replication or failover group copies the files sent by the primary group to the target account.
  7	COMPLETED / FAILED / CANCELED	Refresh operation status.

  Expand

  Show lessSee more

Examples¶

To retrieve the refresh history for secondary group myfg, execute the following statement.

SELECT phase_name, start_time, end_time,
       total_bytes, object_count, error
  FROM TABLE(
      INFORMATION_SCHEMA.REPLICATION_GROUP_REFRESH_HISTORY('myfg')
  );

To retrieve the refresh history for the last 12 hours (default) for all failover groups and replication groups, execute the following statement:

SELECT phase_name, start_time, end_time,
       total_bytes, object_count, error
  FROM TABLE(
      INFORMATION_SCHEMA.REPLICATION_GROUP_REFRESH_HISTORY_ALL()
  );

To retrieve the refresh history for the last 7 days for all groups:

SELECT phase_name, start_time, end_time,
       total_bytes, object_count, error
  FROM TABLE(
      INFORMATION_SCHEMA.REPLICATION_GROUP_REFRESH_HISTORY_ALL(
          DATE_RANGE_START => DATEADD(D, -7, CURRENT_DATE),
          DATE_RANGE_END => CURRENT_DATE)
  );

To retrieve the refresh history for a specific date range for secondary group myfg:

SELECT phase_name, start_time, end_time,
       total_bytes, object_count, error
  FROM TABLE(
      INFORMATION_SCHEMA.REPLICATION_GROUP_REFRESH_HISTORY(
          'myfg',
          DATE_RANGE_START => '2025-04-01',
          DATE_RANGE_END => '2025-04-07')
  );