❗ If you need urgent assistance then file a case with Snowflake Support.
Otherwise continue here.

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

   Any (e.g. Python 3.14.2 (main, Dec 5 2025, 20:23:00) [Clang 21.1.4 ])

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

   Any (e.g. Linux-6.8.0-90-generic-x86_64-with-glibc2.39)

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

asn1crypto==1.5.1
boto3==1.42.46
botocore==1.42.46
certifi==2026.1.4
cffi==2.0.0
charset-normalizer==3.4.4
cryptography==46.0.5
filelock==3.20.3
greenlet==3.3.1
idna==3.11
jmespath==1.1.0
packaging==26.0
platformdirs==4.5.1
pycparser==3.0
pyjwt==2.11.0
pyopenssl==25.3.0
python-dateutil==2.9.0.post0
pytz==2025.2
requests==2.32.5
ruff==0.15.0
s3transfer==0.16.0
six==1.17.0
snowflake-connector-python==4.2.0
-e file:///home/USER/repositories/snowflake-sqlalchemy
sortedcontainers==2.4.0
sqlalchemy==2.1.0b1
tomlkit==0.14.0
typing-extensions==4.15.0
urllib3==1.26.20

4. What did you do?

   1. Install any SQLAlchemy version that has a string in the version, e.g. 2.0.5.post1 or 2.1.0b1.
   2. Run src/snowflake/sqlalchemy/compat.py
   3. Observe ValueError: invalid literal for int() with base 10: '0b1'

5. What did you expect to see?

   The script should run without erroring out.

6. Can you set logging to DEBUG and collect the logs?

   Unnecessary.