Snowflex - a Snowflake library with an Ecto Adapter

Not long ago we released the 1.0 release of Snowflake which moved us off of ODBC(which is unmaintained in OTP) and onto the Snowflake HTTP api. This release is fully Ecto/DBConnection compatible and can run tests locally using sqlite. It should be much easier to install and run than older versions which required ODBC drivers.

This adapter implements the following Ecto behaviours:

  • Ecto.Adapter - Core adapter functionality
  • Ecto.Adapter.Queryable - Query execution and streaming
  • Ecto.Adapter.Schema - Schema operations (insert, update, delete)

Requirements

If using the provided Snowflex.Transport.Http transport, the only currently supported authentication method is keypair.

In order to obtain the public_key_fingerprint, please follow Snowflake’s instructions.

https://github.com/pepsico-ecommerce/snowflex

5 Likes