archiero opened a new issue, #28419:
URL: https://github.com/apache/airflow/issues/28419

   ### Apache Airflow version
   
   Other Airflow 2 version (please specify below)
   
   ### What happened
   
   I'm working with Apache-Airflow 2.2.2 using both MWAA in Amazon and on my 
local Lubuntu machine (booting from a USB stick on a Windows 10 Surface Pro). I 
followed the guide below to connect to Snowflake and it didn't work either 
place with the exact same error message of "[Errno -2] Name or service not 
known". I've attached the log file from my machine, the dag that fails, and 
requirements file for both. 
   
   Side note, you'll notice that I have a Python operator that connects using 
the snowflake.connector module to log into the database. It works just fine but 
my superiors have said that they'd prefer the SnowflakeHook or SnowflakeOperator
   
   
https://community.snowflake.com/s/article/How-to-connect-Apache-Airflow-to-Snowflake-and-schedule-queries-jobs
   
[ExampleFailureSnowflake.log](https://github.com/apache/airflow/files/10248044/ExampleFailureSnowflake.log)
   
[requirements.txt](https://github.com/apache/airflow/files/10248047/requirements.txt)
   
[test_snowflake_connection_dag.txt](https://github.com/apache/airflow/files/10248060/test_snowflake_connection_dag.txt)
   
   ### What you think should happen instead
   
   It should connect to Snowflake
   
   ### How to reproduce
   
   Run the dag with the same requirements file
   
   ### Operating System
   
   MWAA and Lubuntu 22.10 on USB stick with main hardrive of Windows 10 pro
   
   ### Versions of Apache Airflow Providers
   
   2.2.2
   
   ### Deployment
   
   MWAA
   
   ### Deployment details
   
   MWAA (main) and virtualenv (Python 3.10) on the Lubuntu stick
   
   ### Anything else
   
   Literally every time I attempt to use SnowflakeHook and SnowflakeOperator 
but never when I use snowflake.connector.
   
   ### Are you willing to submit PR?
   
   - [ ] 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: commits-unsubscr...@airflow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to