Changelog

View Source

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[1.3.1] - 2026-06-10

Enhancements

  • Support routing Snowflake REST requests at a dedicated Finch pool. When a :finch instance is supplied via :req_options, Snowflex.Transport.Http now omits :connect_options so Req does not reject the request for setting both :finch and :connect_options. This lets callers point a warehouse at an explicitly-sized, isolated Finch pool. (#174)

Changed

  • Relax ecto and ecto_sql requirements from ~> 3.14 to ~> 3.13 so consumers can stay on the 3.13 series.

[1.3.0] - 2026-06-08

Enhancements

  • Implement aggregate filter() via CASE WHEN translation (#168)
    • count(x) |> filter(cond), sum, avg, min, max translate to agg(CASE WHEN cond THEN x END)
    • count() |> filter(cond) (COUNT(*)) maps to Snowflake's COUNT_IF(cond)

Bug Fixes

  • Raise a clear ArgumentError for unsupported on_conflict modes (:nothing, field list, update query) pointing users toward MERGE INTO (#167)

Changed

  • Bump minimum Elixir version to 1.15 (#163)
  • Replace ex_check + dialyxir with assay for CI (#166)
  • Bump ecto_sql and doctor, enabling plug and decimal upgrades to avoid CVE versions (#165)
  • Bump req from 0.5.x to 0.6.0 (#169)
  • Bump jose from 1.11.10 to 1.11.12 (#128)
  • Bump ecto from 3.13.5 to 3.13.6 (#153)
  • Bump ecto_sql from 3.13.4 to 3.13.5 (#147)
  • Bump jason from 1.4.4 to 1.4.5 (#157)
  • Bump telemetry from 1.3.0 to 1.4.1 (#148)
  • Bump assay from 0.5.2 to 0.6.1 (#170)
  • Bump credo from 1.7.16 to 1.7.19 (#149, #151, #171)
  • Bump ex_doc from 0.40.0 to 0.40.3 (#142, #159)

[1.2.1] - 2026-02-27

Bug Fixes

  • Dramatically improve memory usage for large datasets #145
  • Fix broken hexdoc links #143 by @henriqueberlesi

Changed

  • Bump Credo from 1.7.15 to 1.7.16 #139 by dependabot

[1.2.0] - 2026-02-09

Enhancements

  • Add support for options/1 to get Req.options (#140)

Bug Fixes

  • Resolve failing integration tests (#140)
  • Fix compiler warning on Elixir 1.19 (#140)
  • Fix global setting of req options (#140)

Changed

[1.1.0] - 2025-10-28

Enhancements

  • Add support for passing in private keys as files or as raw strings (#113) by @nyo16

Changed

  • Bump req from 0.5.15 to 0.5.16 (#126) by dependabot
  • Bump dialyxir from 1.4.6 to 1.4.7 (#125) by dependabot
  • Bump ecto from 3.13.4 to 3.13.5 (#124) by dependabot

[1.0.5] - 2025-10-28

Enhancements

  • Add ping/1 callback to Snowflex.Transport behavior to allow transports to opt out of periodic ping checks
  • HTTP transport now skips unnecessary ping queries, eliminating rate limit errors (HTTP 429) from DBConnection's idle connection checks
  • Add more detailed metadata into Logger.

[1.0.4] - 2025-09-03

Bug Fixes

  • Change to using identifier instead of literal to match Ecto's changes
  • Fix compiler warning in tests

Enhancements

  • Automatically track application version in User-Agent header by introspecting Application spec.

[1.0.3] - 2025-08-29

Bug Fixes

  • Add float_decode support for Decimal types to handle data type mismatches (#107)

[1.0.2] - 2025-08-25

Bug Fixes

  • Handle timeouts from execute_statement in http.ex (#100)

Changed

  • Bump dialyxir from 1.4.5 to 1.4.6 (#102) by dependabot

  • Bump ex_doc from 0.38.2 to 0.38.3 (#103) by dependabot

[1.0.1] - 2025-08-25

Bug Fixes

  • Fix migration generator depending on safe_concat for building module names (#101)

Enhancements

  • Accept req :connect_options config (#104)

[1.0] - 2025-04-24

This release is a ground up rewrite of the library.

We completely remove ODBC in favor of utilizing Snowflex's HTTP API, and remove support for password based authentication, in line with Snowflake's own approach.

We also now expose a fully Ecto/DBConnection compatible implementation.

For complete details, as well as some helpful migration instructions, see the README.

[0.5.3] - 2023-10-23

Added

  • Handle casting maybe date types #78

[0.5.2] - 2022-11-18

Added

  • Add unicode_string_param function #60

Fixed

  • ODBC error not always a string #53

[0.5.1] - 2022-05-10

Added

  • Handle UTF-16 return data from Snowflake #38

[0.5.0] - 2022-01-19

Added

  • General improvements, add DBConnection adapter #32

[0.4.5] - 2021-10-29

Added

  • Callback that calls gc after queries to try to shuffle binary strings off the heap. We've seen large memory savings in a real application. #23

[0.4.4] - 2021-10-27

Fixed

  • Relax dependency requirement on telemetry

[0.4.3] - 2021-10-27

Fixed

  • Hot fix for possible memory leak #27

[0.4.2] - 2021-10-08

Fixed

  • Properly convert elixir nil to erlang :null in query params

[0.4.1] - 2021-09-02

Added

[0.4.0] - 2021-06-10

Added

  • Enabled SQL INSERT statements.

[0.3.3] - 2021-06-07

Fixed

  • Corrected spelling in type definition

[0.3.2] - 2021-06-02

Added

  • Added map_nulls_to_nil? variable to connection configuration to allow conversion of :null values to :nil in snowflake query response

[0.3.1] - 2021-03-10

Fixed

  • Initialize the worker with a propslist instead of a tuple.
  • create copies of the odbc type definitions

[0.3.0] - 2021-03-09

Added

  • Added the ability to keep connections alive through configuration on the Snowflex.Connection module.

[0.2.2] - 2021-02-09

Fixed

  • make sure to follow {:error, reason} convention in all parts of the worker

[0.2.1] - 2020-11-20

Fixed

  • fix bug where handle_info is missing argument

[0.2.0] - 2020-11-18

Added

  • Added the ability to define a module that will use Snowflex.Connection to maintain connection information

Breaking

[0.1.1] - 2020-11-17

Changed

  • Configure the worker module on the Snowflex.ConnectionPool and no longer on the application level.

[0.1.0] - 2020-11-16

Breaking

  • Users must launch connection pools as part of their application's supervision tree using Snowflex.ConnectionPool, and all queries must specify which connection pool to use. No connection pool will be started by default.