Open shahargl opened 3 years ago
I'd be happy to provide asyncio SQLAlchemy support as an external contributor, but that would require asyncio support for the underlying connection, which doesn't look like it's coming any time soon https://github.com/snowflakedb/snowflake-connector-python/issues/38
Any updates?
Any update on this? Asyncio support would be a nice feature to add.
+1 We are also using snowflake and this has a significant negative affect on performance. We have to rely on workaround with multiprocessing/multithreading etc. The alternative of using snowflake connector directly means losing all the benefits of an ORM, which is unacceptable
bump
bump
hi folks, thanks for all the feedback. Prerequisite I guess would be the Snowflake PythonConnector to support asyncio (https://github.com/snowflakedb/snowflake-connector-python/issues/38) first.
What is the current behavior?
SQLAlchemy 1.4.0 introduced the asyncio extension that add the ability to run queries in paralell.
The following code should create async engine:
But instead it throws the following error:
What is the desired behavior?
The engine will be created successfully
How would this improve
snowflake-sqlalchemy
?It'll support running async queries
References, Other Background
https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html