Release

1.14.0 (2024-03-20)

New Features

• Added support for creating vectorized UDTFs with process method.
• Added support for dataframe functions:
  • to_timestamp_ltz
  • to_timestamp_ntz
  • to_timestamp_tz
  • locate
• Added support for ASOF JOIN type.
• Added support for the following local testing APIs:
  • snowflake.snowpark.functions:
    • to_double
    • to_timestamp
    • to_timestamp_ltz
    • to_timestamp_ntz
    • to_timestamp_tz
    • greatest
    • least
    • convert_timezone
    • dateadd
    • date_part
  • snowflake.snowpark.Session:
    • get_current_account
    • get_current_warehouse
    • get_current_role
    • use_schema
    • use_warehouse
    • use_database
    • use_role

Bug Fixes

• Fixed a bug in SnowflakePlanBuilder that save_as_table does not filter column that name start with '$' and follow by number correctly.
• Fixed a bug that statement parameters may have no effect when resolving imports and packages.
• Fixed bugs in local testing:
  • LEFT ANTI and LEFT SEMI joins drop rows with null values.
  • DataFrameReader.csv incorrectly parses data when the optional parameter field_optionally_enclosed_by is specified.
  • Column.regexp only considers the first entry when pattern is a Column.
  • Table.update raises KeyError when updating null values in the rows.
  • VARIANT columns raise errors at DataFrame.collect.
  • count_distinct does not work correctly when counting.
  • Null values in integer columns raise TypeError.

Improvements

• Added telemetry to local testing.
• Improved the error message of DataFrameReader to raise FileNotFound error when reading a path that does not exist or when there are no files under the path.