ChaseGilliam
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 functionalityEcto.Adapter.Queryable- Query execution and streamingEcto.Adapter.Schema- Schema operations (insert, update, delete)Requirements
If using the provided
Snowflex.Transport.Httptransport, the only currently supported authentication method is keypair.In order to obtain the
public_key_fingerprint, please follow Snowflake’s instructions.
Trending in Announcing
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #performance
- #security
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Bringing learning, work and compliance together since 1987.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 6 of 6 Posts
garrison
I poked around a bit and this looks like very nice work. There is something really funny to me about seeing “Copyright PepsiCo” on an Elixir library
Thanks for contributing back!
BTW, you might want to tag your recent releases on the repo as at first glance it looks like there hasn’t been a release for a long time even though there have been several.
ChaseGilliam
Yeah we should probably tag releases again. For a while I didn’t think anyone outside of our teams were using it, but the other two Snowflake libraries were abandoned so I thought it would be good to let people know this exists and is used in anger.
ChaseGilliam
Just popped off a new github release.
loucash
Hey @ChaseGilliam
Thank you for building this library and making it available. Is there any tutorial how to set it up in a way that I could connect to Snowflake, use Ecto to build select queries and run tests either using Postgresql or SQLite?
Cheers,
Lukasz
ChaseGilliam
Right now, just what’s in the README for config and testing. The docs here may also be helpful.
ChaseGilliam
We recently released version 1.2.1 which includes a big improvement in memory consumption for large data sets.