Getting started with Amazon Redshift RSQL
Install Amazon Redshift RSQL on a computer with a Linux, macOS, or Microsoft Windows operating system.
Download RSQL
-
Linux 64-bit RPM: RSQL Version 1.0.8
. In the China (Beijing) Region, use the following link: 64-bit RSQL Version 1.0.8 rpm file -
Mac OS 64-bit DMG: RSQL Version 1.0.8
. In the China (Beijing) Region, use the following link: 64-bit RSQL Version 1.0.8 dmg file -
Windows 64-bit MSI: RSQL Version 1.0.8
. In the China (Beijing) Region, use the following link: 64-bit RSQL Version 1.0.8 msi file
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.
-
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 RSQL for Mac
Follow the steps below to install RQL for Mac OSX.
-
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.
Install RSQL for Windows
OpenSSL is required for Amazon Redshift RSQL on Windows. The Windows OpenSSL library
is located in the Windows
OpenSSL
Double-click the RSQL download file to run the installer, then follow the prompts to complete the installation.