snowflake

Connecting Ruby and Snowflake with ADBC

Instructions

Prerequisites

1. Install Ruby

2. Install dbc

3. Ensure the native Arrow GLib and ADBC GLib libraries required by red-adbc are installed and discoverable. If bundle install reports missing arrow, arrow-glib, or adbc-glib, use the platform-specific commands below.

   macOS with Homebrew

   brew install apache-arrow-glib apache-arrow-adbc-glib

   Debian/Ubuntu

   sudo apt install libarrow-glib-dev libadbc-glib-dev

   RHEL-compatible distributions

   sudo dnf install arrow-glib-devel adbc-glib-devel

   Windows with RubyInstaller/MSYS2 UCRT64

   pacman -S --needed mingw-w64-ucrt-x86_64-arrow mingw-w64-ucrt-x86_64-arrow-adbc-glib

   If you use a different MSYS2 environment, adjust the package prefix to match it; for example, use mingw-w64-x86_64-* from the MINGW64 shell.

4. Install Ruby dependencies:

   bundle install

   If you have multiple Ruby installations, ensure ruby and bundle resolve to the same installation before running this command.

Connect to Snowflake

1. Install the Snowflake ADBC driver:

   dbc install --level user snowflake

2. Customize the Ruby script main.rb

   • Change the connection arguments in database.set_option()
     • See Snowflake Driver Client Options for the full list of available options
   • If you changed the database and schema, also change the SQL SELECT statement in connection.query()

3. Run the Ruby script:

   bundle exec ruby main.rb