IssueWhen 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