Release

1.5.0 (2023-06-09)

Behavior Changes

• Aggregation results, from functions such as DataFrame.agg and DataFrame.describe, no longer strip away non-printing characters from column names.

New Features

• Added support for the Python 3.9 runtime environment.
• Added support for new functions in snowflake.snowpark.functions:
  • array_generate_range
  • array_unique_agg
  • collect_set
  • sequence
• Added support for registering and calling stored procedures with TABLE return type.
• Added support for parameter length in StringType() to specify the maximum number of characters that can be stored by the column.
• Added the alias functions.element_at() for functions.get().
• Added the alias Column.contains for functions.contains.
• Added experimental feature DataFrame.alias.
• Added support for querying metadata columns from stage when creating DataFrame using DataFrameReader.
• Added support for StructType.add to append more fields to existing StructType objects.
• Added support for parameter execute_as in StoredProcedureRegistration.register_from_file() to specify stored procedure caller rights.

Bug Fixes

• Fixed a bug where the Dataframe.join_table_function did not run all of the necessary queries to set up the join table function when SQL simplifier was enabled.
• Fixed type hint declaration for custom types - ColumnOrName, ColumnOrLiteralStr, ColumnOrSqlExpr, LiteralType and ColumnOrLiteral that were breaking mypy checks.
• Fixed a bug where DataFrameWriter.save_as_table and DataFrame.copy_into_table failed to parse fully qualified table names.