Replication views and functions: New refresh phase SECONDARY_COMMITTING (Preview)¶

Before the change:

Views and functions related to replication show report SECONDARY_DOWNLOADING_DATA as the last phase before a refresh job is marked as COMPLETED, FAILED, or CANCELED.

After the change:

When this behavior change bundle is enabled, the views and functions that report progress and history for account replication operations include a new value in the phase_name column: SECONDARY_COMMITTING. This phase happens after SECONDARY_DOWNLOADING_DATA and before the final phase where the refresh job is marked as COMPLETED, FAILED, or CANCELED. During the SECONDARY_COMMITTING phase, Snowflake applies the changes to tables from the data files that were transmitted from the primary account.

The output of history-related replication table functions includes a new column committed_object_count. This value represents the number of tables that have been processed during the associated refresh operation:

• The subfields have the same names as the subfields in the object_count column.

• This column appears in the result set of the table functions, but not in the views for refresh history.

The output of progress-related replication table functions includes new subfields in the progress and details columns:

• The progress column shows the percentage of tables that finished replicating. This value reflects only the number of tables that were replicated, not other kinds of objects.

• The details column reflects the same subfields, such as totalObjects and completedObjects, as the SECONDARY_DOWNLOADING_METADATA phase.