Loading

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

Udgivelsesdato: Mar 24, 2025
Beskrivelse

When working with a live Amazon Redshift connection in Tableau Desktop (Mac), 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

Cause

Compatibility issues with the Redshift driver installed on your computer.

Løsning

Use the attached Redshift_Limit.tdc file when configuring the Redshift connection. This file will customize the connection to limit the Fetch Size, thus avoiding the error.

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.

Vidensartikelnummer

001498377

Vedhæftede filer

RedShift_Limit.tdc

0 KB

 
Indlæser
Salesforce Help | Article