Olaf

Olaf is a small Ruby wrapper for Snowflake queries.

olaf requires Ruby 2.6 or later, sequel and odbc driver to connect with DBs.

Install dependencies using bundler is easy as run:

bundle install

If you don't have Olaf, try this:

$ gem install olaf

Olaf helps developers to represent Snowflake queries as objects, to have more control in the code and in tests.

class FetchUsers
  include Olaf::QueryDefinition

  template './snowflake/users_in_department.sql'

  argument :department_id

  row_object User
end

query = FetchUsers.prepare(department_id: 1337)

Olaf.execute(query)
=> [#<User id: 41, department_id: 1337, name: 'Ian'>]