harishkrao commented on issue #20032:
URL: https://github.com/apache/airflow/issues/20032#issuecomment-991978806
I narrowed down the scope of our issue here. Once I am inside the virtual
environment, and I try to import the same SQLAlchemy package, I run into the
same error:
`root@66ecbec1a1f0:/opt/airflow# python
Python 3.8.12 (default, Nov 17 2021, 17:26:17)
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from snowflake.sqlalchemy import URL
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/usr/local/lib/python3.8/site-packages/snowflake/sqlalchemy/__init__.py", line
25, in <module>
from . import base, snowdialect
File
"/usr/local/lib/python3.8/site-packages/snowflake/sqlalchemy/base.py", line 17,
in <module>
from .custom_commands import AWSBucket, AzureContainer, ExternalStage
File
"/usr/local/lib/python3.8/site-packages/snowflake/sqlalchemy/custom_commands.py",
line 14, in <module>
from sqlalchemy.sql.roles import FromClauseRole
ModuleNotFoundError: No module named 'sqlalchemy.sql.roles'
`
It looks like there is a bug with SQLAlchemy 1.3.24, which is a dependency
for Flask-AppBuilder. See
[1621](https://github.com/dpgaspar/Flask-AppBuilder/issues/1621) and
[953](https://github.com/pallets/flask-sqlalchemy/issues/953).
If you have some time spare, can one of you please try to import this
package in your local venv and let me know if you face the same issue? @potiuk
@mik-laj
This package is not being used anywhere else in the entire airflow
repository.
--
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]
