Loading

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

Дата публикации: Mar 24, 2025
Описание

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.

Решение

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.

Номер статьи базы знаний

001498377

Вложения

RedShift_Limit.tdc

0 KB

 
Загрузка
Salesforce Help | Article