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: 28 Feb 2017

Issue

When working with a live Amazon Redshift connection, the following error message occurs:
 
Fetch size 4957 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 with any 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 10.1.5
  • MacOS 10.12.3 (16D32)
  • Amazon Redshift

Cause

Issues with the most recent Redshift driver (1.3.1.1000) for Mac OS.
Did this article resolve the issue?