Error: You Have Over 9,000 Tables In Your Data Warehouse

Issue

The connector fails with the following error:

You Have Over 9,000 Tables In Your Data Warehouse.

Environment

Redshift destination

Resolution

Option 1

Do the following:

1. Check if there is another service apart from Fivetran creating tables in your destination.

2. Delete the tables.

3. Prevent the creation of new tables by other applications in the same destination configured with Fivetran.

Option 2

Ask your Redshift system administrator to upgrade the cluster used to allow more tables.

Cause

In Amazon Redshift, you can create a maximum of 9900 tables for large and xlarge cluster types. Redshift throws an error when 90% of this limit is reached causing your connectors to stop syncing.