Release

• v1.5.2(April 11, 2024)

  • Bump min SQLAlchemy to 1.4.19 for outer lateral join
  • Add support for sequence ordering in tests

Release

• Fixed a compatibility issue with Snowflake Behavioral Change 1057 on outer lateral join, for more details check https://docs.snowflake.com/en/release-notes/bcr-bundles/2023_04/bcr-1057.
• Fixed credentials with externalbrowser authentication not caching due to incorrect parsing of boolean query parameters.
  • This fixes other boolean parameter passing to driver as well.

Release

Added option to create a temporary stage command.
Added support for geometry type.
Fixed a compatibility issue of regex expression with SQLAlchemy 1.4.49.

Release

• Re-applied the application name of driver connection SnowflakeConnection to SnowflakeSQLAlchemy.
• SnowflakeDialect.get_columns now throws a NoSuchTableError exception when the specified table doesn't exist, instead of the more vague KeyError.
• Fixed a bug that dialect can not be created with empty host name.
• Fixed a bug that sqlalchemy.func.now is not rendered correctly.

Release

• Bumped snowflake-connector-python dependency to newest version which supports Python 3.11.
• Reverted the change of application name introduced in v1.4.5 until support gets added.

Release

• Updated the application name of driver connection SnowflakeConnection to SnowflakeSQLAlchemy.

Release

• Fixed a bug that percent signs in a non-compiled statement should not be interpolated with emtpy sequence when executed.

Release

• Fixed a bug that SnowflakeDialect.normalize_name and SnowflakeDialect.denormalize_name could not handle empty string.
• Fixed a compatibility issue to vendor function sqlalchemy.engine.url._rfc_1738_quote as it is removed from SQLAlchemy v1.4.42.

Release

• Improved performance by standardizing string interpolations to f-strings.
• Improved reliability by always using context managers.

Release

• snowflake-sqlalchemy is now SQLAlchemy 2.0 compatible.
• Fixed a bug that DATE should not be removed from SnowflakeDialect.ischema_names.
• Fixed breaking changes introduced in release 1.4.0 that:
• changed the behavior of processing numeric, datetime and timestamp values returned from service.
• changed the sequence order of primary/foreign keys in list returned by inspect.get_foreign_keys and inspect.get_pk_constraint.