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
anddate_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 usingregister_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()
orDataFrame.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
insession.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.