Last modification time

Definition

The elapsed interval between the scan time and the timestamp of the most recent change to the database. This includes any change to the data (inserts, updates, deletes) as well as any change to the schema.

Source

metadata

Computation

The compute method depends on the database. Soda requires specific metadata fields that are different for every database.

No sampling used.

Exceptions

• In Redshift, adding columns is not part of last_modification_time.