Getting started with Amazon Redshift RSQL - Amazon Redshift
PrerequisitesDownload RSQLInstall RSQL
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.

Prerequisites

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.

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

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.

Download RSQL

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

Install RSQL

Perform the steps for your operating system.

  • Linux:

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

  • Mac OS:

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

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

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

  • Windows:

    1. Double-click the file to run the installer.

    2. Follow the prompts to complete the installation.