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: 20 Jul 2023


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


  • Tableau Desktop
  • Mac OS X
  • Amazon Redshift


Option 1

Use the Amazon Redshift driver available at:

Previous ODBC Driver 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.


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