Getting started with Amazon Redshift RSQL

Install the driver manager with the following command:

sudo yum install unixODBC openssl

OpenSSL is required for Linux distributions. The OpenSSL library is located in the Linux OpenSSL Github repository. For more information about OpenSSL, see OpenSSL.

Install the ODBC driver: Using an Amazon Redshift ODBC driver on Microsoft Windows.

Copy the ini file to your home directory:

cp /opt/amazon/redshiftodbc/Setup/odbc.ini ~/.odbc.ini

Set the environment variables to point to the location of the file:

export ODBCINI=~/.odbc.ini
    export ODBCSYSINI=/opt/amazon/redshiftodbc/Setup
    export AMAZONREDSHIFTODBCINI=/opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini

You can now install RSQL by running the following command.

sudo rpm -i AmazonRedshiftRsql-<version>-1.x86_64.rpm

Install the driver manager with the following command:

brew install unixodbc openssl@1.1 --build-from-source

Install the ODBC driver: Using an Amazon Redshift ODBC driver on Linux.

Copy the ini file to your home directory:

cp /opt/amazon/redshift/Setup/odbc.ini ~/.odbc.ini

Set the environment variables to point to the location of the file:

export ODBCINI=~/.odbc.ini
export ODBCSYSINI=/opt/amazon/redshift/Setup
export AMAZONREDSHIFTODBCINI=/opt/amazon/redshift/lib/amazon.redshiftodbc.ini

Set DYLD_LIBRARY_PATH to location of your libodbc.dylib if its not in /usr/local/lib.

export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/usr/local/lib

Double-click the dmg file to mount the disk image.

Double-click the pkg file to run the installer.

Follow the steps in the installer to complete the installation. Agree to the terms of the license agreement.