snowflakedb/snowpark-python v1.1.0

1.1.0

on GitHub

1.1.0 (2023-01-26)

New Features:

• Added asc, asc_nulls_first, asc_nulls_last, desc, desc_nulls_first, desc_nulls_last, date_part and unix_timestamp in functions.
• Added the property DataFrame.dtypes to return a list of column name and data type pairs.
• Added the following aliases:
  • functions.expr() for functions.sql_expr().
  • functions.date_format() for functions.to_date().
  • functions.monotonically_increasing_id() for functions.seq8()
  • functions.from_unixtime() for functions.to_timestamp()

Bug Fixes:

• Fixed a bug in SQL simplifier that didn’t handle Column alias and join well in some cases. See #658 for details.
• Fixed a bug in SQL simplifier that generated wrong column names for function calls, NaN and INF.

Improvements

• The session parameter PYTHON_SNOWPARK_USE_SQL_SIMPLIFIER is True after Snowflake 7.3 was released. In snowpark-python, session.sql_simplifier_enabled reads the value of PYTHON_SNOWPARK_USE_SQL_SIMPLIFIER by default, meaning that the SQL simplfier is enabled by default after the Snowflake 7.3 release. To turn this off, set PYTHON_SNOWPARK_USE_SQL_SIMPLIFIER in Snowflake to False or run session.sql_simplifier_enabled = False from Snowpark. It is recommended to use the SQL simplifier because it helps to generate more concise SQL.