Issue

The connector fails with the following alert error:

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

Environment

Destination: Amazon Redshift

Resolution

Option 1

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 system administrator to upgrade the cluster used to allow more tables.

Cause

In Amazon Redshift, 9900 tables are the maximum number of tables you can create for large and x-large cluster types. There is an error thrown when 90% of this limit is reached that will make your connectors stop syncing.