search

snowflakedb / snowflake-sqlalchemy

Snowflake SQLAlchemy
https://pypi.python.org/pypi/snowflake-sqlalchemy/
Apache License 2.0
235 stars 152 forks source link

SNOW-1822242: AttributeError: module 'snowflake.sqlalchemy.snowdialect' has no attribute 'BOOLEAN' #549

Open NathanFarmer opened 3 days ago

NathanFarmer commented 3 days ago
  1. What version of Python are you using?

3.12.7

  1. What operating system and processor architecture are you using?

macOS-14.7.1-arm64-arm-64bit

  1. What are the component versions in the environment (pip freeze)?

asn1crypto==1.5.1 certifi==2024.8.30 cffi==1.17.1 charset-normalizer==3.4.0 cryptography==43.0.3 filelock==3.16.1 idna==3.10 packaging==24.2 platformdirs==4.3.6 pycparser==2.22 PyJWT==2.10.0 pyOpenSSL==24.2.1 pytz==2024.2 requests==2.32.3 snowflake-connector-python==3.12.3 snowflake-sqlalchemy==1.7.0 sortedcontainers==2.4.0 SQLAlchemy==2.0.36 tomlkit==0.13.2 typing_extensions==4.12.2 urllib3==2.2.3

  1. What did you do?
>> python3.12 -m venv snowflake-sqlalchemy && source snowflake-sqlalchemy/bin/activate
>> pip install snowflake-sqlalchemy==1.7.0
>> python
>> from snowflake.sqlalchemy import snowdialect
>> snowdialect.BOOLEAN
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: module 'snowflake.sqlalchemy.snowdialect' has no attribute 'BOOLEAN'
  1. What did you expect to see?
>> python3.12 -m venv snowflake-sqlalchemy && source snowflake-sqlalchemy/bin/activate
>> pip install 'snowflake-sqlalchemy<1.7.0'
>> python
>> from snowflake.sqlalchemy import snowdialect
>> snowdialect.BOOLEAN
<class 'sqlalchemy.sql.sqltypes.BOOLEAN'>
sfc-gh-dszmolka commented 2 days ago

we'll check this, thank you for reporting!

sfc-gh-dszmolka commented 1 day ago

fix incoming on https://github.com/snowflakedb/snowflake-sqlalchemy/pull/551

sfc-gh-dszmolka commented 1 day ago

change is merged, but reopening this issue to be able to properly track the release