# Connecting to Snowflake with Ruby on Rails

DevFeed: [Connecting to Snowflake with Ruby on Rails](<https://devfeed.tech/articles/connecting-to-snowflake-with-ruby-on-rails-28624.md>)

Original publisher: [Read original article](<https://eng.localytics.com/connecting-to-snowflake-with-ruby-on-rails/>)

Author: Kevin Deisz

Published: 2017-06-09T14:53:09Z

Content type: tutorial

Language: en

Sources: [Localytics](<https://devfeed.tech/sources/localytics.md>)

Topics: [Ruby on Rails](<https://devfeed.tech/topics/ruby-on-rails.md>), [API](<https://devfeed.tech/topics/api.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [activerecord](<https://devfeed.tech/tags/activerecord.md>), [adapter](<https://devfeed.tech/tags/adapter.md>), [api](<https://devfeed.tech/tags/api.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [data-processing](<https://devfeed.tech/tags/data-processing.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [ruby-on-rails](<https://devfeed.tech/tags/ruby-on-rails.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A tutorial on connecting a Ruby on Rails API to the Snowflake data warehouse using unixODBC, Snowflake's ODBC driver, and an ActiveRecord adapter. It explains ODBC, DSN configuration, installation, and debugging.

## Source excerpt

At Localytics, one of the tools we use for data processing is the Snowflake data warehouse. We connect to Snowflake in a couple different ways, but our main data retrieval application is a Ruby on Rails API. To accomplish this we use a combination of unixODBC (an open-source implementation