Deliver to many destinations in one run

Build the file once and send it everywhere it needs to go. Destinations run in the order listed. A destination whose profile has no target for the current environment is skipped and logged, so a prod-only archive doesn’t break a dev run.

Recorded from a real run: the deliveries the run recorded, one per destination.

reports/deliver_everywhere/deliver_everywhere.yml

queries: [fan_out_q]
output:
  format: xlsx
  destination:
    - {profile: local, path: "out/fan_out/regions-{{ run.date.yyyymmdd }}.xlsx"}
    - {profile: sftp_password, path: "/upload/fan_out/regions.xlsx"}
    - {profile: s3_keys, path: "s3://dre-demo/fan_out/regions.xlsx"}
    - {profile: gcs, path: "gs://dre-demo/fan_out/regions.xlsx"}
    - {profile: azure_cs, path: "az://dre-demo/fan_out/regions.xlsx"}
    - {profile: mail_local, to: finance@dre-demo.test, subject: "Regions {{ run.date.iso }}"}

terminal

dre run deliver_everywhere