1.51.0 (2026-05-14)

Snowpark Python API Updates

Bug Fixes

• Fixed a bug where AsyncJob.result("no_result") sometimes silently returned without raising error for failed queries.
• Fixed a bug where INTERVAL YEAR TO MONTH values with zero months were displayed incorrectly (e.g. INTERVAL '0-4' YEAR TO MONTH instead of INTERVAL '4-0' YEAR TO MONTH) when using snowflake-connector-python>=4.3.0.

Improvements

• When Session.reduce_describe_query_enabled is enabled, fewer DESCRIBE queries are issued when the outer query only projects or renames columns from an inner subquery whose column types are already known.

1.50.1 (2026-05-06)

Snowpark Python API Updates

Bug Fixes

• Fixed a bug where using parameter bindings for CALL queries issued through session.sql would raise an error.
• Fixed a bug where StringType columns from Iceberg tables were not recognized as max-size strings.
• Improved the FileNotFoundError message raised when INFER_SCHEMA returns zero rows so it also points to file format options (PARSE_HEADER, SKIP_HEADER, ON_ERROR=CONTINUE) that can silently filter everything out, instead of only suggesting a missing path.

1.50.0 (2026-04-23)

Snowpark Python API Updates

New Features

• Added artifact_repository support to udtf_configs in session.read.dbapi(), enabling users to specify a custom artifact repository (e.g. PyPI) for packages used by the internal UDTF during distributed ingestion.

Bug Fixes

• Fixed a bug where TRY_CAST reader option is ignored when calling DataFrameReader.schema().csv().
• Fixed a bug where event_table_telemetry is using incorrect resource attributes.
• Fixed a bug where value_contains_null was not propagated for MapType in _as_nested function.
• Fixed a bug where CTE optimization incorrectly deduplicated subtrees containing non-deterministic data generation functions (e.g. uuid_string()).
• Fixed a bug where vectorized UDFs using non-anaconda package repositories did not specify the pandas package by default.

Snowpark pandas API Updates

Dependency Updates

• Updated the supported pandas versions to <=2.4 (was previously <=2.3.1).

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.

1.48.1 (2026-03-31)

Snowpark Python API Updates

Bug Fixes

• Fixed a bug where chained DataFrame.filter() calls with raw SQL text containing OR produced incorrect results.
• Fixed a Snowflake platform compatibility issue where concat(lit('"'), ...) could lose the leading quote through chained set-operation plans.

1.48.0 (2026-03-23)

Snowpark Python API Updates

New Features

• Added support for DIRECTED JOIN.
• Added support for the INCLUDE_METADATA copy option in DataFrame.copy_into_table, allowing users to include file metadata columns in the target table.

Bug Fixes

• Fixed a bug in Session.client_telemetry that trace does not have snowflake style trace id.
• Fixed a bug when saving a fdn table into an iceberg table in overwrite mode, error is raised because StringType is saved in wrong length.
• Fixed a bug in ai_complete where model_parameters and response_format values containing single quotes would generate malformed SQL.
• Fixed a bug in DataFrameReader.xml() where reading XML with a custom schema whose field names contain colons (e.g., px:name) raised a SnowparkColumnException.
• Fixed a bug in that caused SQL compilation errors in Session.read.json when INFER_SCHEMA was set to True, and the USE_RELAXED_TYPES field of INFER_SCHEMA_OPTIONS was also set to True.
• Fixed a bug where passing a DataFrame created from a SQL SET command to Streamlit's st.write method would raise an exception.
• Fixed a bug where the account-level default artifact repository setting was not reflected in creation of stored procedures/UDFs.

Improvements

• Use internal describe to get return type when executing a stored procedure.

1.47.0 (2026-03-05)

Snowpark Python API Updates

New Features

• Added support for the array_union_agg function in the snowflake.snowpark.functions module.

Bug Fixes

• Fixed a bug where Session.udf.register_from_file did not properly process the strict and secure parameters.
• Fixed a bug when create dataframe with small data(< array binding threshold), and error is raised when have string value in a DecimalType column.

1.46.0 (2026-02-23)

Snowpark Python API Updates

New Features

• Added support for the DECFLOAT data type that allows users to represent decimal numbers exactly with 38 digits of precision and a dynamic base-10 exponent.
• Added support for the DEFAULT_PYTHON_ARTIFACT_REPOSITORY parameter that allows users to configure the default artifact repository at the account, database, and schema level.

Bug Fixes

• Fixed a bug where cloudpickle was not automatically added to the package list when using artifact_repository with custom packages, causing ModuleNotFoundError at runtime.
• Fixed a bug when reading xml with custom schema, result include element attributes when column is not StructType type.
• Fixed a bug where Session.udf.register_from_file did not properly process the strict and secure parameters.

Improvements

• 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").

Snowpark pandas API Updates

New Features

Bug Fixes

Improvements

1.45.0 (2026-02-02)

Snowpark Python API Updates

New Features

• Allow user input schema when reading XML file on stage.
• Added support for the following functions in functions.py:
  • String and Binary functions:
    • hex_decode_string
    • jarowinkler_similarity
    • parse_url
    • regexp_instr
    • regexp_like
    • regexp_substr
    • regexp_substr_all
    • rtrimmed_length
    • space
    • split_part
• Added preserve_parameter_names flag to sproc, UDF, UDTF, and UDAF creation

Bug Fixes

• Fixed a bug that opentelemetry is not correctly import when using Session.client_telemetry.enable_event_table_telemetry_collection.

Improvements

• snowflake.snowpark.context.configure_development_features is effective for multiple sessions including newly created sessions after the configuration. No duplicate experimental warning any more.
• Removed experimental warning from DataFrame.to_arrow and DataFrame.to_arrow_batches.
• When both Session.reduce_describe_query_enabled and Session.cte_optimization_enabled are enabled, fewer DESCRIBE queries are issued when resolving table attributes.

1.44.0 (2025-12-15)

Snowpark Python API Updates

New Features

• Added support for targeted delete-insert via the overwrite_condition parameter in DataFrameWriter.save_as_table

Improvements

• Improved DataFrameReader to return columns in deterministic order when using INFER_SCHEMA.

Dependency Updates

• Added a dependency on protobuf<6.34 (was <6.32).