...
The scheduler job vql_backup exports the VQL for everything on the dev VDP server every hour to a VQL file on the server. This is done by executing a query against the VDP server which returns the VQL of the database and in the format requested. Please refer to the guide above for an explanation of the query.
At 30 minutes every Every hour, a cron job on the dev server will copy query the webservice admin.get_all_vql and store the resulting file from the above job to the S3 bucket VQL file in tufts-denodo-devprod in the DEV PROD LZ. The bucket has versioning enabled, so each copy operation will create a new version of the file. A policy is in place to delete versions older than 30 days. This will allow us to access a copy of the servers VQL at every hour in the past 30 days. In addition to an hourly backup, a copy of the VQL at the beginning of each day will be saved as well, and kept for 365 days.
...
| Info |
|---|
Backups prior to 2023-10-19 can be accessed in the denodo-backups bucket in the DLT as long as that account is active. |
...