DocumentationWorkfrontWorkfront Guide

Use the Monitoring Data Refreshes view in Data Connect

Last update: Wed Nov 19 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

The Monitoring Data Refreshes view displays the recent updates that were made to the data lake date during the most recent refresh. This view’s data is updated after each successful completion of a data load.

Due to the high volume of data and the complexity of the aggregations, the Monitoring Data Refreshes view only displays the object views that have been updated within the last 2 weeks. If a specific record type is absent in this view, it’s likely due to a lack of activity within that timeframe.

NOTE
This view displays a detailed collection of the data provided by the application and refresh activities as opposed to a daily history or event view that displays refresh activity history. To obtain historical refresh activity details, you can utilize the DL_LOAD_TIMESTAMP date object.

Monitoring Data Refreshes view columns

The Monitoring Data Refreshes view columns contain the following information:

Column Name
Type
Description
OBJ_TYPE
Varchar
The object type associated with the Workfront records sent to the data lake.
CALENDAR_DATE
Date
The date of the last successful data refresh for the object type displayed in the OBJ_TYPE column.
RECORD_LOAD_TIMESTAMP
Timestamp_NTZ
The date and time of the most recent data refresh for the object type displayed in the OBJ_TYPE column.
PREVIOUS_RECORD_LOAD_TIMESTAMP
Timestamp_NTZ
The date and time of the second most recent data refresh for the object type displayed in the OBJ_TYPE column.
MINUTES_SINCE_PREVIOUS_LOAD
Number
The amount of time in minutes that has elapsed since the last data refresh for the object type.
CREATED
Number
A count of the CREATE record events captured between the previous and latest data refreshes for the object type.
UPDATED
Number
A count of the UPDATE record events captured between the previous and latest data refreshes for the object type.
DELETED
Number
A count of the DELETE record events captured between the previous and latest data refreshes for the object type.
TOTAL
Number
A count of the total number of events between the previous and latest data refreshes for the object type.

Note: This is not the same as the total number of records impacted by CREATE, UPDATE, or DELETE events since the same record could be CREATED and UPDATED multiple times within the interval between refreshes.
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43