Anyone have any brilliant solutions for connecting to Snowflake.

I am currently using ODBC connection with 'ruby-odbc' and 'Sequel' gem but I am finding it incredibly slow. Thirty-Five seconds to load 12 records while it was instantaneous with the now retired MS-SQL back-end. I am not able to execute queries via Active Record I have to first do " db = Sequel.odbc['DSN-NAME]" followed by db.fetch("My SQL Statement") and so on. Any help greatly appreciated as I have been struggling with this for days.

The ODBC connector can be very slow, especially queries that return a lot of data. We created this gem which has worked well for us for several years: rinsed-org/rb-snowflake-client (on github).
Of course, Snowflake has high latency (compared to postgres/mysql/etc) but that gem tries to make it as fast as possible!