Archive Cutoff
- Last UpdatedJul 05, 2024
- 1 minute read
For time-based tables, the Archive Cutoff field indicates how old the data must be before being archived (time-based tables contain a column named time).
The format is YY:MM:DD, where YY is the number of years old that the data must be, MM is the number of months, and DD is the number of days. For example, if the current time is 05-Feb‑19 14:35, when Archive runs, then the conditions that are indicated in the Archive Cutoff sample (time-based) table below apply.
Archive Cutoff sample (time-based)
|
Cutoff Specifier |
Possible Cutoff Dates and Times for Archived Data |
|---|---|
|
00:00:00 |
05‑Feb‑19 00:00 |
|
00:00:01 |
04‑Feb‑19 00:00 |
|
00:01:00 |
05‑Jan‑19 00:00 |
|
00:02:00 |
05‑Dec‑18 00:00 |
|
01:00:00 |
05‑Feb‑18 00:00 |
For non-time-based tables, the cutoff indicates the interval at which the entire table’s data must be archived. For example, consider the cutoff specifiers and possible archiving frequencies listed in the Archive Cutoff sample (non time-based) table below.
Archive Cutoff sample (non time-based)
|
Cutoff Specifier |
Possible Cutoff Periods for Archived Data |
|---|---|
|
00:00:01 |
Daily |
|
00:01:00 |
Monthly |
|
01:00:00 |
Yearly |
Note: The Archive end time is not a guarantee that data is archived up to the end time. It guarantees only that data younger than the end time is not archived. Refer to Archive intervals for more information.