when i create a new table using common dataset, the values are correct. however, if i “accidentally” make change to leave duration from 0.5 to 1 as shown below.
A common dataset (CDS) is only synced when the source table was changed. Before moving data around, the sync algorithm checks if there have been any changes since the last sync. This is a measure to save system resources. The sync process is resource-heavy.
In order to prevent imported columns from being accidently modified, please lock them using the column permissions.