Loading

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

Publiceringsdatum: Apr 13, 2024
Beskrivning
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. 
Lösning
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.
Knowledge-artikelnummer

001473924

 
Laddar
Salesforce Help | Article