KNOWLEDGE BASE

Error "Maximum tables limit exceeded" Attempting to Refresh Redshift Extract


Published: 22 Oct 2019
Last Modified Date: 10 Feb 2021

Issue

When attempting to refresh a published Amazon Redshift extract, the following error occurs:
 
Error occurred while trying to execute a query: [SQLState XX000] ERROR: 1040 DETAIL: Maximum tables limit exceeded. The maximum number of tables per cluster is 9900 for this instance type. The limit includes permanent and temporary tables.

Environment

  • Tableau Online
  • Amazon Redshift

Resolution

As a workaround, disable temporary tables on Amazon Redshift. 

Cause

Tableau creates temporary tables (temp tables) on the database during queries in order to improve overall performance. If creation of one of these temp tables would push the Amazon Redshift cluster over the maximum number of 9900, the operation fails.
Did this article resolve the issue?