Getting started with Amazon Redshift RSQL - Amazon Redshift
Download RSQLInstall RSQL for LinuxInstall RSQL for MacInstall RSQL for Windows
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Getting started with Amazon Redshift RSQL

Install Amazon Redshift RSQL on a computer with a Linux, macOS, or Microsoft Windows operating system.

Download RSQL

See the change log and downloads for previous versions at Amazon Redshift RSQL change log.

Install RSQL for Linux

Follow the steps below to install RSQL for Linux.

  1. 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.

  2. Install the ODBC driver: Installing the Amazon Redshift driver on Linux operating systems.

  3. Copy the ini file to your home directory:

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

  4. 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

    For more information about configuring ODBC environment variables, see Configuring environment variables.

  5. You can now install RSQL by running the following command.

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

Install RSQL for Mac

Follow the steps below to install RQL for Mac OSX.

  1. Install the driver manager with the following command:

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

  2. Install the ODBC driver: Install the Amazon Redshift ODBC driver on macOS X.

  3. Copy the ini file to your home directory:

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

  4. 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

    For more information about configuring ODBC environment variables, see Configuring environment variables.

  5. 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

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

  7. Double-click the pkg file to run the installer.

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

Install RSQL for Windows

Follow the instructions at Install and configure the Amazon Redshift ODBC driver on Microsoft Windows to install the driver. Windows doesn't require a driver manager.

OpenSSL is required for Amazon Redshift RSQL on Windows. The Windows OpenSSL library is located in the Windows OpenSSL GitHub repository. For more information about OpenSSL, see OpenSSL.

Double-click the RSQL download file to run the installer, then follow the prompts to complete the installation.