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 ScheduleDLQ receives them.
  • Preserve that queue and limit execution-role access to Scheduler, the supplied Glue job, and the queue.

Part of DEA-C01 preparation