Loading

Error "exceeded the maximum size allowed" When Creating Redshift Extract

Дата публикации: Apr 13, 2024
Описание
When you try to create an extract from a Redshift data source, the following error might occur:
 
Error occurred while trying to execute a query: ERROR: exceeded the maximum size allowed for the total set of cursor data: <size>
Unable to create extract

Cause

The extract is too large and is reaching an Amazon Redshift size limitation. For more information about the Amazon Redshift Cursor Constraints, see this AWS Documentation article. 
Решение
Use one of the following workarounds.

Option 1

Use a live connection instead of creating an extract.

Option 2

Connect to a smaller table.

Option 3

Increase the number of nodes for your Amazon Redshift installation.
Номер статьи базы знаний

001473924

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