Loading

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

Julkaisupäivä: Apr 13, 2024
Kuvaus
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. 
Ratkaisu
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-artikkelin numero

001473924

 
Ladataan
Salesforce Help | Article