User guide

• Retrieve Entire Result Into Memory. Select this option if you want query results to be returned all
at once to the SQL client tool or application. The default is enabled.
10. In Logging Options, specify values for the following:
• Log Level. Select an option to specify whether to enable logging and the level of detail that you
want captured in the logs.
Important
You should only enable logging when you need to capture information about an issue.
Logging decreases performance, and it can consume a large amount of disk space.
• Log Path. Specify the full path to the folder where you want to save log files.
Then click OK.
11. In Data Type Options, specify values for the following:
• Use Unicode. Select this option to enable support for Unicode characters.The default is enabled.
• Show Boolean Column As String. Select this option if you want Boolean values to be displayed
as string values instead of bit values. If you enable this, "1" and "0" display instead of 1 and 0. The
default is enabled.
• Text as LongVarChar. Select this option to enable showing text as LongVarChar. The default is
enabled.
• Max Varchar. Specify the maximum value for the Varchar data type. A Varchar field with a value
larger than the maximum specified will be promoted to LongVarchar. The default value is 255.
• Max LongVarChar. Specify the maximum value for the LongVarChar data type. A LongVarChar
field value that is larger than the maximum specified will be truncated. The default value is 8190.
• Max Bytea. Specify the maximum value for the Bytea data type. A Bytea field value that is larger
than the maximum specified will be truncated. The default value is 255.
Note
The Bytea data type is only used by Amazon Redshift system tables and views, and
otherwise is not supported.
Then click OK.
12. Click Test. If the client computer can connect to the Amazon Redshift database, you will see the
following message: Connection successful.
If the client computer fails to connect to the database, you can troubleshoot possible issues. For more
information, see Troubleshooting Connection Issues in Amazon Redshift (p. 173).
Install the Amazon Redshift ODBC Driver on Linux Operating Systems
System Requirements
You install the Amazon Redshift ODBC driver on client computers accessing an Amazon Redshift data
warehouse. Each computer where you install the driver must meet the following minimum system
requirements:
• One of the following Linux distributions (32- and 64-bit editions):
• Red Hat Enterprise Linux (RHEL) 5.0/6.0
• CentOS 5.0/6.0
• SUSE Linux Enterprise Server (SLES) 11
• 75 MB of available disk space
• One of the following ODBC driver managers:
• iODBC Driver Manager 3.52.7 or later. For more information about the iODBC driver manager and
links to download it, go to the Independent Open Database Connectivity website.
API Version 2012-12-01
148
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift