rawwar opened a new issue, #43963: URL: https://github.com/apache/airflow/issues/43963
### Description Currently snowflake provider uses `requests` library in non-deferrable mode and `aiohttp` library in deferrable mode to make requests to snowflake URL. It does not have the config to disable SSL ### Use case/motivation Ability to disable ssl verification can help when connecting to Snowflake hosted via AWS private link. Often, in deferrable mode it causes following failure `certificate verify failed: Hostname mismatch, certificate is not valid`. While this works in non-deferrable mode. Disabling SSL verification can help when connecting to Snowflake hosted via an AWS private link. Often, in deferrable mode, it causes the following failure: `certificate verify failed: Hostname mismatch, certificate is not valid`, while ### Related issues NA ### 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]
