Rollsnaps

The Rolling Snapshot—or Rollsnap—account is a study access account for holding data extract tables equivalent to Stable accounts, except that data extraction has to be explicitly run to update its contents. A system-defined snapshot, Rollsnap, is created and automatically updated to reflect the Batch Validation timestamp at the last table refresh. Maintenance of this account can therefore be scheduled asynchronously with Batch Validation.

For instance, if Batch Validation runs nightly, the Rollsnap account could be refreshed on a weekly basis. If required, the Rollsnap account could be refreshed after each Batch Validation and always reflect the latest Stable account.

View definitions created as views and not tables in this account view their data as of the Snapshot timestamp and thus are consistent with the data extracted to tables. Under this structure, with appropriate privileges, database objects in this account can be accessed with the prefix Study$ROLLSNAP.