SSHConnection is examined and can be used in prod
The data will be put in the target by using SCP.
SSHConnection: https://airflow.apache.org/docs/apache-airflow-providers-ssh/stable/connections/ssh.html
which should allow to use SSHook and SFTPOperator: https://airflow.apache.org/docs/apache-airflow-providers-sftp/stable/_api/airflow/providers/sftp/operators/sftp/index.html#airflow.providers.sftp.operators.sftp.SFTPOperator