snowflakedb/snowpark-python v1.49.0

Release

on GitHub

1.49.0 (2026-04-13)

Snowpark Python API Updates

New Features

• Allow a user-specified schema when reading Parquet files from a stage.

Improvements

• Restored the following query improvements that were reverted in 1.47.0 due to bugs:
  • Reduced the size of queries generated by certain DataFrame.join operations.
  • Removed redundant aliases in generated queries (for example, SELECT "A" AS "A" is now always simplified to SELECT "A").
• Removed warning that DataFrameReader.dbapi feature was in private preview.

Bug Fixes

• Fixed a bug where Session.create_dataframe raised TypeError when a StringType column was given a non-string Python value (e.g. int, float, bool, Decimal) for a small local relation (below the array bind threshold); VALUES SQL generation now coerces these types to string literals, consistent with the large-data bind-parameter path.
• Fixed a bug where DataFrame.approxQuantile did not accept a Column for the col parameter.

Snowpark Local Testing Updates

Bug Fixes

• Fixed a bug where concat produced extra NaN rows and mismatched values after a filter operation in local testing.
• Fixed a bug where dense_rank() would fail with ValueError on NULL partition values.
• Fixed a bug where collect() raised KeyError after save_as_table(column_order="name") when the source DataFrame omitted columns with types VariantType, MapType, or ArrayType that were present in the target table schema in local testing.