- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 06:20 AM
Hello @HoussemBL,
Here are a few points to consider:
-
Initialization of Generated Columns: Generated columns, such as
is_current, rely on the values of other columns (__END_ATin this case) to be correctly populated. During the first run, if the sequencing or initialization of these columns is not handled correctly, it can result in null values. -
Sequencing and Ordering: The
apply_changesfunction uses thesequence_bycolumn to determine the order of changes. If the sequencing is not correctly established during the first run, it can lead to issues with the generated columns. Ensure that thesequence_bycolumn (syncedin your case) is correctly populated and ordered.
When you fully refresh the pipeline, it reprocesses the data, which can correct the sequencing and initialization issues, leading to the correct computation of the generated column