Name	Name	Last commit message	Last commit date
parent directory ..
Gemfile	Gemfile
README.md	README.md
main.rb	main.rb

Name

Last commit message

Last commit date

Connecting Ruby and Teradata with ADBC

Instructions

Tip

If you don't already have a Teradata instance running, we recommend signing up for a free ClearScape Analytics trial.

Install Ruby
Install dbc
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.
Install Ruby dependencies:
```
bundle install
```
If you have multiple Ruby installations, ensure ruby and bundle resolve to the same installation before running this command.

The ADBC driver for Teradata is available from Columnar's private driver registry. Create a Columnar Console account and activate a 14-day free trial. Then authenticate to the registry:
```
dbc auth login
```
Install the ADBC driver for Teradata:
```
dbc install --level user teradata
```
Download and install the Teradata Tools and Utilities (TTU). Select "Tools and Utilities" and choose the package for your platform. Install to the default location:
- Linux: /opt/teradata
- macOS: /Library/Application Support/teradata
- Windows: C:\Program Files\Teradata\Client
On Windows, you can do this with winget install Teradata.TTUBase

On macOS with Homebrew, you can do this with brew tap Teradata/teradata && brew install ttubasesuite
Set LD_LIBRARY_PATH (Linux), DYLD_LIBRARY_PATH (macOS), or PATH (Windows) to make sure the TTU libraries are discoverable by your application.
Customize the Ruby script main.rb:
- Change the connection arguments in database.set_option().
  - uri is the URI of your Teradata instance. The format is teradata://user:password@host[:port].
- Change the SQL SELECT statement in connection.query().
Run the Ruby script:
```
bundle exec ruby main.rb
```