'airflow connection id with ssh tunnely

is there a way to pass postgres_conn_id that's having ssh tunel, the postgres_conn_id that I have also stores username/pem/ip of the ssh tunel, when I pass that postgres_conn_id to this operator it does not work, but I have used this postgres_conn_id with some helper created.

my question is, is there a way to use ssh tunel with default operator, like passing postgres_conn_id even if the connection added in airflow requires ssh tunel.

https://airflow.apache.org/docs/apache-airflow-providers-postgres/stable/_api/airflow/providers/postgres/operators/postgres/index.html



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source