Keep the nightly transform on local time
Try this labAll DEA-C01 practice
- Certification
- DEA-C01
- Format
- Artifact workspace
- Difficulty
- medium
- Estimated time
- 18 min
- Automated checks
- 10
SCENARIO
The existing orders-nightly Glue job must run at 02:15 Sydney time in incremental mode. Since its schedule migration, starts follow UTC, drift within a flexible window, and lack bounded retries. The execution role also grants wildcard access; ScheduleDLQ already provides encrypted failure retention.
TASK
Repair pipeline-schedule.yaml so one enabled orders-nightly-local schedule starts the job daily at 02:15 Australia/Sydney without delivery drift.
- Retry failed starts twice for up to 3600 seconds before
ScheduleDLQreceives them. - Preserve that queue and limit execution-role access to Scheduler, the supplied Glue job, and the queue.