Skip to content

Latest commit

 

History

History
96 lines (65 loc) · 2.5 KB

File metadata and controls

96 lines (65 loc) · 2.5 KB

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()
    • 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