SQLAlchemy release notes for 2025

This article contains the release notes for the SQLAlchemy, including the following when applicable:

  • Behavior changes

  • New features

  • Customer-facing bug fixes

Snowflake uses semantic versioning for SQLAlchemy updates.

See Using the Snowflake SQLAlchemy toolkit with the Python Connector for documentation.

Version 1.7.3 (January 14, 2024)

New features and updates

  • Added the force_div_is_floordiv flag to override the new default value (False) for div_is_floor_div in SnowflakeDialect.

    • When force_div_is_floordiv is False, the division (/) operator is treated as a float division, while the // operator is treated as floor division.

    • This flag is added to maintain backward compatibility with the previous SnowflakeDialect behavior.

    • This flag will be removed in a future release, and SnowflakeDialect will use div_is_floor_div as False.

Bug fixes

  • Fixed an issue with support for the SqlAlchemy ARRAY,

  • Fixed the return value of snowflake get_table_names.

  • Fixed incorrect quoting of identifiers beginning with an underscore (_).

  • Fixed the “ARRAY type not supported in HYBRID tables” error.

Language: English