v1.15.0

New Features

• New functions in functions
  • pow
  • months_between
  • instr
  • format_number
  • from_unix_timestamp
  • to_unix_timestamp
• New function Row.getAs
• Support SQL bind in Session.sql function

v1.14.0

New Features

• Support read structured types from Snowflake
• New functions
  • Variant.asJsonNode
  • functions.
    • round
    • hex
    • unhex
    • shiftleft
    • shiftright
    • reverse
    • isnull
    • unix_timestamp
    • locate
    • ntile
    • radn
    • randn
    • regexp_extract
    • signum
    • sign
    • substring_index
    • collect_list
    • log10
    • log1p
    • base64
    • unbase64
    • expr
    • array
    • date_format
    • last
    • desc
    • asc
    • size

Bug Fixes

• Fix wrong time info in the Open Telemetry Span
• Fix duplicated Open Telemetry Span in the count action

v1.13.2

Bug Fixes

• Fixed Jackson Scala module Compatibility Issue

v1.13.1

Bug Fixes

• When session parameter ERROR_ON_NONDETERMINISTIC_UPDATE is true, session.table(...).update(...) function will not report error anymore.

v1.13.0

New Features

• Emit Span in Java/Scala Stored Procedure. Support functions:
  • All action functions
  • Register UDF/UDTF/SProc
• Enable to retrieve cloud provider tokens in the SnowflakeSecrets class.
• New functions:
  • Session.updateQueryTag
  • functions.countDistinct
  • functions.max(String)
  • functions.min(String)
  • functions.mean(String)

Improvements

• App name in the session query tag is Json format now.
• Upgraded SLF4J to 2.0.4
• Update document in SnowflakeFile

Bug Fixes

• Variant object can't handle null value
• DataFrame alias doesn't work in the JOIN condition

v1.12.1

Bug Fix

• Fixed "Dataframe alias doesn't work in the JOIN condition"

v1.12.0

New Feature

• Support Geometry data type
• New Functions: sum(String)
• Support to set an app name when creating new session.

Improvement

• Added code examples for the split function in the API document

v1.11.0

New Features

• Support Java 17 Stored Procedure
  • When registering Stored Procedure, Snowpark automatically sets runtime_version to 17 if the client running with JVM 17.

v1.10.0

New Features

• Support Java 17
  • Compatible with JVM 17
  • When registering UDF and UDTF, Snowpark automatically sets runtime_version to 17 if the client running with JVM 17.
• Support Dataframe alias
  • Dataframes can be assigned a alias name for the future reference via DataFrame.alias() function.
  • For example, val df1 = df.alias("A") and then df1.join(df2).select(col("A.col")), which is equivalent to df1.join(df2).select(df1("col"))
• Support explode function
• Table functions can be invoked in the DataFrame.select() now.
• Table functions can read function arguments through TableFunction.apply() now.
• New session constructor Session.getOrCreate

Improvements

• Upgraded JDBC to 3.14.4
• New wrapper for is_null function
• Upgrade Scala to 2.12.18

Bug Fixes

• Update wrong license information

v1.9.0

Improvements

• Upgraded Snowflake JDBC to 3.14.1

New Features

• Supports regexp_replace function
• Supports PKCS#8 RSA private key

Acknowledgment

Thank you for your contribution

• @jbergeroncoveo