Redshift → UNLOAD → S3 → Partner SFTP (Reverse ETL)

A scheduled workflow runs a Redshift query (or uses a view), then `UNLOAD`s results to S3 (compressed CSV or Parquet; optionally KMS-encrypted). A packaging task renames files with a strict pattern (e.g., `partnerA/orders_YYYYMMDD.csv.gz`), emits a manifest (row count, byte size), and generates a checksum; PGP encryption can be applied when required. A delivery task uploads to the partner’s SFTP with retries and verifies completion. All artifacts and logs are persisted to S3 for audit, and alerts fire on failure.