KNOWLEDGE BASE

Error "exceeded the maximum size allowed" Creating Redshift Extract


Published: 09 Apr 2014
Last Modified Date: 09 Aug 2017

Issue

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

Environment

  • Tableau Desktop 8.1 and later versions
  • Amazon Redshift

Resolution

Use one of the following workarounds.

Option 1

Use a live connection instead of creating an extract.

Option 2

Connect to a smaller table.

 

Cause

The extract is too large and is reaching an Amazon Redshift size limitation.
Did this article resolve the issue?