mariotaddeucci opened a new issue #21218: URL: https://github.com/apache/airflow/issues/21218
### Description Actually the `GenericTransfer` gets the hook based on connection's config. The cloud providers have multiple hooks with the same connection. Specifying a parameter `destination_hook` that receive the Hook class, we can set which hook we want to use, turning easier create new SQL transfers just adding the method `insert_rows ` on hooks. This could replace the `SqlToS3Operator`, 'SQLToGoogleSheetsOperator' and `OracleToAzureDataLakeOperator` for example. ### Use case/motivation Makes easier to create new SQL transfers for cloud providers by using `GenericTransfer`. ### Related issues _No response_ ### Are you willing to submit a PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
