Loading

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

Publiseringsdato: 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.

Knowledge-artikkelnummer

001498377

Vedlegg

RedShift_Limit.tdc

0 KB

 
Laster
Salesforce Help | Article