# What changed in snowflake-sqlalchemy

> 50 changes in snowflake-sqlalchemy 1 to 2 from its official release notes, upgrade guides and advisories: 15 breaking, 5 security, 16 new APIs and options. Each one cited. Sources checked 2026-10-25. HTML: https://unstale.sh/pypi/snowflake-sqlalchemy/

To see which of these apply to a repository, run `npx @unstale/cli init` in it.

## snowflake-sqlalchemy 2

### Breaking changes

- This connection parameter is now blocked from the URL query string. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The `/` operator always performs true division, while `//` always compiles to FLOOR(left / right), including integer floor division. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Structured-type JSON handling is enabled by default: reads deserialize JSON into native Python values, and writes serialize native values. Setting the flag to False restores raw JSON strings and emits a DeprecationWarning. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The dialect flag is removed, and passing it to create_engine() raises TypeError. Division operators now have fixed true-division and floor-division semantics. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The async dialect checks for greenlet when the engine is created and raises an ImportError with installation instructions if it is unavailable. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The legacy URL parameter opt-out is removed, and passing it to create_engine() raises TypeError; sensitive connection parameters must be passed via connect_args=. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Supported Python versions are now 3.11–3.14; Python 3.8, 3.9, and 3.10 are dropped because connector 5.x requires Python 3.11 or newer. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Connector 4.x is no longer supported; the dialect requires connector 5.x, which provides the async driver. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The environment variable is removed and has no effect; sensitive connection parameters must be passed via connect_args=. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- SQLAlchemy 1.4 is no longer supported; the dialect requires SQLAlchemy>=2.0.44,<2.1 because SQLAlchemy 2.1 removed APIs used by the dialect. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- This connection parameter is now blocked from the URL query string. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)

### Security

- ExternalStage paths, including sub-paths created with from_parent_stage, are safely escaped when quoting is required in compiled COPY INTO and staged-file SQL. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)

### New APIs and options

- The dialect implements SQLAlchemy's asyncio extension. Use create_async_engine() with the usual snowflake:// URL to obtain an AsyncEngine / AsyncSession for non-blocking database access. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- CreateFileFormat gains a comment option for closer parity with Snowflake's CREATE FILE FORMAT. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- CreateFileFormat gains an if_not_exists option for closer parity with Snowflake's CREATE FILE FORMAT. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The asdecimal parameter allows opting into float conversion of numeric results instead of Decimal; the default remains Decimal. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- This opt-in dialect flag renders generic Uuid and Mapped[uuid.UUID] as native Snowflake UUID and supports uuid.UUID in semi-structured payloads; it is off by default because it changes existing column DDL. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The new custom command supports Snowflake multi-table INSERT ALL and INSERT FIRST statements, including conditional when/else_, OVERWRITE, and per-target column/value mapping. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- create_engine supports the json_deserializer parameter, matching the built-in SQLAlchemy dialects. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- create_engine supports the json_serializer parameter, matching the built-in SQLAlchemy dialects. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- JSONFormatter supports the full Snowflake TYPE=JSON option set, including date, time, timestamp, binary, null, duplicate, and invalid-character handling options. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Snowflake custom types gain a python_type property for SQLAlchemy compatibility. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Opt-in snowflake_rely=True renders RELY on PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints so the optimizer can trust them for query rewrites such as join elimination. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- This environment variable enables strict host-name mode, which stops host-name domain inference and forwards connection parameters unvalidated. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- SnowflakeTable accepts a row_access_policy parameter whose policy name may be a string, optionally fully qualified, or a snowflake.sqlalchemy.FQN. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Strict host-name mode stops inferring or appending domains and forwards connection parameters, including connection_name profiles, to the connector unvalidated; explicit stage endpoints are supported. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Bracket access with col["key"] and col[index] compiles to Snowflake's native accessor for VARIANT, OBJECT, ARRAY, and MAP columns, including nested chains. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)

### Fixes and other changes

- Account derivation now uses the Snowflake Connector's parse_account, fixing dashed org-style PrivateLink account parsing and matching the driver's handling of host notations. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Expression-level collation now renders the collation as a single-quoted Snowflake string literal instead of an invalid double-quoted identifier. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- repr() now works when unloading into an ExternalStage or cloud location by using the target's secret-masking repr(). (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- The dialect explicitly sets this connector option on new connections to pin its present default and silence the connector's FutureWarning; URL or connect_args values take precedence. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Hybrid table index reflection now handles filter_names=None and returns indexes for all Hybrid Tables in the schema; reflected names, result keys, and empty INCLUDE columns are also normalized for correct reflection. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Object-listing SHOW commands used for reflection now paginate, fixing reflection failures on schemas or databases with more than 10,000 objects. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- A SELECT with OFFSET but no LIMIT now emits LIMIT NULL OFFSET ... instead of invalid LIMIT -1 SQL. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Backslash breakout in COPY FILE_FORMAT options is fixed. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Expired-session/token and closed-connection errors, including error code 390195, are detected as disconnects so connection_invalidated is set and pooled connections are recycled. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Column-type collation now renders the collation as a single-quoted Snowflake string literal instead of an invalid double-quoted identifier. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)
- Passwords containing [, ], ?, or # are now encoded correctly so generated connection strings can be parsed. (2.0.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v2.0.0)

## snowflake-sqlalchemy 1

### Breaking changes

- The `/` operator always emits true division, regardless of the flag; the flag now gates a deprecation warning. (1.11.1) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.1)
- Raises TypeError at DDL compile time for expression elements that are neither str nor TextClause, rather than silently coercing them to malformed DDL. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)
- Account and region are validated against DNS-safe characters, and user values are percent-encoded before URL construction to prevent delimiter misinterpretation. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)
- The listed connector kwargs can no longer be supplied via the URL query string; pass them via connect_args= in create_engine() instead. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)

### Security

- repr() masks cloud secrets as '***'; compiled SQL is unchanged. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)
- Escapes single quotes and backslashes in view names before embedding them in SHOW VIEWS LIKE, so such views are found correctly and crafted names cannot manipulate the query. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)
- Snowflake SQLAlchemy affected by SQL injection and local file disclosure vulnerabilities (1.11.0) — [security advisory](https://github.com/advisories/GHSA-8G6F-QW9X-4Q6Q)
- An opt-in logging redactor is available for engine logs that contain inline credentials. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)

### New APIs and options

- Setting this environment variable to 1 provides a legacy URL-parameter behavior option if you encounter a possible behavioral change. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)

### Performance

- Reflecting one table no longer scans the entire schema, reducing latency and Snowflake credit usage for targeted Inspector calls. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)

### Fixes and other changes

- Caller-supplied identifiers in DDL are routed through the identifier preparer; quote=False labels are quoted when their characters require it. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)
- Cloud-storage URIs, credentials, encryption clauses, file entries, and FILE_FORMAT option strings use dialect-standard escaping in compiled SQL. (1.11.0) — [release notes](https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.11.0)