ModuleNotFoundError: No module named 'snowflake' in MWAA Airflow Version 2.2.2

[londhe849]

I am using Python snowflake.connector library to connect to snowflake from MWAA Airflow. The code is working fine in Airflow version 2.0.2.
Now I am upgrading MWAA Airflow version to 2.2.2 and trying to execute the same code to connect to snowflake. I created new Airflow environment with version 2.2.2.
My requirements.txt file is as shown below:

apache-airflow==2.2.2
apache-airflow-providers-snowflake==2.3.0
snowflake-connector-python==2.7.0
snowflake-sqlalchemy==1.2.4
pandas==1.4.3

But I am getting error with Snowflake module on Airflow UI as shown below:

 **File "/usr/local/airflow/dags/shared/modules/connect_to_snowflake.py", line 11, in <module>
    import snowflake.connector as sf
ModuleNotFoundError: No module named 'snowflake'**

Also, I am not able to view any AWS cloudwatch logs. I did not find any details about snowflake changes from Airflow version 2.0.2 to 2.2.2. Can anyone help me to resolve this issue?

Note: Below is my requirements.txt file for MWAA Airflow version 2.0.2.:

apache-airflow==2.0.2
snowflake-connector-python

[Taragolis]

Hey @londhe849 !

I have check on my personal MWAA cluster your requirements and found found this error in CloudWatch logs

ERROR: Could not find a version that satisfies the requirement pandas==1.4.3 (from versions: 0.1, 0.2, 0.3.0, 0.4.0, 0.4.1, 0.4.2, 0.4.3, 0.5.0, 0.6.0, 0.6.1, 0.7.0, 0.7.1, 0.7.2, 0.7.3, 0.8.0, 0.8.1, 0.9.0, 0.9.1, 0.10.0, 0.10.1, 0.11.0, 0.12.0, 0.13.0, 0.13.1, 0.14.0, 0.14.1, 0.15.0, 0.15.1, 0.15.2, 0.16.0, 0.16.1, 0.16.2, 0.17.0, 0.17.1, 0.18.0, 0.18.1, 0.19.0, 0.19.1, 0.19.2, 0.20.0, 0.20.1, 0.20.2, 0.20.3, 0.21.0, 0.21.1, 0.22.0, 0.23.0, 0.23.1, 0.23.2, 0.23.3, 0.23.4, 0.24.0, 0.24.1, 0.24.2, 0.25.0, 0.25.1, 0.25.2, 0.25.3, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, 1.1.5, 1.2.0, 1.2.1, 1.2.2, 1.2.3, 1.2.4, 1.2.5, 1.3.0, 1.3.1, 1.3.2, 1.3.3, 1.3.4, 1.3.5) | ERROR: Could not find a version that satisfies the requirement pandas==1.4.3 (from versions: 0.1, 0.2, 0.3.0, 0.4.0, 0.4.1, 0.4.2, 0.4.3, 0.5.0, 0.6.0, 0.6.1, 0.7.0, 0.7.1, 0.7.2, 0.7.3, 0.8.0, 0.8.1, 0.9.0, 0.9.1, 0.10.0, 0.10.1, 0.11.0, 0.12.0, 0.13.0, 0.13.1, 0.14.0, 0.14.1, 0.15.0, 0.15.1, 0.15.2, 0.16.0, 0.16.1, 0.16.2, 0.17.0, 0.17.1, 0.18.0, 0.18.1, 0.19.0, 0.19.1, 0.19.2, 0.20.0, 0.20.1, 0.20.2, 0.20.3, 0.21.0, 0.21.1, 0.22.0, 0.23.0, 0.23.1, 0.23.2, 0.23.3, 0.23.4, 0.24.0, 0.24.1, 0.24.2, 0.25.0, 0.25.1, 0.25.2, 0.25.3, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, 1.1.5, 1.2.0, 1.2.1, 1.2.2, 1.2.3, 1.2.4, 1.2.5, 1.3.0, 1.3.1, 1.3.2, 1.3.3, 1.3.4, 1.3.5)

You could try this requirements.txt it should work.

apache-airflow-providers-snowflake==2.3.0
snowflake-connector-python==2.7.0
snowflake-sqlalchemy==1.2.4

Seems like AWS might use their own PyPI repo. I've would recommend to ask AWS Support for question related MWAA or try to find it in MWAA User Guide
Unfortunately no one outside of AWS know what actually happen inside of MWAA.