DW_UPDATED_ON

Business Definition

The "DW_UPDATED_ON" column in the ACTIVITY_ATTEMPT_FACT table represents the most recent time a student activity attempt record was updated in the data warehouse. This timestamp is crucial for tracking the freshness of data and is often used in analysis and reporting to ensure that the latest information is being considered. It's important to note that this timestamp is updated every time the record is modified, so it reflects the last change made to the data, not necessarily the time of the student's activity attempt.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T01:12:44.299000 by VISHAL.PATIL@IMAGINELEARNING.COM