Release

1.4.0 (2023-04-24)

New Features

• Added support for session.getOrCreate.
• Added support for alias Column.getField.
• Added support for new functions in snowflake.snowpark.functions:
  • date_add and date_sub to make add and subtract operations easier.
  • daydiff
  • explode
  • array_distinct.
  • regexp_extract.
  • struct.
  • format_number.
  • bround.
  • substring_index
• Added parameter skip_upload_on_content_match when creating UDFs, UDTFs and stored procedures using register_from_file to skip uploading files to a stage if the same version of the files are already on the stage.
• Added support for DataFrame.save_as_table method to take table names that contain dots.
• Flattened generated SQL when DataFrame.filter() or DataFrame.order_by() is followed by a projection statement (e.g. DataFrame.select(), DataFrame.with_column()).
• Added support for creating dynamic tables (in private preview) using Dataframe.create_or_replace_dynamic_table.
• Added an optional argument params in session.sql() to support binding variables. Note that this is not supported in stored procedures yet.

Bug Fixes

• Fixed a bug in strtok_to_array where an exception was thrown when a delimiter was passed in.
• Fixed a bug in session.add_import where the module had the same namespace as other dependencies.