v1.18.0

• Improvements
  • Add functions.try_to_date overload for format parameter.
  • Add functions.try_to_timestamp overload for format parameter.
  • Add Column.cast support for Any parameter type.
  • Add Column.equal_to support for Any parameter type.
  • Add Column.not_equal support for Any parameter type.
  • Add Column.gt support for Any parameter type.
  • Add Column.lt support for Any parameter type.
  • Add Column.leq support for Any parameter type.
  • Add Column.geq support for Any parameter type.
  • Add Column.equal_null support for Any parameter type.
  • Add Column.plus support for Any parameter type.
  • Add Column.minus support for Any parameter type.
  • Add Column.multiply support for Any parameter type.
  • Add Column.divide support for Any parameter type.
  • Add Column.mod support for Any parameter type.

v1.17.0

• Improvements
  • functions.when/Column.when and Column.otherwise now accept any literal arguments (e.g. String, int, boolean, or null) in addition to Column instances.
  • Add functions.substring overload with support for start position and length arguments.
  • Add functions.lpad overloads to pad with String, or Array[Byte].
  • Add functions.rpad overloads to pad with String, or Array[Byte].
  • Add DataFrame.sort overload with support for variadic arguments.
  • Add DataFrame.show overloads with parameters to control truncation and number of displayed rows.
• New APIs
  • DataFrame.isEmpty
  • functions.try_to_timestamp
  • functions.try_to_date
  • functions.concat_ws_ignore_nulls
  • functions.array_flatten
  • Row.mkString (with overloads for customizable separators and formatting options)
  • StructType.fieldNames (alias for StructType.names)

v1.16.0

• Improvements
  • Upgraded Snowflake JDBC to 3.24.2
  • Support empty input Seq in Column.in
  • Support creating views from Union result
• Bug Fixes
  • Fixed wrong order issue when merging Dataframe

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