As an administrator, I want automated daily backups of MWAA metadata to S3

[jordanpadams]

Checked for duplicates

Yes - I have already checked

🧑‍🔬 User Persona(s)

System Administrator, Data Engineering

💪 Motivation

...so that I can automatically preserve Airflow configuration (Connections, Variables, DAG history) and quickly recover the system state in case of disaster without manual re-entry.

📖 Additional Details

Implement the mwaa_dr_backup_to_s3 DAG from the AWS MWAA Disaster Recovery tool to automate daily exports of the MWAA metadata database.

Implementation Requirements:

• Deploy the mwaa-dr package to the MWAA environment
• Configure the mwaa_dr_backup_to_s3 DAG for daily scheduled execution
• Ensure the MWAA Execution Role has S3 Write permissions to the backup bucket
• Configure S3 Lifecycle Policy to retain backups for 14 days
• Backup should include:
  • Airflow Connections
  • Airflow Variables
  • DAG run history

References

• AWS MWAA DR Tool: https://github.com/aws-samples/mwaa-disaster-recovery
• PyPI Package: https://pypi.org/project/mwaa-dr/
• Parent Theme: Implement Nucleus Disaster Recovery Strategy #198

---

For Internal Dev Team To Complete

Acceptance Criteria

Given the MWAA environment is running with configured DAGs
When the daily backup schedule triggers (or manual trigger)
Then a complete metadata backup is exported to the designated S3 bucket with timestamped path

⚙️ Engineering Details

To be filled by engineering team

🎉 I&T

To be filled by engineering team