v0.3.0
Pre-release
Pre-release
0.3.0 (2022-01-09)
New Features
- Added
Column.isin()
, with an aliasColumn.in_()
. - Added
Column.try_cast()
, which is a special version ofcast()
. It tries to cast a string expression to other types and returnsnull
if the cast is not possible. - Added
Column.startswith()
andColumn.substr()
to process string columns. Column.cast()
now also accepts astr
value to indicate the cast type in addition to aDataType
instance.- Added
DataFrame.describe()
to summarize stats of aDataFrame
. - Added
DataFrame.explain()
to print the query plan of aDataFrame
. DataFrame.filter()
andDataFrame.select_expr()
now accepts a sql expression.- Added a new
bool
parametercreate_temp_table
to methodsDataFrame.saveAsTable()
andSession.write_pandas()
to optionally create a temp table. - Added
DataFrame.minus()
andDataFrame.subtract()
as aliases toDataFrame.except_()
. - Added
regexp_replace()
,concat()
,concat_ws()
,to_char()
,current_timestamp()
,current_date()
,current_time()
,months_between()
,cast()
,try_cast()
,greatest()
,least()
, andhash()
to modulesnowflake.snowpark.functions
.
Bug Fixes
- Fixed an issue where
Session.createDataFrame(pandas_df)
andSession.write_pandas(pandas_df)
raise an exception when thePandas DataFrame
has spaces in the column name. DataFrame.copy_into_table()
sometimes prints anerror
level log entry while it actually works. It's fixed now.- Fixed an API docs issue where some
DataFrame
APIs are missing from the docs.
Dependency updates
- Update
snowflake-connector-python
to 2.7.2, which upgradespyarrow
dependency to 6.0.x. Refer to the python connector 2.7.2 release notes for more details.