If a Caboodle table uses snapshot change tracking, will all its columns be snapshot columns?

In a Caboodle data model, when a table employs snapshot change tracking, it does not necessarily mean that all columns in that table will be designated as snapshot columns.

Snapshot change tracking is a mechanism used to record changes to data over time, primarily for auditing, historical reporting, or synchronization purposes. A table can have a mix of snapshot columns and standard columns depending on the requirements of the business logic and the intent for data tracking.

Typically, only certain columns that are relevant for tracking changes — such as keys, timestamps, or specific attributes — are marked as snapshot columns. Other columns may remain as regular data without change tracking. Therefore, the option stating that not all columns are snapshotted aligns well with the operational design and flexibility provided by the Caboodle architecture.

Each column's designation as a snapshot or non-snapshot column is often determined based on specific needs rather than a blanket approach that includes every column in the table. This targeted approach helps optimize performance and manage storage effectively by avoiding unnecessary tracking of every piece of data.