[Bug]: Snowflake SQLAlchemy Dependency Issue

[MinuraPunchihewa]

Short description of current behavior

Similar to the previous issue we had with installing the dependencies for the ClickHouse integration due to the fact that the clickhouse-sqlalchemy package does not support SQLAlchemy 2, the same problem applies to the Snowflake integration as well with the snowflake-sqlalchemy package. As git is not installed in our Docker image, the fork that has been created cannot be installed.

Unlike the fix applied to the Clickhouse integration, however, the official package still does not seem to support SQLAlchemy 2.

Video or screenshots

No response

Expected behavior

Installation of the dependencies for Snowflake should run without running into errors.

How to reproduce the error

No response

Anything else?

No response

[ZoranPandovski]

Can you check if the snowflake-sqlalchemy was updated so we can avoid using the forked repo?

[MinuraPunchihewa]

@ZoranPandovski I will keep this open until the new version of snowflake_sqlalchemy with support for SQLAlchemy 2 is released.

[ZoranPandovski]

Keeping this for reference snowflakedb/snowflake-sqlalchemy#380