Error "Fetch size [size] exceeds the limit of 1000 for a single node configuration" Connecting Live to Redshift on a Mac

Issue

When working with a live Amazon Redshift connection, the following error message occurs:

Fetch size <number> exceeds the limit of 1000 for a single node configuration. Reduce the client fetch/cache size or upgrade to a multi node installation.

This can happen during a variety of interactions with a Redshift connection and larger tables, such as:

Viewing underlying data
Creating views
Trying to create an extract

Environment

Tableau Desktop
Mac OS X
Amazon Redshift

Resolution

Option 1

Use the Amazon Redshift driver 1.2.7.1007 available at:

Previous ODBC Driver Versions
https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html#odbc-previous-versions

Option 2

Use the attached Redshift_Limit.tdc file.

Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.