Skip to content

Releases: snowflakedb/snowflake-sqlalchemy

Release

21 Nov 20:40
0d0e686
Compare
Choose a tag to compare
  • v1.7.0(November 22, 2024)

    • Add support for dynamic tables and required options
    • Add support for hybrid tables
    • Fixed SAWarning when registering functions with existing name in default namespace
    • Update options to be defined in key arguments instead of arguments.
    • Add support for refresh_mode option in DynamicTable
    • Add support for iceberg table with Snowflake Catalog
    • Fix cluster by option to support explicit expressions
    • Add support for MAP datatype

Release

09 Jul 16:53
305d298
Compare
Choose a tag to compare
  • v1.6.1(July 9, 2024)

    • Update internal project workflow with pypi publishing
  • v1.6.0(July 8, 2024)

    • support for installing with SQLAlchemy 2.0.x
    • use hatch & uv for managing project virtual environments
  • v1.5.4

    • Add ability to set ORDER / NOORDER sequence on columns with IDENTITY

Release

17 Apr 04:30
8ea9ab9
Compare
Choose a tag to compare
  • v1.5.3(April 16, 2024)

    • Limit SQLAlchemy to < 2.0.0 before releasing version compatible with 2.0

Release

11 Apr 20:24
4db4b95
Compare
Choose a tag to compare
  • 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

02 Nov 19:52
61975bf
Compare
Choose a tag to compare
  • 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

24 Aug 18:28
ab1269d
Compare
Choose a tag to compare

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

21 Mar 20:22
b161892
Compare
Choose a tag to compare
  • 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

09 Feb 22:58
13f543d
Compare
Choose a tag to compare
  • 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

09 Dec 21:59
7c8effd
Compare
Choose a tag to compare
  • Updated the application name of driver connection SnowflakeConnection to SnowflakeSQLAlchemy.

Release

16 Nov 21:41
0c65ed6
Compare
Choose a tag to compare
  • Fixed a bug that percent signs in a non-compiled statement should not be interpolated with emtpy sequence when executed.