KNOWLEDGE BASE

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


Published: 28 Feb 2017
Last Modified Date: 24 Aug 2022

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.

Cause

Compatibility issues with the Redshift driver installed on your computer.
Did this article resolve the issue?