ChaseGilliam

ChaseGilliam

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

Showing Posts 1 to 6

garrison

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 :slight_smile: 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

ChaseGilliam OP

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

ChaseGilliam OP

Just popped off a new github release.

loucash

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

ChaseGilliam OP

Right now, just what’s in the README for config and testing. The docs here may also be helpful.

ChaseGilliam

ChaseGilliam OP

We recently released version 1.2.1 which includes a big improvement in memory consumption for large data sets.

— All posts loaded —

Where Next? Top

Trending in Announcing Top

woylie
Flop is an Elixir library that applies filtering, ordering and pagination parameters to your Ecto queries. offset-based pagination with...
New
MRdotB
I needed to reuse React components from my Chrome extension in my Phoenix/LiveView backend. I noticed that for Svelte/Vue, there are live...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
fuelen
Hi all! I want to present a small library which provides a mix task for generating an Entity-Relationship Diagram for Ecto schemas. You...
New
anuaralfetahe
Hello Published a new library - ProcessHub! ProcessHub is a library designed to manage process distribution within the Elixir cluster. ...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
AstonJ
This showed up on my feed.. anyone heard of it? Just hype? Ox Alpha is a reasoning model designed for coding, sustained ag...
New
sergio
It’s not that it’s vocabulary is too advanced. It’s something worse. I get lost trying to follow even a paragraph written by Claude. It’...
New
webofbits
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself. My main conc...
#ai
New
sorenone
Today we’re releasing Oban for Python. Not an Oban client in Python. Not a pythonx wrapper embedded in Elixir. Nope, it’s a fully operati...
New
akoutmos
@hugobarauna, Dr. Dimitrios Koutmos (my brother) and I (Alex Koutmos) have been hard at work on writing a book on how you can use Elixir ...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews