`apache-airflow-providers-ssh` dependency version incorectly specified for `apache-airflow-providers-sftp`

[ivan-toriya-precis]

Apache Airflow Provider(s)

sftp

Versions of Apache Airflow Providers

apache-airflow-providers-sftp==5.3.2
apache-airflow-providers-ssh<4.0.0

Apache Airflow version

2.10.2

Operating System

Linux

Deployment

Google Cloud Composer

Deployment details

No response

What happened

Traceback (most recent call last):
  File "/opt/python3.11/lib/python3.11/site-packages/airflow/providers/sftp/operators/sftp.py", line 149, in execute
    self.sftp_hook = SFTPHook(ssh_conn_id=self.ssh_conn_id)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/python3.11/lib/python3.11/site-packages/airflow/providers/sftp/hooks/sftp.py", line 119, in __init__
    super().__init__(*args, **kwargs)
TypeError: SSHHook.__init__() got an unexpected keyword argument 'host_proxy_cmd'

What you think should happen instead

apache-airflow-providers-sftp starting from v5.0.0 is using keyword argument introduced in apache-airflow-providers-ssh v4.0.0

Dependency version should be specified correctly

airflow/providers/sftp/pyproject.toml

Line 60 in 9f04812

"apache-airflow-providers-ssh>=2.1.0",

How to reproduce

1. Install apache-airflow-providers-sftp>=5.0.0
2. Create a task with

sftp_hook = SFTPHook(ssh_conn_id="sftp_doctor_glass")

3. See the error in the logs

Anything else

Initially spotted here: GoogleCloudPlatform/composer-local-dev#104

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[potiuk]

Ah nice catch. Feel free to make a PR fixing it!

[jroachgolf84]

Created a PR for this: #53100