v0.8.0

0.8.0 (2022-07-22)

New Features:

• Added keyword only argument statement_params to the following methods to allow for specifying statement level parameters:
  • collect, to_local_iterator, to_pandas, to_pandas_batches,
    count, copy_into_table, show, create_or_replace_view, create_or_replace_temp_view, first, cache_result
    and random_split on class snowflake.snowpark.Dateframe.
  • update, delete and merge on class snowflake.snowpark.Table.
  • save_as_table and copy_into_location on class snowflake.snowpark.DataFrameWriter.
  • approx_quantile, statement_params, cov and crosstab on class snowflake.snowpark.DataFrameStatFunctions.
  • register and register_from_file on class snowflake.snowpark.udf.UDFRegistration.
  • register and register_from_file on class snowflake.snowpark.udtf.UDTFRegistration.
  • register and register_from_file on class snowflake.snowpark.stored_procedure.StoredProcedureRegistration.
  • udf, udtf and sproc in snowflake.snowpark.functions.
• Added support for Column as an input argument to session.call().
• Added support for table_type in df.write.save_as_table(). You can now choose from these table_type options: "temporary", "temp", and "transient".

Improvements:

• Added validation of object name in session.use_* methods.
• Updated the query tag in SQL to escape it when it has special characters.
• Added a check to see if Anaconda terms are acknowledged when adding missing packages.

Bug Fixes:

• Fixed the limited length of the string column in session.create_dataframe().
• Fixed a bug in which session.create_dataframe() mistakenly converted 0 and False to None when the input data was only a list.
• Fixed a bug in which calling session.create_dataframe() using a large local dataset sometimes created a temp table twice.
• Aligned the definition of function.trim() with the SQL function definition.
• Fixed an issue where snowpark-python would hang when using the Python system-defined (built-in function) sum vs. the Snowpark function.sum().