Corrected naming in system table EXA_DB_SNAPSHOTS
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20847 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.31.0 |
| Resolution Date | 2024-08-29 |
Background
Exasol Database supports snapshots and snapshot backups in SaaS installations and in the future for other installations as well. In the past, we did not properly differentiate between snapshots and snapshot backups with names. Specifically, we showed snapshots as snapshot backups in the system table EXA_DB_SNAPHSOTS.
Documentation for the system table EXA_DB_SNAPHSOTS could be found by link.
Improvement
This has been improved and snapshots are now correctly displayed as snapshots. An additional column has been added to show the CREATION_TIME of a snapshot.
Changed behavior
The system table EXA_DB_SNAPSHOTS now uses corrected column names SNAPSHOT_ID instead of BACKUP_ID and SNAPSHOT_NAME instead of BACKUP_NAME. An additional column CREATION_TIME has been added. All snapshots are now displayed correctly, i.e. the entries in the SNAPSHOT_NAME column contain only the word snapshot and not snapshot_backup.
